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) Comment on the figures in the report. What are they telling you about this data set? Is it symmetrical, flat, skewed, does it have outliers, and so on?

Column1

Mean 3.29

Standard Error 0.471318313

Median 2.74

Mode 2.05

Standard Deviation 1.825407978

Sample Variance 3.332114286

Kurtosis 1.776331319

Skewness 1.484463793

Range 6.16

Minimum 1.68

Maximum 7.84

Sum 49.35

Count 15

Largest(1) 7.84

Smallest(1) 1.68

Confidence Level(95.0%) 1.010877241

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

20 19.1 23.4 26.3

20.9 20.4 23.1 26.6

19.3 15.4 22.8 24.3

18.2 20.3 21.4 26.2

14.7 17.5 24 23.8

b) Briefly explain what each of the metrics in the summary statistics means.

c) Comment on the figures in the report. What are they telling you about this data set? Is it symmetrical, flat, skewed, does it have outliers, and so on?

Column1

Mean 3.29

Standard Error 0.471318313

Median 2.74

Mode 2.05

Standard Deviation 1.825407978

Sample Variance 3.332114286

Kurtosis 1.776331319

Skewness 1.484463793

Range 6.16

Minimum 1.68

Maximum 7.84

Sum 49.35

Count 15

Largest(1) 7.84

Smallest(1) 1.68

Confidence Level(95.0%) 1.010877241

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

20 19.1 23.4 26.3

20.9 20.4 23.1 26.6

19.3 15.4 22.8 24.3

18.2 20.3 21.4 26.2

14.7 17.5 24 23.8

Please find... View Full Answer

**Download Preview:**

Question:

The U.S. Department of the Interior releases figures on mineral production. Following are the 15 leading

states in nonfuel mineral production in the United States in 2008.

State Value ($...