A market leading manufacturer of outdoor recreation clothing is keen to develop new products so that the
Question:
A market leading manufacturer of outdoor recreation clothing is keen to develop new products so that the company can expand into Asian markets. Assume you are the advisor for this company and you have been asked to investigate the market for outdoor recreation clothing products. You have been asked to study the characteristics of currently available outdoor recreation clothing so the company will be in a better position to develop and price upcoming products. You have collected data for 333 products on the market. The data is in the excel file, named 'Clothing'. Column 1: GENDER 1 for Female product and 2 for Male product. Column 2: CLOTHING LINE 1 for Surf, 2 for Snow, 3 for Trail Running, and 4 for Mountain Bike. Column 3: PRICE Price of the clothing line in dollars. Column 4: COUNTRY 1 made in USA, 2 made in Japan, 3 made in Australia.
Calculate descriptive statistics and visually present data for different countries. What conclusions can you draw from your analysis by commenting on the location, shape and variability of those distributions.
GENDER | CLOTHING LINE | PRICE | COUNTRY |
1 | 1 | 69 | 3 |
1 | 2 | 79 | 1 |
2 | 3 | 101 | 1 |
2 | 3 | 99 | 3 |
2 | 3 | 121 | 2 |
1 | 4 | 134 | 1 |
1 | 4 | 109 | 1 |
1 | 1 | 106 | 1 |
1 | 2 | 108 | 3 |
1 | 2 | 54 | 3 |
2 | 1 | 119 | 3 |
1 | 4 | 125 | 2 |
1 | 4 | 45 | 1 |
2 | 3 | 156 | 3 |
2 | 1 | 84 | 2 |
2 | 2 | 111 | 1 |
1 | 4 | 199 | 3 |
1 | 3 | 234 | 2 |
1 | 2 | 229 | 1 |
1 | 1 | 154 | 2 |
2 | 3 | 69 | 2 |
2 | 3 | 79 | 2 |
2 | 3 | 101 | 2 |
2 | 4 | 99 | 1 |
1 | 2 | 121 | 1 |
1 | 4 | 134 | 2 |
1 | 1 | 109 | 2 |
2 | 3 | 37 | 3 |
2 | 4 | 95 | 2 |
2 | 2 | 66 | 1 |
2 | 1 | 29 | 1 |
2 | 1 | 33 | 2 |
2 | 3 | 108 | 2 |
1 | 3 | 199 | 1 |
1 | 4 | 267 | 1 |
1 | 3 | 99 | 2 |
2 | 4 | 345 | 3 |
1 | 2 | 49 | 3 |
2 | 1 | 77 | 1 |
2 | 2 | 51 | 1 |
1 | 3 | 146 | 1 |
2 | 1 | 66 | 2 |
2 | 2 | 109 | 3 |
1 | 3 | 37 | 3 |
2 | 4 | 95 | 1 |
1 | 3 | 66 | 2 |
2 | 4 | 29 | 1 |
1 | 2 | 33 | 3 |
2 | 2 | 108 | 1 |
2 | 1 | 199 | 2 |
2 | 3 | 267 | 2 |
2 | 1 | 99 | 1 |
2 | 4 | 345 | 2 |
1 | 1 | 49 | 2 |
1 | 2 | 77 | 1 |
1 | 1 | 51 | 3 |
2 | 4 | 146 | 2 |
1 | 2 | 66 | 3 |
2 | 2 | 123 | 2 |
2 | 1 | 91 | 2 |
2 | 2 | 136 | 2 |
2 | 3 | 234 | 1 |
2 | 3 | 157 | 1 |
2 | 3 | 162 | 2 |
1 | 4 | 345 | 2 |
2 | 4 | 389 | 1 |
2 | 1 | 124 | 2 |
1 | 2 | 231 | 1 |
1 | 2 | 204 | 3 |
1 | 1 | 66 | 2 |
2 | 4 | 299 | 1 |
2 | 4 | 146 | 1 |
2 | 3 | 66 | 3 |
2 | 1 | 123 | 3 |
1 | 2 | 91 | 3 |
1 | 4 | 136 | 2 |
2 | 3 | 234 | 3 |
1 | 2 | 157 | 1 |
1 | 1 | 162 | 1 |
1 | 3 | 345 | 2 |
1 | 3 | 389 | 1 |
1 | 3 | 124 | 3 |
1 | 4 | 231 | 1 |
2 | 2 | 204 | 2 |
2 | 4 | 378 | 2 |
2 | 1 | 101 | 2 |
1 | 3 | 108 | 2 |
1 | 4 | 321 | 1 |
1 | 2 | 136 | 1 |
1 | 1 | 234 | 3 |
2 | 1 | 157 | 2 |
1 | 3 | 162 | 1 |
1 | 3 | 345 | 1 |
1 | 4 | 389 | 3 |
1 | 3 | 124 | 1 |
2 | 4 | 231 | 2 |
1 | 2 | 204 | 1 |
1 | 1 | 378 | 3 |
1 | 2 | 101 | 1 |
1 | 3 | 108 | 2 |
2 | 1 | 321 | 2 |
1 | 2 | 234 | 1 |
1 | 3 | 401 | 2 |
2 | 4 | 58 | 1 |
2 | 3 | 87 | 2 |
2 | 4 | 99 | 2 |
1 | 2 | 196 | 3 |
2 | 2 | 101 | 2 |
2 | 1 | 211 | 1 |
1 | 3 | 345 | 3 |
1 | 1 | 99 | 2 |
2 | 2 | 134 | 2 |
2 | 1 | 111 | 1 |
2 | 1 | 108 | 3 |
2 | 3 | 333 | 2 |
1 | 3 | 328 | 2 |
1 | 4 | 427 | 1 |
2 | 3 | 301 | 3 |
1 | 4 | 399 | 1 |
1 | 2 | 201 | 1 |
1 | 1 | 189 | 2 |
2 | 2 | 299 | 3 |
2 | 3 | 201 | 3 |
1 | 1 | 57 | 2 |
1 | 2 | 68 | 3 |
2 | 3 | 201 | 2 |
2 | 4 | 201 | 2 |
1 | 3 | 78 | 1 |
2 | 4 | 327 | 1 |
1 | 2 | 427 | 1 |
2 | 2 | 327 | 2 |
2 | 1 | 27 | 3 |
2 | 3 | 127 | 3 |
2 | 1 | 127 | 2 |
1 | 4 | 311 | 2 |
1 | 2 | 126 | 2 |
2 | 1 | 68 | 3 |
2 | 3 | 187 | 3 |
1 | 3 | 231 | 2 |
1 | 3 | 222 | 2 |
1 | 4 | 327 | 3 |
2 | 2 | 212 | 3 |
2 | 4 | 327 | 2 |
2 | 1 | 27 | 2 |
1 | 3 | 311 | 1 |
2 | 4 | 432 | 2 |
1 | 2 | 123 | 1 |
1 | 1 | 99 | 1 |
2 | 1 | 111 | 2 |
1 | 3 | 222 | 3 |
1 | 3 | 327 | 2 |
1 | 1 | 84 | 3 |
1 | 1 | 94 | 2 |
1 | 3 | 237 | 2 |
1 | 3 | 298 | 2 |
1 | 4 | 401 | 3 |
1 | 3 | 199 | 1 |
2 | 4 | 321 | 2 |
1 | 2 | 111 | 2 |
1 | 1 | 67 | 1 |
1 | 2 | 127 | 2 |
1 | 3 | 284 | 3 |
2 | 1 | 94 | 2 |
1 | 2 | 137 | 2 |
1 | 3 | 298 | 2 |
2 | 4 | 136 | 3 |
2 | 3 | 234 | 3 |
2 | 4 | 157 | 2 |
1 | 2 | 162 | 2 |
1 | 2 | 345 | 1 |
1 | 1 | 389 | 3 |
1 | 3 | 124 | 2 |
1 | 1 | 231 | 2 |
1 | 1 | 204 | 2 |
2 | 1 | 378 | 1 |
1 | 3 | 101 | 2 |
1 | 3 | 108 | 2 |
1 | 4 | 321 | 2 |
1 | 3 | 234 | 1 |
2 | 4 | 401 | 3 |
1 | 2 | 58 | 3 |
1 | 1 | 87 | 2 |
1 | 2 | 99 | 2 |
1 | 3 | 196 | 3 |
2 | 1 | 101 | 1 |
1 | 2 | 211 | 2 |
1 | 3 | 345 | 1 |
1 | 4 | 444 | 2 |
2 | 3 | 234 | 3 |
2 | 4 | 389 | 2 |
1 | 2 | 178 | 1 |
1 | 2 | 183 | 2 |
1 | 1 | 134 | 2 |
1 | 3 | 111 | 1 |
1 | 1 | 108 | 2 |
2 | 1 | 124 | 2 |
2 | 2 | 234 | 2 |
2 | 3 | 427 | 2 |
2 | 3 | 301 | 3 |
2 | 3 | 399 | 3 |
2 | 4 | 201 | 2 |
1 | 4 | 427 | 2 |
1 | 1 | 68 | 3 |
2 | 2 | 101 | 3 |
1 | 2 | 127 | 2 |
1 | 1 | 78 | 3 |
1 | 4 | 327 | 3 |
2 | 4 | 427 | 2 |
1 | 3 | 327 | 1 |
2 | 1 | 27 | 3 |
1 | 2 | 127 | 3 |
2 | 4 | 401 | 2 |
1 | 3 | 311 | 3 |
2 | 2 | 145 | 2 |
1 | 1 | 87 | 2 |
2 | 3 | 239 | 1 |
1 | 3 | 248 | 3 |
2 | 3 | 296 | 2 |
1 | 4 | 189 | 2 |
1 | 2 | 101 | 1 |
1 | 4 | 229 | 3 |
1 | 1 | 69 | 3 |
2 | 3 | 254 | 1 |
2 | 4 | 101 | 3 |
2 | 2 | 167 | 2 |
2 | 1 | 78 | 2 |
1 | 1 | 72 | 1 |
1 | 3 | 178 | 2 |
2 | 3 | 199 | 3 |
1 | 4 | 222 | 2 |
2 | 3 | 109 | 1 |
1 | 4 | 222 | 2 |
2 | 2 | 212 | 2 |
2 | 1 | 77 | 3 |
2 | 2 | 108 | 2 |
1 | 3 | 257 | 3 |
2 | 1 | 77 | 3 |
1 | 2 | 136 | 2 |
2 | 3 | 234 | 2 |
1 | 4 | 389 | 2 |
2 | 3 | 178 | 3 |
1 | 4 | 183 | 2 |
2 | 2 | 134 | 2 |
1 | 2 | 111 | 3 |
1 | 1 | 108 | 3 |
1 | 3 | 124 | 2 |
2 | 1 | 234 | 3 |
2 | 4 | 427 | 2 |
2 | 1 | 111 | 1 |
2 | 2 | 222 | 2 |
2 | 1 | 99 | 1 |
1 | 4 | 222 | 2 |
1 | 2 | 327 | 3 |
2 | 2 | 212 | 3 |
1 | 1 | 87 | 2 |
2 | 2 | 127 | 2 |
1 | 3 | 311 | 3 |
2 | 3 | 432 | 2 |
2 | 3 | 223 | 1 |
2 | 4 | 199 | 2 |
1 | 4 | 219 | 1 |
2 | 1 | 46 | 3 |
1 | 2 | 327 | 1 |
2 | 2 | 84 | 2 |
1 | 1 | 94 | 2 |
2 | 4 | 237 | 3 |
1 | 4 | 298 | 3 |
2 | 3 | 401 | 2 |
2 | 1 | 199 | 2 |
1 | 2 | 321 | 3 |
1 | 4 | 311 | 2 |
2 | 3 | 198 | 1 |
2 | 2 | 127 | 3 |
2 | 1 | 78 | 2 |
2 | 3 | 294 | 2 |
2 | 3 | 199 | 1 |
1 | 3 | 298 | 3 |
1 | 4 | 236 | 2 |
2 | 2 | 234 | 3 |
1 | 4 | 357 | 2 |
2 | 1 | 66 | 1 |
1 | 3 | 222 | 2 |
2 | 4 | 327 | 1 |
2 | 2 | 212 | 1 |
2 | 1 | 87 | 2 |
1 | 1 | 27 | 1 |
2 | 3 | 311 | 2 |
1 | 3 | 432 | 2 |
2 | 4 | 223 | 1 |
1 | 3 | 299 | 3 |
2 | 4 | 222 | 2 |
2 | 2 | 111 | 2 |
2 | 1 | 27 | 1 |
1 | 2 | 84 | 3 |
1 | 3 | 194 | 3 |
1 | 1 | 89 | 2 |
2 | 2 | 189 | 3 |
2 | 3 | 199 | 3 |
1 | 4 | 401 | 2 |
2 | 3 | 321 | 2 |
2 | 4 | 333 | 2 |
2 | 2 | 67 | 1 |
2 | 2 | 127 | 2 |
2 | 1 | 67 | 3 |
2 | 3 | 194 | 2 |
2 | 1 | 137 | 3 |
1 | 2 | 298 | 2 |
1 | 1 | 136 | 1 |
2 | 1 | 124 | 3 |
2 | 3 | 257 | 2 |
2 | 3 | 231 | 2 |
2 | 4 | 222 | 1 |
2 | 3 | 327 | 3 |
2 | 4 | 212 | 2 |
2 | 2 | 127 | 2 |
2 | 1 | 27 | 1 |
2 | 2 | 111 | 3 |
2 | 3 | 432 | 2 |
1 | 1 | 123 | 1 |
1 | 2 | 99 | 2 |
2 | 3 | 223 | 2 |
2 | 4 | 222 | 1 |
2 | 3 | 327 | 1 |
1 | 4 | 284 | 3 |
2 | 2 | 94 | 1 |
1 | 2 | 237 | 1 |
2 | 1 | 98 | 1 |
2 | 3 | 401 | 1 |
1 | 1 | 199 | 2 |
2 | 4 | 321 | 1 |
2 | 2 | 111 | 2 |
2 | 1 | 67 | 1 |
1 | 3 | 227 | 3 |