\"301'22, 3:16 PM JDEAS 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. Like Slippers, the footwear shopping destination for seniors, wants to solve a problem it knows far too many people have: Which size shoes will fit? The company launches a mobile app Shoe Ruler 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. Sarah Simeoni, Margaret Robinson, and Gabriela Hernandez are degree students from the Humber Fashion Management program. They have been hired by Like Slippers to manage inventory, cut down on returns, and monitor the results the app shows. One of the questions that Sarah Simeoni, Margaret Robinson, and Gabriela Hernandez 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. 24 251 24 249 258 280 238 244 265 1. Help Sarah Simeoni, Margaret Robinson, and Gabriela Hernandez 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. httpsimathashumbercafa ssesskidzsiaid: 16634#1pri111 217 1/30/22, 8:16 PM IDEAS 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 Size Class Frequency % Frequency 5 215.85 - 220.10 5.5 220.10 - 224.35 6 224.35 - 228.60 6.5 228.60 - 232.85 7 232.85 - 237.10 7.5 237.10 - 241.35 8 241.35 - 245.60 8.5 245.60 - 249.85 9 249.85 - 254.10 9.5 254.10 - 258.35 10 258.35 - 262.60 10.5 262.60 - 266.85 11 266.85 - 271.10 11.5 271.10 - 275.35 12 275.35 - 279.60 12.5 279.60 - 283.85 https://imathas.humber.ca/assess2/?cid=558&aid=16634#/print 3/7\"301'22, 8:16 PM JDEAS 283.85 288.10 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 2 (Normal) ort (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. skewed to the left and unimodal symmetric and approximately bellshaped skewed to the right and unimodal symmetric and flat asymmetrical with several peaks 3. One more important issue that Sarah Simeoni, Margaret Robinson, and Gabriela Hernandez helped to analyze was shoe colour. Their report had to contain a pie chart representing the distribution of shoe colors. A separate survey was conducted through the social network and the female respondents were asked to indicate their preferred summer shoe colour. The survey resulted in the following table. hnpsimathashumbercai'assesskidziisiaid:16634#lerim 417 1/30/22, 8:16 PM IDEAS White 11 Green 10 Red 7 Orange 8 Yellow 5 Sarah Simeoni, Margaret Robinson, and Gabriela Hernandez got the following chart. Yellow 5% 5% 8% Orange 21% 8% Red 7% 7% Green 10% 10% 17% White 11% 11% Purple 9% 12% 9% Using Excel, construct the pie chart and compare it with the given one. Please select the most appropriate comment regarding the given chart. O Sarah Simeoni, Margaret Robinson, and Gabriela Hernandez got the correct pie chart. It is simple and easy-to-understand. O Unfortunately, the pie chart contains the wrong percent values. Probably wrong data was enetered in Excel Input Range. It should be corrected. I found a number of misprints. The pie chart contains some additional percent and color labels. O The pie chart contains some slips. Some percent and color labels are missing. https://imathas.humber.ca/assess2/?cid=558&aid=16634#/print 5/71/30/22, 8:16 PM IDEAS O In this particular case color selection plays important role in data representation. The chart should be corrected as color of slice should correspond to the actual shoe color. Note: Do not forget to attach the original Excel file with your version of the pie chart. 4. Marketing department of Like Slippers wants to reach the leading social media used by the store customers. Using the results of a survey (see table below), Sarah Simeoni, Margaret Robinson, and Gabriela Hernandez constructed a bar graph representing number of the customers and their preferable social media platforms. Social Number of Media customers Platform YouTube 95 Instagram 254 Linkedin 289 Facebook 46 Pinterest 82 Twitter 63 WhatsApp 171 The following bar graph is a draft. "Customer Social Media Preference (2021)" 250 200 150 100 50 YouTube Instagram Linkedin Facebook Pinterest Twitter Wha Social Media Platforms https://imathas.humber.ca/assess2/?cid=558&aid=16634#/print 6/7\"301'22, 8:16 PM JDEAS The draft does not satisfy the department's manager because the horizontal axis title is wrong. Also, the vertical axis title is missing. the bar labels are missing. some values of customers numbers are wrong, and the vertical axis title is missing. he does not trust the new employees. The draft is correct, but the manager does not want to maintain an open relationship with the new employees. the bar labels and the vertical axis title are missing. Note: Do not forget to attach the original Excel file with your version of the bar graph. Question Help: 8 Message instructor hnpsimathashumbercau'a ssesskidzsiaid: 166W!prin1 717