Question

Below you have data for three variables collected from a clothing boutique. The store features three lines based on price, budget, mid-range, and high fashion. The data below represents 40 items from those lines, the number of sales for each item, and the average liking score for each item based on a pre-sale focus group. Answer the following questions: 1) Using excel's formulas determine the mean, median, mode, standard deviation, and variance of the liking score. 2) Using Data Analysis, find the same values for number of sales. Liking scores: 3 3 2 4 3 3 3 3 3 1 2 3 4 2 4 4 2 3 2 3 3 4 4 2 4 4 3 3 3 3 4 3 3 3 4 3 3 3 2 4 Sales: 25 26 36 27 23 34 27 15 24 25 23 28 20 26 29 26 23 21 24 25 21 17 21 19 23 23 25 20 28 22 36 27 29 22 23 23 30 36 23 18

Answer 1

Solution:-

1)