(11.9 pg. 409) The following data represents the price of regular gasoline at se
ID: 3269846 • Letter: #
Question
(11.9 pg. 409) The following data represents the price of regular gasoline at self service stations in four counties in New York City May 17, 2014
Manhatten
Bronx
Queens
Brooklyn
nassau
Suffolk
2.339
2.199
2.239
2.159
2.099
2.179
2.299
2.139
2.239
2.199
2.199
2.159
2.239
2.239
2.179
2.359
2.259
2.119
2.199
2.159
2.299
2.159
2.239
2.159
2.199
2.179
2.279
1.999
2.239
2.219
At the .05 level of significance, is there evidence of a difference in the mean price of gasoline in the six counties
a. State the null hypothesis, state the alternative hypothesis
b. using excel, analyze the gas data using the ANOVA:single factor
c. explain your results comparing the F results to Fcritical and how this determines whether we can accept or reject Ho. What is your conclusion from this analysis.
Manhatten
Bronx
Queens
Brooklyn
nassau
Suffolk
2.339
2.199
2.239
2.159
2.099
2.179
2.299
2.139
2.239
2.199
2.199
2.159
2.239
2.239
2.179
2.359
2.259
2.119
2.199
2.159
2.299
2.159
2.239
2.159
2.199
2.179
2.279
1.999
2.239
2.219
Explanation / Answer
a ) Null hypotheis (Ho): There is no significance difference in the mean price of gasoline in the six counties
Alternative hypothesis (H1):There is significance difference in the mean price of gasoline in the six counties
b) For the given data Anova single factor excel output is below
c) F caclulated value < F critical value
i.e 1.447619 < 2.620654
Therefore fail to reject null hypothesis or accept Ho
Conclusion: Since we accepted Ho so, There is evidence of a difference in the mean price of gasoline in the six counties
Anova: Single Factor SUMMARY Groups Count Sum Average Variance Manhatten 5 11.275 2.255 0.00388 Bronx 5 10.915 2.183 0.00148 Queens 5 11.235 2.247 0.00212 Brooklyn 5 10.875 2.175 0.01648 nassau 5 11.035 2.207 0.00412 Suffolk 5 10.835 2.167 0.00132 ANOVA Source of Variation SS df MS F P-value F crit Between Groups 0.03546667 5 0.007093 1.447619 0.243627 2.620654 Within Groups 0.1176 24 0.0049 Total 0.15306667 29Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.