Ironically, 3 in 5 people are wearing the wrong shoe size, as the shoe industry research shows. The biggest reason for shoes being returned when they were purchased online ? is because of size. My Favorite Shoes, the online shopping shoe store, wants to solve a problem it knows far too many people have: Which size shoes will fit? The company launches a mobile app My Favorite Shoes Fit that scans customers' feet and determines the correct size.The main parameter used by the app is the length (in millimeters) of a person's foot defined as the distance between two parallel lines that are perpendicular to the foot and in contact with the most prominent toe and the most prominent part of the heel.

Jennifer Nguyen, Amandeep Kaur, and Mary O'Brian are degree students from the Humber Fashion Management program. They have been hired by My Favorite Shoes to manage inventory, cut down on returns, and monitor the results the app shows. One of the questions that Jennifer Nguyen, Amandeep Kaur, and Mary O'Brian must analyze is the distribution of shoe sizes of the buyers. The data table below shows the app results received from a random sample of 100 customers.

1. Help Jennifer Nguyen, Amandeep Kaur, and Mary O'Brian to construct a histogram of foot lengths using the provided data. You must apply Excel method and attach your original Excel file with histogram and frequency table. To identify the bins, use the column Class in the table below. Based on the Excel result, please fill out the table below. Note: By default, Excel provides a cumulative frequency value in percent. Do not put percentage sign into the answer nodes in Cumulative % Frequency column. Cumulative 9% Size Class Frequency Frequency 215.85 - 220.10 Enter an integer or deanud number [more] 4 5.5 220.10 - 224.35 224.35 - 228.60 5.5 228.60 - 232.85 242.85 - 237.10 237.10 - 241.35 241,35 - 245.60 245.60 - 249.85 249.85 - 254.10 254.10 - 258.35 258 35 - 202 60 Q258.35 - 262.60 10.5 262.60 - 266.85 E 266.85 - 271.10 11.5 271.10 - 275.35 275.35 - 279.60 4 12.5 279.60 - 283.85 283.85 - 288.10 13.5 288.10 - 292.35 292.35 - 296.60 Which size appears most frequently? 2. The main question regarding the distribution is whether it is symmetric and bell- shaped, If so, then the classical methods based on z (Normal) or t (Student) distribution can be used for statistical market analysis. If the distribution is skewed or not unimodal, the different statistical tools should be applied. Please select the most appropriate comment regarding the shape of the distribution O asymmetrical with several peaks O skewed to the left and unimodalthe distribution Of SiToo received from a random sample of 100 customers. 259 249 262 256 255 247 266 236 251 257 261 248 240 254 270 263 254 265 294 289 255 228 254 243 255 262 247 271 250 258 254 251 245 249 254 252 264 258 250 278 262 238 274 242 252 254 258 263 250 253 255 248 233 247 275 264 268 254 268 262 253 219 259 246 286 249 250 242 255 280 239 250 248 254 248 252 253 249 250 232 256 255 240 251 255 261 239 248 242 223 247 228 242 245 252 277 277 249 252 282 1. Help Jennifer Nguyen, Amandeep Kaur, and Mary O'Brian to construct a histogram foot lengths using the provided data. You must apply Excel method and attach your14 292.35 - 296.60 Which size appears most frequently? 2. The main question regarding the distribution is whether it is symmetric and bell- shaped. If so, then the classical methods based on z (Normal) or t (Student) distribution can be used for statistical market analysis. If the distribution is skewed or not unimodal, the different statistical tools should be applied. Please select the most appropriate comment regarding the shape of the distribution. O asymmetrical with several peaks O skewed to the left and unimodal O symmetric and flat O skewed to the right and unimodal O approximately symmetric and bell-shaped