Question: 2 Suppose that before the sample in question 1 was taken, the manager asked you to determine the sample size required to be 95% confident

2 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. b. c. d. e. 2 Points: Calculate the appropriate value of Z in cell F26 using a built-in Excel function based off of 95% confidence. 2 Points: Input the assumed standard deviation in cell F27. 2 Points: Input the maximum allowed margin of error (MOE) in cell F28. 4 Points: Calculate the necessary sample size (n) in cell F29 by writing a formula that references the appropriate cells. 4 Points: Calculate the necessary sample size (n) using StatTools. Place your StatTools output with an upper left hand cell in cell O11. Place the cell reference for the value from StatTools in cell F30. 1 Grade = 100 Question Worth 1 2 3 4 5 Total 20 14 12 40 14 100 Points Lost 0 0 0 0 0 0 Can # 1 2 3 4 5 6 7 8 9 10 Ounces 12.74 12.5445 12.8489 13.0553 13.0397 13.1466 12.3633 12.7532 13.019 12.5827 11 12 13 14 12.662 12.4619 12.4306 12.6045 15 16 12.6453 12.3764 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 12.6864 12.7192 12.827 12.7269 12.7346 12.726 13.0685 12.7829 12.7628 12.6974 13.1944 12.9731 13.2751 12.669 13.1323 12.4775 12.9078 12.9804 13.1838 12.7831 12.6952 12.935 Question 1 Confidence Interval Estimate for the True Mean Fill Level of Soda in 12 OZ Cans Sample Statistics Mean = Std Dev = SE = Grader Confidence Interval I/O df = t= MOE = a b c Grader d e f C. I. for m LL UL Conclusion:

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!

Question 2 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...

Can # Ounces 1 12.74 2 12.5445 3 12.8489 4 13.0553 5 13.0397 6 13.1466 7 12.3633 8 12.7532 9 13.019 10 12.5827 11 12.662 12 12.4619 13 12.4306 14 12.6045 15 12.6453 16 12.3764 17 12.6864 18 12.7192...

Need help please in this Homework 3 Blackboard X A *Question Completion Status: O d) 0.0228 O a) 0.9537 O b) 0.6687 QUESTION 3 2. Assume a population has a distribution with a mean of 100 and a...

Given the findings presented by Desir et al. 2010, what evidence do they provide that might explain why there were so many people who opposed the proposed standard to enhance disclosures on expected...

A global manufacturer of electrical switching equipment (ESE) is considering outsourcing the manufacturing of an electrical breaker used in the manufacturing of switch boards. The company estimates...

Using the data in P4-2 and a piece of graph paper: 1. Plot the data points on the graph and draw a line by visual inspection, indicating the trend shown by the data points. 2. Determine the variable...

Which of the following makes ESOP less attractive the inability to serve as a takeover defense less diversification of investment risks give employees the right to vote their accurate and high levels...

2023 1040 form 1.Phillip and Claire are married and file a joint return. Phillip is self-employed as a real estate agent, and Claire is a flight attendant. Phillip and Claire have three dependent...