GB 513 RANK Imagine Your Future /gb513rank.com GB 513 RANK Imagine Your Future /gb513rank.com | Page 3

Utah 4.17 California 4.00 Texas 3.30 Minnesota 3.21 Alaska 2.74
Missouri 2.08 Colorado 2.05 Michigan 2.05 Wyoming 1.89 Georgia
1.85
New Mexico 1.81 Pennsylvania 1.68
a) Using the data analysis toolpak in Excel, calculate the descriptive
statistics.
b) Briefly explain what each of the metrics in the summary statistics
means.
c)
Commentonthefiguresinthereport.Whataretheytellingyouaboutthisd
ataset?Isit
symmetrical, flat, skewed, does it have outliers, and so on?
Question 3
Suppose Procter & Gamble sells about 20 million bars of soap per
week, but the demand is not constant, and production management
would like to get a better handle on how sales are distributed over
the year. Let the following sales figures given in units of million bars
represent the sales of bars per week over one year. Construct a
histogram to represent these data. What do you see in the graph that
might be helpful to the production (and sales) people?
17.1 17.1 17 25.2 19.6 12.2 18.3 26.3 15.4 19.9 13.6 23.9 17.4 18.7 39.8
30.6
15 20.4 20.7 25.2 18.5 20.3 21.3 26.2 20.6 15.5 22.5 26.9 18.4 16.8 21.4
32.8