C35123456789101112131415161718192021222324252627282930313233343536373839AGallons of Milk4x ✓ fx25.723.8425.2521.117.5219.6119.8326.1834.973028.5920.5726.9427.24BSignificance levelHypothesized meanSample SizeSample MeanSample Standard DeviationTest StatisticDegrees of FreedomP-valueHypothesized decisionNew test statisticDO NOT REJECTс0.0123.81424.814.7670471430.7927494420.221075907130.762751046DEMeanStandard ErrorMedianModeStandard DeviationSample VarianceKurtosisSkewnessRangeMinimumMaximumFSumCountG24.741538461.37413975225.2534.974.95453133724.54738077-0.1585224660.44538700817.4517.5234.97321.641334.9717.52Largest(1)Smallest(1)Confidence Level(95%) 2.993993282HIJK 9.4 Excel Activity 2d - Hypothesis Test for Mean, o Unknown (Freeform)Question 17.14/10SubmitVideoAccording 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 ofWebster 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.Due to a recent change by Microsoft you will need to open the XLMiner Analysis ToolPak add-in manually from the home ribbon. Screenshot of ToolPakOpen spreadsheeta. 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: 22.6H₂:>22.6✔✔b. What is a point estimate of the difference between mean annual consumption in Webster City and the national mean?2.21 (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).0.76 XThe p-value isReject the null hypothesis?No ✔✔What is your conclusion?There is insufficient evidence to conclude that the population mean consumption of milk in Webster City is greater than the hypothesized mean. ✓0.22100.2210X (4 decimals)Check My WorkReset ProblemX

The random sample of individuals from the midwestern town of Webster city, The data set for the milk…

Answered: According to a recent study annual per…

MATLAB: An Introduction with Applications

6th Edition

ISBN:9781119256830

Author:Amos Gilat

Publisher:Amos Gilat

Chapter1: Starting With Matlab

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

A drug company claims that an allergy medication causes headaches in 5% of those who take it. A medical researcher believes that more than 5% of those who take the drug actually get headaches. Identify the population(s). 5% of those who take the drug actually get headaches. the proportion of those who take the drug who get a headache. all individuals who take the medication. more than 5% of those who take the drug actually get headaches. What is the variable being examined for individuals in the population(s)? more than 5% of those who take the drug actually get headaches. the proportion of those who take the drug who get a headache. whether or not a person who takes the drug gets a headache. 5% of those who take the drug actually get headaches.
A researcher hypothesized that cytokinins and auxins supplied by tumor-inducing insects lead to the production of tumors in plants. She performed experiments in which she hypodermically injected green pepper plants to determine if she could induce tumors. In one experiment she varied the concentration of cytokinin and the ratio of auxin concentration to cytokinin concentration. She used 3 concentrations of cytokinin and 6 ratios of auxin/cytokinin. The concentrations are indexed (1-3) with 3 indicating the highest concentration of cytokinin. The 6 ratios of auxin/cytokinin varied from 0.125 to 5.0 with values greater than 1 indicating that auxin was in greater concentration than cytokinin. The resulting data are in the date file "auxcyt.csv". The measured sizes of the tumors induced (relative to controls) are given in the 3rd column ('sumdiffd'). Analyze these data testing the appropriate hypotheses and interpret the results. (Note the unequal sample sizes.) auxcyt data…
In 1940, 2,000 women working in a factory were recruited into a study. Half of the women worked in manufacturing and half in administrative offices. The incidence of bone cancer through 1970 among the 1,000 women working in manufacturing was compared with that of 1,000 women working in administrative offices. Thirty of the women in manufacturing developed bone cancer as compared to 9 of the women in administrative offices. Identify what type of study this is.
An ethical data analyst would be least likely to Multiple Choice check data for accuracy. cite his/her data sources and their limitations. acknowledge sources of financial support. rely on consultants for all calculations.
You may need to use the appropriate technology to answer this question. Periodically, customers of a financial services company are asked to evaluate the company's financlal consultants and services. Higher ratings on the client satisfaction survey indicate better service, with 7 the maximum service rating. Independent samples of service ratings for two financial consultants are summarized here. Consultant A has 10 years of experience, whereas consultant B has 1 year of experience. Use a = 0.05 and test to see whether the consultant with more experience has the higher population mean service rating. ConsultantA Consultant B = 16 n2 = 10 x, 6.83 x2 = 6.28 5- 0.68 52 = 0.75 (a) State the null and alternative hypotheses. O Ho: H1- H2 * 0 H: H-H2=0 O Ho: H-H2> o Ho Hy-H250 H -H2>0 O Ho: H-H2=o H: H-H2 0 O Ho: H-H25o H H-H2 0 (b) Compute the value of the test statistic. (Round your answer to three decimal places.) (c) What is the p-value? (Round your answer to four decimal places.) p-value…
There are 64% of US adults who own a smartphone, up from 35% in 2011. Smartphones have become an important way for Americans to communicate, go online, access and share information. The Pew Research Center surveyed 1635 people in November, 2014 on smartphone ownership. Their goal was to learn how Americans use their smartphone devices. Identify the population and the sample.
fill blanks underlines.
According to a report published by the center for Disease Control (CDC) in 2011, approximately one in two people with asthma had an asthma attack in2008.
You are the Provost of a University and you want to see if students would like to participate in classroom-based physical activity. You implemented a quick pilot test and collected data after Spring quarter. Below is the first set of data. Based on the data, answer the question. Participant Height (inches) Weight (pounds) Sex (1= male, 2= female) Ever Age (1 = 18-24 participated years, 2 25-34 in classroom exercise (1 = years, 3 35-49 years, 4 50 years No, 2 = Yes) or older) 66 150 1 1 2 72 150 2 2 4 66 150 2 1 2 4 74 215 1 2 1 5 66 112 2 2 6 71 215 2 2 7 69 175 2 2 3 8 66 152 1 2 9 72 375 1 1 10 66 140 1 2 3 What type of variables are height and sex? continuous, dichotomous discrete, ordinal discrete, dichotomous O discrete, nominal
An investigator wants to assess whether smoking is a risk factor for pancreatic cancer. Electronic medical records at a local hospital will be used to identify fifty patients with pancreatic cancer. One hundred patients who are similar but free of pancreatic cancer will also be selected. Each participant’s medical record will be analyzed for smoking history. Identify the type of study proposed. Briefly explain why you think the study is of this type. Indicate the study type's specific strengths and weaknesses. What is the most likely source of bias in the study .
Below you will find a research scenarios. Your task is to identify the proposed analysis and why you chose that analysis for each of these scenarios. State the research question that aligns with the scenario and the analysis. Next run the appropriate analyses and report your findings in APA Research scenario 2: Historians are interested in the accuracy of eyewitness accounts of traumatic events. One study examined survivors' recall of the sinking of the ship Titanic (Riniolo, Koledin, Drakulic, & Payne, 2003). The researchers reviewed the transcripts of survivors' testimony at governmental hearings (www.titanicinquiry.org) to see whether they testified that the ship was intact or breaking apart during the ship's final plunge (it was in fact breaking apart). To test for eyewitness accuracy, testimony of 20 survivors was examined to see if there was an equal likelihood of survivors saying the ship was intact or breaking apart. Datafile: titanic.xlsx Your response should contain…
Please do not give solution in image format thanku

Recommended textbooks for you

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

MATLAB: An Introduction with Applications

Statistics

ISBN:

9781119256830

Author:

Amos Gilat

Publisher:

John Wiley & Sons Inc

Probability and Statistics for Engineering and th…

Statistics

ISBN:

9781305251809

Author:

Jay L. Devore

Publisher:

Cengage Learning

Statistics for The Behavioral Sciences (MindTap C…

Statistics

ISBN:

9781305504912

Author:

Frederick J Gravetter, Larry B. Wallnau

Publisher:

Cengage Learning

Elementary Statistics: Picturing the World (7th E…

Statistics

ISBN:

9780134683416

Author:

Ron Larson, Betsy Farber

Publisher:

PEARSON

The Basic Practice of Statistics

Statistics

ISBN:

9781319042578

Author:

David S. Moore, William I. Notz, Michael A. Fligner

Publisher:

W. H. Freeman

Introduction to the Practice of Statistics

Statistics

ISBN:

9781319013387

Author:

David S. Moore, George P. McCabe, Bruce A. Craig

Publisher:

W. H. Freeman

SEE MORE TEXTBOOKS