Capstone Project Part 2 Template In the automated packaging process, equipment is set to fill boxes with a mean weight of 574 grams. This is the standard for the population. Population standard deviation is not known. 1. Calculate a 95% confidence interval for the mean weight of the cereal boxes, using the sample data given in the Excel spreadsheet labeled Cereal Weights. 2. Based on the confidence interval for the mean weight of cereal boxes, does this sample of 400 boxes provide evidence that the packaging process is meeting the company standard? Explain. 3. The company engineer decided to make adjustments to the filling equipment to correct the issue. A random sample of 30 boxes was selected and weighed after the adjustment. The data for this sample can be found in the Excel spreadsheet labeled Weights after Adjustment. Find the descriptive statistics and the 95% confidence interval for the mean weight of packages after the equipment adjustment. Using the descriptive statistics and the confidence interval, does it appear that the equipment adjustment had any effect on the weight of the packages? Explain. 4. Using the data from the Weights after Adjustment, conduct a hypothesis test, using this sample data, to determine whether the mean weight of cereal boxes is meeting the company standard mean weight 574 grams after the equipment adjustment, with the level of significance of .05. Consider carefully whether a one-tail test or a two-tail test would be more useful to management. Use the company standard mean weight as the population mean; population standard deviation is not known. Null hypothesis: ____________________________________________________ Alternative hypothesis: ______________________________________________ Critical value: ______________________________________________________ Test statistic: ______________________________________________________ (Must show calculation of test statistic.) p-value: ___________________________________________________________ Decision: __________________________________________________________ What conclusions can you draw about the population mean weight based on the hypothesis test? Was the equipment adjustment enough to meet the company standard? C