Here is sample data showing the weight of coffee beans in bags labeled 5 pounds.The data is in pounds.

5.75 4.82 5.25 5.96 4.59 4.52 5.06 5.67 5.73 4.71 5.5 5.84 4.82 5.98 4.89 5.39 4.73 4.96 5.59 4.86 4.94 4.9 4.71 4.99 5.61 5.26 5.3 4.92 4.54 4.58 4.59 4.72 4.6 4.67 5 4.97 5.47 4.88 5.02 5.27 5.85 4.67 4.91 5.63 5.1 5.7 4.91 5.62 4.99 5.95 4.76 5.95 4.91 5.81 4.54 5.91 4.91 4.63 4.81 5.73 4.93 5.81 4.7 5.82 5.84 5.9 5.75 4.61 5.77 5.83 4.58 4.63 4.66 5.57 4.76 5.5 5.84 5.1 5.63 5.72

For the following questions, you must use Excel formulas in the cells so that Excel calculates the answers for you.

1) Compute the mean:

Compute the median

Find the mode

2) Compute the first quartile; use =QUARTILE.EXC() First Quartile Compute the third quartile; use =QUARTILE.EXC()

third Quartile Compute the interquartile range

3) Find the largest number Find the smallest number What is the range?

4) What is the difference between the Excel functions, STDEV.P and STDEV.S?

5) What is the Variance?

6) What is the standard deviation?

7) What is the Coefficient of Variation, or the CV?

When is the Coefficient of Variation especially useful?

Copy all of the data into a column, use Column M and go from cell M1:M80

8) Use the Data Analysis tool on the numbers just copied to find the Descriptive Statistics: Click on Data Analysis and Choose Descriptive Statistics Click on the Summary Statistics box.

Highlight the mean, median, mode, Standard deviation, Range, Minimum, and Maximum

Notice that the Data Analysis tool gives you all of the info needed for this problem except for the quartiles, variance, and CV.

For questions 9 and 10, you are a consultant who is brought in and given these numbers and asked to generate a report to management. What would your recommendation be? These two parts are your chance to show your understanding of the material.

9) Interpret the measures of central tendency within the context of this problem. Should the company producing the coffee be concerned about the central tendency?

10) Interpret the measures of variation within the context of this problems. Should the company producing the coffee be concerned about variation?