Statistics homework. Provide all excel formulas and a description.

6 . The meat-packing department of a grocery store chain packs ground beef in two-pound packages. Supervisors are concerned that their machine is no longer packaging the beef to the required specifications. To test the claim that the mean weight of the ground beef portions is not 2.00 pounds, the supervisors took a simple random sample of 24 packages of beef. Describe the Type I error that can be made in relation to this context of the weight of ground beef packages, if testing this claim through a formal hypothesis test on collected sample data. The Type I error that can be made is rejecting the true null hypothesis ( the mean weight of the ground beef portions is two pounds) and believing that the mean weight of such portions is not equal to two pounds. 7. Weights of 24 Packages of Ground Beef To test the claim from the problem posed in #6, the data from the 24 randomly selected packages is shown at the right. Assume 2.00 1.96 .87 1.79 2.27 2.02 the weights are normally distributed. 2.21 2.09 1.89 2.21 2.29 1.95 2.04 2.2 2.45 2.04 2.10 2.18 1.98 2.10 2.61 1.76 2.11 2.22 (a) Give the null and alternative hypotheses for this situation using correct mathematical notation. (b) Based upon a 1% level of significance, determine the critical value(s) associated with this hypothesis test. c) Determine the sample's test statistic. (d) State the conclusion of your hypothesis test based on test statistic and p-value and explain why. (e) Write a final interpretive sentence using the context of this