View the step-by-step solution to: a) Using the data analysis toolpak in Excel, calculate the

This question was answered on Sep 12, 2012. View the Answer
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?


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

Sign up to view the entire interaction

Top Answer

Dear Student Please find... View the full answer

Statistics and Probability - 8355286.doc

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 ($...

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors and customizable flashcards—available anywhere, anytime.


Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access or to earn money with our Marketplace.

    Browse Documents
  • 890,990,898

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
  • 890,990,898


    Browse existing sets or create your own using our digital flashcard system. A simple yet effective studying tool to help you earn the grade that you want!

    Browse Flashcards