Question

ANALYSIS An Australian manufacturing company is keen to develop new products and develop new product line of shoes so that the company can expand into Asian markets more than before. The data have been collected for 99 products from the market. The data are in an excel file named “SHOES”. The file includes: PRICE: Price of the shoes in dollars. GENDER: 1 for Female product and 2 for Male product. COUNTRY: the country in which the shoes is produced: 1 made in Thailand, 2 made in Singapore and 3 made in China. COST: Production cost of the shoes in dollars.

questions:

1. Calculate the Mean, Median, Mode, Standard Deviation and Coefficient of Variation, for

prices for men and women shoes, separately. Compare the figures and explain that what

conclusions you can draw from these analyses? Draw a box and Whisker plot for men and

female shoes prices and comment on the shape of the graph.

2. Calculate the Mean, Median, Mode, Standard Deviation and Coefficient of Variation for

prices for the three countries – Thailand, Singapore and China, separately. Compare the figures

and explain what conclusions you can draw from these analyses? Draws a Box and Whisker

plot for each country and comment on the shape of the graph.

COST	GENDER	COUNTRY	PRICE
177	1	1	395
143	1	1	400
163	1	1	304
186	1	1	274
124	1	1	371
43	1	1	355
112	1	1	154
186	1	1	261
124	1	1	258
43	1	1	280
112	1	1	240
186	1	1	314
124	1	1	273
112	1	1	366
265	1	1	372
185	1	1	353
223	2	1	314
213	2	1	294
183	1	1	222
173	1	2	182
143	1	2	161
143	1	2	193
163	1	2	260
133	1	2	198
207	1	2	215
265	1	1	353
133	2	1	386
123	2	1	303
29	2	1	225
29	2	1	171
193	2	1	291
183	2	1	350
139	2	1	315
133	1	2	308
73	1	2	156
83	1	2	313
159	1	2	364
188	1	2	192
139	1	2	151
89	1	2	390
75	1	2	211
69	1	2	306
75	1	2	210
69	1	2	334
55	1	2	247
55	1	3	341
55	1	3	238
41	1	3	299
49	1	3	183
51	1	2	200
45	1	2	271
65	1	2	350
65	1	2	361
43	1	2	250
43	2	2	244
185	2	2	274
185	2	2	388
183	2	2	348
117	2	2	163
111	1	2	172
177	1	2	399
97	2	2	360
69	2	2	244
57	2	2	233
65	2	2	319
36	2	2	337
38	1	3	259
34	1	3	361
36	1	3	381
183	2	3	323
38	2	3	231
138	2	3	205
199	2	1	289
243	2	1	297
163	2	1	356
252	2	1	345
223	2	1	298
213	2	1	285
153	2	1	311
159	2	1	269
188	2	1	340
36	2	3	276
46	2	3	373
126	2	3	287
66	2	3	367
48	2	3	157
116	1	3	155
193	1	3	335
183	1	3	367
139	1	3	345
117	2	3	153
111	2	3	396
69	2	3	277
66	2	3	246
175	2	3	352
155	2	3	380
74	2	3	278
66	2	3	153
175	2	3	209

Answer 1

COUNTRI -7 PRICE 341 238 299 183 259 361 381 323 231 205 276 373 287 367 157 به د د د د د د د د د د د د د د ن د ده ده نه د ده دا ده ده نه ده NNNNNNNNN - ANNNNNNNN 155 335 367 153 396 277 246 352 380 278 153 209 266.4093933 mean for china 282.5301205 median 361 mode 71.70870494 SD 26.91673295 Coefficient of variation=((standard deviation)/mean)*100 Sheet3 93 Sheet1 Sheet2 119 records found

260 198 215 308 156 313 364 192 151 390 211 306 210 334 247 200 271 350 361 250 244 274 388 348 163 172 399 360 244 233 319 337 271.4680851 mean for singapore 271 median 350 mode 74.97038577 SD 27.6166481 Coefficient of variation=((standard deviation)/mean)*100 2 t1 Sheet2 Sheet3 ecords found

TNNNNNNNNNNNNNNNN 353 386 303 225 171 291 350 315 289 297 356 345 298 285 311 269 340 285.2962963 mean for thailand 287 median 274 mode 69.79871855 SD 24.46534338 Coefficient of variation={(standard deviation)/mean)*100 Sheet3 heet2 found

107 323 231 205 289 297 356 183 38 138 199 243 163 252 223 213 153 159 188 36 46 126 66 345 298 285 311 269 340 276 - 373 48 287 367 - 157 153 396 OR wwww to co w w w w w co wc - - 117 111 69 66 175 155 74 277 Los 66 175 00 101 246 352 380 278 153 209 280.060241 for male- mean for prices 289 for male-median for prices 350 for male-mode for prices 73.09588581 for male= standard deviation for prices 204.7125139 Coefficient of variation=(standard deviation)/mean)*100 102 103 104 105 106 107 108 109 110 111 112 020113 114 X Sheet) Shacal? Ready 45 of 99 records found the Sherler