Question

Q Search this course According to a recent study annual per capita consumption of milk in the United States is 22.6 gallons. Being from the Midwest, you believe milk consumption is higher there and wish to test your hypothesis. A sample of 14 Online file below. Use the data to set up your spreadsheet and test your hypothesis. from the Midwestern town of Webster City was selected and then each persons milk consumption was entered into the Microsoft Excel a. Develop a hypothesis test that can be used to determine whether the mean annual consumption in Webster City is higher than the national mean. b. What is a point estimate of the difference between mean annual consumption in Webster City and the national mean? (2 decdmals) c. At-0.05, test for a significant difference by completing the following. Caloulate the value of the test statistic (2 decimals). The p-v Reject the nul
Tell me what you 2 File Home Insert Data Review View Cut Lt Paste Copy Format Painter B 1 u 므abEdva Font Undo Cipboard 81 1 Gallons of Milk 28.7 23.84 25.25 21.1 17.52 19.61 9.83 34.97 30 28.59 20.57 26.94 27.24 Sheetl Display P222c
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Solution:

     We are given that: sample of 14 individuals from the Midwestern town of Webster city and each persons milk consumption was recorded.
     We have to test if mean annual milk consumption is higher than the National mean = 22.6 gallons.

Thus we use following steps:

Part a) State H0 and Ha, to test mean annual milk consumption is higher than the National mean = 22.6 gallons.

H0 : μ =22.6

Ha : μ > 22.6

Part b) The Point estimate of the difference between mean annual consumption in Webster city and the national mean.

The point estimate of difference = ar{x}- mu

where

ar{x} = rac{sum x}{n}

Thus we need to make following table:

Gallons of Milk
28.7
23.84
25.25
21.1
17.52
19.61
19.83
26.18
34.97
30
28.59
20.57
26.94
27.24
〉 ,r = 350.34

Thus sample mean is:
ar{x} = rac{sum x}{n}

350.34 14

25.02

Thus

The point estimate of difference = ar{x}- mu

The point estimate of difference = 25,02-22,6

The point estimate of difference = 2.42

Part c) At a-0.05 , test for a significant difference by completing following steps.
Calculate test statistic.

Since population standard deviation is unknown and sample size is small, we use t test statistic.

t=rac{ar{x}-mu }{s /sqrt{n}}

where

s=sqrt{rac{sum x^{2}-(sum x)^{2}/n}{n-1}}

Thus we need to make following table:

x : Gallons of Milk x^2
28.7 823.6900
23.84 568.3456
25.25 637.5625
21.1 445.2100
17.52 306.9504
19.61 384.5521
19.83 393.2289
26.18 685.3924
34.97 1222.9009
30 900.0000
28.59 817.3881
20.57 423.1249
26.94 725.7636
27.24 742.0176
sum x= 350.34 sum x^{2}=9076.1270

Thus sample standard deviation is:

s=sqrt{rac{sum x^{2}-(sum x)^{2}/n}{n-1}}

9076.1270 (350.34)2/14 14-1

9076.1270-8767.0083 13

s=sqrt{rac{309.1187 }{13}}

s=sqrt{23.77836 }

s=4.8763

Thus t test statistic is:

t=rac{ar{x}-mu }{s /sqrt{n}}

t=rac{2.42 }{4.8763 /sqrt{14}}

t=rac{2.42 }{4.8763 /3.741657 }

t=rac{2.42 }{1.303248 }

t=1.86

The P-value is:

To find P-value , we use Excel command:

Since Ha is > type, so this is right tailed test, thus we use following excel command:
=T.DIST.RT(x , df )

where x = t = 1.86 and df = n - 1 = 14 - 1 = 13

Thus

=T.DIST.RT(1.86,13)

=0.0428

Thus P-value = 0.0428

Reject the Null Hypothesis:

Yes

Since P-value = 0.0428 < 0.05 significance level.

What is your conclusion?

Since we have rejected null hypothesis H0, there is sufficient evidence to conclude that the mean annual milk consumption is higher there.

Add a comment
Know the answer?
Add Answer to:
Q Search this course According to a recent study annual per capita consumption of milk in...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • According to a recent study annual per capita consumption of milk in the United States is...

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

  • According to a recent study annual per capita consumption of milk in the United States is...

    According to a recent study annual per capita consumption of milk in the United States is 23.8 gallons. Being from the Midwest, you believe milk consumption is higher there and wish to test your hypothesis. A sample of 14 individuals from the Midwestern town of Wahster City was selected and then each person's milk consumption was entered into the Microsaft Excel Online file below. Use the data to sat up your spreadsheet and tast your hypothesis. Open spreadsheet a. Develop...

  • Excel Online Freeform Activity: Hypothesis Tests for the Population Mean when o Unknown According to a...

    Excel Online Freeform Activity: Hypothesis Tests for the Population Mean when o Unknown According to a recent study annual per capita consumption of milk in the United States is 22.6 gallons. Being from the Midwest, you believe milk consumption is higher there and wish to test your hypothesis. A sample of 14 individuals from the Midwestern town of Webster City was selected and then each person's milk consumption was entered into the Microsoft Excel Online file below. Use the data...

  • Annual per capita consumption of milk is 21.6 gallons (Statistical Abstract of the United...

    Annual per capita consumption of milk is 21.6 gallons (Statistical Abstract of the United States: 2006). Being from the Midwest, you believe milk consumption is higherthere and wish to support your opinion. A sample of 16 individuals from the Midwestern town of Webster City showed a sample mean annual consumption of 24.1 gallonswith a sample standard deviations = 4.8.a. Develop a hypothesis test that can be used to determine whether the mean annual consumption in Webster City is higher than...

  • Annual per capita consumption of milk is 21.6 gallons. Being from the Midwest, you believe milk...

    Annual per capita consumption of milk is 21.6 gallons. Being from the Midwest, you believe milk consumption is higher there and wish to support your opinion. A sample of 16 individuals from the midwestern town of Webster City showed a sample mean annual consumption of 24.1 gallons with a sample standard deviation of 4.8. Develop a hypothesis test. a) point estimate of difference? b) conclusion with level of significance at .05? Question 3 options: 2.5 gallons, reject Ho 2.5 gallons,...

  • Video Excel Online Freeforrmi Activity: According to à Wabster City was selected and then each pe...

    Video Excel Online Freeforrmi Activity: According to à Wabster City was selected and then each person's milk consumption was entered into the Microsoft Excel Online fi Hypothesis Tests for the Population Mean when o Unknown dy annual per capita consumption of milk in the United States is 22.6 allons. Being from the Midwest, you believe milk consumption is higher there and wish to test your hvpothesis. A san e below, Use the data to set up your spreadshee and test...

  • 4. Hypothesis Testing Annual per captia consumption of milk is 21.6 gallons (Statistical Abstract of the...

    4. Hypothesis Testing Annual per captia consumption of milk is 21.6 gallons (Statistical Abstract of the United States: 2006. Being from the fidtrest, you believe milk consumption is higher there and wish to support your opinion A sample of 16 individuals from the Midtvesterm town of Webster City showed a sample mean annual consumption of 24.1 gallons with a sample standard deviation of s 48.

  • According to the Alaska Beer Institute (ABI) Annual Report for 2010, the mean annual beer consumption...

    According to the Alaska Beer Institute (ABI) Annual Report for 2010, the mean annual beer consumption of beer per person in Anchorage, Alaska is 28.2 gallons (roughly 300 twelve ounce bottles). The City of Anchorage, Alcohol Review Board in 2018 wanted to put these results to the test and took a random sample of 27 Anchorage residents that yielded a sample mean of 23 gallon per person with a sample standard deviation of 6 gallon per person. Test the null...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT