Suppose that before the sample in question 1 was taken, the manager asked you to determine the sample size required to be 95% confident of the final estimation result within a margin of error of 0.035 ounces. You assume the standard deviation of the filling machine is 0.20 based on the manufactures specifications. Based on the information above, determine the best sample size of cans to take to estimate the true mean fill level. Place your answers for Question 2 in the worksheet named Nagel 1. a. 2 Points: Calculate the appropriate value of Z in cell F26 using a built-in Excel function based off of 95% confidence.
b. 2 Points: Input the assumed standard deviation in cell F27.
c. 2 Points: Input the maximum allowed margin of error (MOE) in cell F28.
d. 4 Points: Calculate the necessary sample size (n) in cell F29 by writing a formula that references the appropriate cells.
e. 4 Points: Calculate the necessary sample size (n) using StatTools, Place your StatTools output with an upper left hand cell in cell 011. Place the cell reference for the value from StatTools in cell F30.