Group Graded Assignment 6 InstructionsQuestion 1The production manager of Nagel Beverage Company is responsible for monitoring the filling operationof soft drink cans. His company has recently installed a new machine. The filling machine has anadjustment that allows the operator to adjust the mean fill level. However, no matter what the setting, theindividual 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 machinefor several hours, a sample of 100 cans is selected and the volume in each can is measured in thecompany’s quality testing lab. The manager wants you to use the sample data in the worksheet namedNagel 1to decide if the machine’s fill average is 12 ounces or if the machine has gone out of adjustmentthus putting the wrong amount of soft drink (other than 12 ounces) in the cans. a.1 Point: Calculate the best point estimate of the population mean using a built-in Excelfunction. Place your answer in cell F4.b.2 Points: Calculate the sample standard deviation using a built-in Excel function. Placeyour answer in cell F5.c.2 Points: Calculate the standard error of the mean by writing a formula in cell F6 thatreferences the appropriate cells.d.1 Point: Place the value of the degrees of freedom (df) in cell K4. e.2 Points: If an objective is to construct a 95% confidence interval estimate for the truemean fill level, calculate the appropriate value of t, placing the value calculation in cellK5, using a built-in Excel function that references the appropriate cells. Make sure t ispositive, not negative.f.2 Points: Calculate the margin of error (MOE = t*SE) in cell K6 by writing a formula thatreferences the appropriate cells.g.2 Points: Calculate the lower limit of the confidence interval (LL) in cell G12 by writing aformula that references the appropriate cells (Point Estimate – MOE)..h.2 Points: Calculate the upper limit of the confidence interval (UL) in cell I12 by writing aformula that references the appropriate cells (Point Estimate + MOE).i.2 Points: Based on your confidence interval results, make a conclusion regarding themachine. In cell K12/13 write either the word “Over”, “Under” or “Correctly” to indicateyour conclusion.
The post Group Graded Assignment appeared first on My Assignment Online.