According to a recent study annual per capita consumption ofmilk in the United States is 22.6 gallons. Being from the Midwest,you believe milk consumption is higher there and wish to test yourhypothesis. A sample of 14 individuals from the Midwestern town ofWebster City was selected and then each person's milk consumptionwas entered into the Microsoft Excel Online file below. Use thedata to set up your spreadsheet and test your hypothesis.

Gallons of Milk
28.3
23.84
25.25
21
17.52
19.61
19.83
26.18
34.97
30.1
28.59
20.57
26.94
27.24

Open spreadsheet

1. Develop a hypothesis test that can be used to determine whetherthe mean annual consumption in Webster City is higher than thenational mean.

   H₀: ? _________> 22.6≥ 22.6= 22.6≤22.6< 22.6≠ 22.6

   H_a: ? _________> 22.6≥ 22.6= 22.6≤22.6< 22.6≠ 22.6

2. What is a point estimate of the difference between mean annualconsumption in Webster City and the national mean?

   (2 decimals) ______

3. At ? = 0.01, test for a significant difference by completingthe following.

   Calculate the value of the test statistic (2 decimals).

   _______

   The p-value is  (4 decimals)

4. Reject the null hypothesis?

   _____NoYes

   What is your conclusion?

   _________There is insufficient evidence to conclude that thepopulation mean consumption of milk in Webster City is greater thanthe hypothesized mean.Conclude the population mean consumption ofmilk in Webster City is greater than the hypothesized mean.