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. Barefoot, the online retailer of fashion sportswear and footwear, wants to solve a problem it knows far too many people have: Which size shoes will fit? The company launches a mobile app Perfect Size 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.

Marilyn Kim, Oksana Drozd, and Jane MacAlister are degree students from the Humber Fashion Management program. They have been hired by Barefoot to manage inventory, cut down on returns, and monitor the results the app shows. One of the questions that Marilyn Kim, Oksana Drozd, and Jane MacAlister 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.

274	266	223	257	279	253	296	263	229	249
282	259	272	278	258	270	260	264	270	267
272	281	275	259	271	254	269	256	274	276
270	266	269	286	244	275	260	263	261	269
269	267	268	285	240	286	270	269	290	250
286	276	281	245	271	292	264	261	271	262
266	260	266	277	266	268	270	268	252	279
270	248	290	269	281	266	277	275	269	294
270	246	245	258	264	258	270	283	267	228
270	272	250	286	265	269	256	247	275	290

1. Help Marilyn Kim, Oksana Drozd, and Jane MacAlister 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.

Size	Class	Frequency	Cumulative % 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
13	283.85?288.10
13.5	288.10?292.35
14	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.

• symmetric and flat
• approximately symmetric and bell-shaped
• skewed to the right and unimodal
• skewed to the left and unimodal
• asymmetrical with several peaks

3. One more important issue that Marilyn Kim, Oksana Drozd, and Jane MacAlister 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.

Shoe color	Percent
Orange	7
Green	6
Purple	5
Red	13
Yellow	9
Black	8
Blue	18
White	19
Brown	15

Marilyn Kim, Oksana Drozd, and Jane MacAlister got the following chart.

(CHART 1!!!!!!!! attached below)

Using Excel, construct the pie chart and compare it with the given one.

Please select the most appropriate comment regarding the given chart.

option1 : Marilyn Kim, Oksana Drozd, and Jane MacAlister got the correct pie chart. It is simple and easy-to-understand.

option 2: Unfortunately, the pie chart contains the wrong percent values. Probably wrong data was enetered in Excel Input Range. It should be corrected.

option 3: The pie chart contains some slips. Some percent and color labels are missing.

option 4: 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.

option 5: I found a number of misprints. The pie chart contains some additional percent and color labels

4. Marketing department of Barefoot wants to reach the leading social media used by the store customers. Using the results of a survey (see table below), Marilyn Kim, Oksana Drozd, and Jane MacAlister constructed a bar graph representing number of the customers and their preferable social media platforms.

Social Media Platform	Number of customers
Twitter	240
YouTube	87
Facebook	235
Pinterest	59
Linkedin	78
Instagram	82
WhatsApp	219

The following bar graph is a draft.

"Customer Social Media Preference (2021)" (CHART 2!!!!!!! attached below)

The draft does not satisfy the department's manager because

option1: the horizontal axis title is wrong. Also, the vertical axis title is missing.

option 2: some values of customers numbers are wrong, and the vertical axis title is missing.

option 3: the bar labels/data labels and the vertical axis title are missing.

option 4: 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.

option 5: the bar labels/data labels are missing.

These are the charts attached:

CHART 2!!!!!!: