Question

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 your hypothesis Open spreadsheet elop a hypothesis test that can be used to determine whether the mean annual consumption in Webster City is higher than the national mean. Ho: H 226 H22.6 o. What is a point estimate of the difference between mean annual consumption in Weboter City and the national mean? 2 decimals) ↓ At -0.05, test for a significant difference by completing the following, Calculate the value of the test statistic (2 decimals). value is 3 (4 decimals) Refact the null hypothesis? What is your conclusion? Conclude the population mean consumption of milk in Webster City is greater than the hypotheszed mean Check My Worl Reset Problern Autosaved at 3:38 PMM Back De嬲曲应 Video Excel Online Freeform Activity: Hypothesis Tests for the Population Mean when σ 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 Midwesterm town 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 Open spreadsheet 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 Ho: a 322.6 226 t. What is a point estimate of the difference between mean annual consumption in Webster City and the national mean? 3 (2 decimals) C. At a-0.05, test for a significant difference by completing the following. Calculate the value of the test statistic (2 decimals). (2 decimal The p-value is T 13 (4 decimals) Reject the null hypothesis? Yes What is your conclusion? Conclude the population mean consumption of milk in Webster City ts greater than the hypothesized mearn Check My Work Reset Problem Autosaved at 3:38 PM Back ELPLIB-TX994 DOLL Home Insert Data Tell me what you want t R Guest User is also editing - C22 ty: Hypothesis Tests for the Popul Gallons of Milk nnual per capita consumption of and then each person's milk consu 25.25 21.1 17.52 19.61 9.8 34.97 s test that 20.5 26.9 27.24 timate of the difference b me ypothesized Mean Sample Sze Sample Mean Sample Standard Devi 98857143 for a significant difference by complet 0.065423729 ue of the (2 mals), De 0.948832 onclusion? er Reset Problem

Answer 1

Answer Date: 15/04/2019 b) f the mean annual consumption of milk in Webster city is, By using Excel, find point estimate with the help of following steps is 1) Import the data 2) Select the MegaStat from Add-Ins Menu 3) Select Mean vs. Hypothesized Value from Hypothesis Tests 4)Enter Summary Input and Hypothesized mean. 5) Select t-test, Alternative and Confidence Level. 6) Click Ok.

Hypothesis Test: Mean vs. Hypothesized Value 22.60000 hypothesized value 24.98857 mean Milk 4.85541 std. dev. 1.29766 std. error 14 n 13 df 1.84 t 0443 p-value (one-tailed, upper) From the Excel output, the point estimate of the mean annual consumption of milk in Webster city is24.99. c) The t-test statistics is From the Excel output in part (b), the t-test statistics is 1.84 The p-value for this test is,

From the Excel output in part (b), the p-value for this test is 0.0443