Question 5

(Problem Scenario taken from Basic Business Statistics Concepts and Applications, eighth edition, by Berenson, Levine, and Krehbiel)

A machine used for packaging seedless golden raisins is set so that the standard deviation in the weight of raisins packaged per box is 0.25 ounces.The operations manager is concerned that the machine is out of calibration and that the variability in weights significantly differs from the stated value of 0.25 ounces.

Place your answers for Question 5 in the worksheet named Raisins.

a.1 Point: Calculate the best point estimate of the population mean using a built-in Excel function.Place your answer in cell E5.

b.1 Point: Calculate the sample standard deviation using a built-in Excel function. Place your answer in cell F5.

c.4 Points:Using the StatTools One-Sample Confidence Interval, develop 95% confidence intervals for the mean weight of raisins packaged per box and the standard deviation of the weights.Place your output with the upper left hand cell in cell J5.

d.2 Points:Place the cell references for the Lower Limit and the Upper Limit of the 95% Confidence Interval for the Mean Weight of Raisins Packaged per Box from StatTools in cells D12 and F12, respectively.

e.2 Points:Place the cell references for the Lower Limit and the Upper Limit of the 95% Confidence Interval for the Standard Deviation of Weights of Raisins Packaged per Box from StatTools in cells D19 and F19, respectively.

f.4 Points: Based on your confidence interval results, make a conclusion regarding the variability in weights for a report to the operations manager.Place your statement in cell D27.

Package Weight in Number Ounces 1 15.2 2 15.0 3 14.3 4 15.3 5 15.2 6 14.4 7 15.1 8 9 15.4 15.5 10 11 15.7 15.6 12 13 14 15 15.4 15.3 15.7 15.2 16 17 15.0 15.4 18 19 20 21 22 23 24 25 26 27 28 29 30 15.5 15.1 15.3 15.6 14.3 14.9 15.1 14.6 14.8 15.3 14.5 14.6 15.1 Question 5 Confidence Interval Estimates for the Weights of Raisins Packaged p Sample Statistics Mean = Std Dev = StatTools LL Grader a b 95% C. I. for m UL