Group Graded Assignment 6 Instructions Question 1 The production manager of Nagel Beverage Company is responsible for monitoring the filling operation of soft drink cans. His company has recently installed a new machine. The filling machine has an adjustment that allows the operator to adjust the mean fill level. However, no matter what the setting, the individual cans will vary with respect to the actual volume. The filling machine has been adjusted to fill cans at an average of 12 ounces. After running the machine for several hours, a sample of 100 cans is selected and the volume in each can is measured in the company's quality testing lab. The manager wants you to use the sample data in the worksheet named Nagel 1 to decide if the machine's fill average is 12 ounces or if the machine has gone out of adjustment thus putting the wrong amount of soft drink (other than 12 ounces) in the cans. a. b. c. d. e. f. g. h. i. j. 1 Point: Calculate the best point estimate of the population mean using a built-in Excel function. Place your answer in cell F4. 2 Points: Calculate the sample standard deviation using a built-in Excel function. Place your answer in cell F5. 2 Points: Calculate the standard error of the mean by writing a formula in cell F6 that references the appropriate cells. 1 Point: Place the value of the degrees of freedom (df) in cell K4. 2 Points: If an objective is to construct a 95% confidence interval estimate for the true mean fill level, calculate the appropriate value of t, placing the value calculation in cell K5, using a built-in Excel function that references the appropriate cells. Make sure t is positive, not negative. 2 Points: Calculate the margin of error (MOE = t*SE) in cell K6 by writing a formula that references the appropriate cells. 2 Points: Calculate the lower limit of the confidence interval (LL) in cell G12 by writing a formula that references the appropriate cells (Point Estimate - MOE).. 2 Points: Calculate the upper limit of the confidence interval (UL) in cell I12 by writing a formula that references the appropriate cells (Point Estimate + MOE). 2 Points: Based on your confidence interval results, make a conclusion regarding the machine. In cell K12/13 write either the word \"Over\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: