3 of 5 Exercise 13.25 Check My Work (2 remaining) The price drivers pay for gaso

Question

3 of 5 Exercise 13.25 Check My Work (2 remaining) The price drivers pay for gasoline often varies a great deal across regions throughout the United States. The following data show the price per gallon for reguilar gasoline for a random sample of gasoline service stations for three major brands of gasoline (Shell, BP, and Marathon) located in eleven metropolitan areas across the upper Midwest region (OhioGasPrices.com website, March 18, 2012). Click on the datafile logo to reference the data DATA ?? Metropolitan Area Akron, Ohio Cincinnati, Ohio Cleveland, Ohio Columbas, Ohio Rt. Wayne, Indian Indianapolis, Indiana Lansing. Michigan Lexington, Kentucky Louisville, Kentucky Muncie, Indiana Toedo, Ohio 3.78 3.87 3.89 3.79 3.87 3.87 3.99 3.79 3.79 3.86 3.86 3.77 3.72 3.83 3.83 3.76 3.83 3.85 3.93 3.79 3.78 3.81 3.69 3.77 3.84 384 4.04 3.78 3.84 3.84 3.83 Use a- .05 to test for any significant difference in the mean price of gasoline for the three brands. Round SS to 6 decimals, MS to 6 decimals, F to 2 decimals and p to 3 decimals, if necessary. If your answer is zero, enter "O Source DF 100.10800.010801 8.30.000 Metropolitan Area 20 0.02600.001302 320.1499 Total MacBook 2 3 4 5 6

Explanation / Answer

Using Excel to analysis the data, the step are as follows

Input the data in Excel cells

Data---Data Analysis-----Anova: Two-Factor Without Replication----output

At 0.05 level of significance, the p-value is less than 0.05, we reject the null hypothesis and concluded that there is a significant difference between the mean price of gasonline for the three brands

Anova: Two-Factor Without Replication SUMMARY Count Sum Average Variance Row 1 3 11.38 3.793333 0.001033 Row 2 3 11.42 3.806667 0.006033 Row 3 3 11.61 3.87 0.0004 Row 4 3 11.32 3.773333 0.000233 Row 5 3 11.54 3.846667 0.000433 Row 6 3 11.56 3.853333 0.000233 Row 7 3 11.96 3.986667 0.003033 Row 8 3 11.36 3.786667 3.33E-05 Row 9 3 11.41 3.803333 0.001033 Row 10 3 11.51 3.836667 0.000633 Row 11 3 11.38 3.793333 0.008233 Column 1 11 41.8 3.8 0.00468 Column 2 11 42.29 3.844545 0.004867 Column 3 11 42.36 3.850909 0.003829 ANOVA Source of Variation SS df MS F P-value F crit Rows 0.108024 10 0.010802 8.39369 3.24E-05 2.347878 Columns 0.016927 2 0.008464 6.576407 0.006384 3.492828 Error 0.025739 20 0.001287 Total 0.150691 32

Related Questions

Navigate

• Browse (All)
• Browse 3
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.