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 regular 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.

Metropolitan Area Shell BP Marathon

Akron, Ohio 3.77 3.83 3.78

Cincinnati, Ohio 3.72 3.83 3.87

Cleveland, Ohio 3.87 3.85 3.89

Columbus, Ohio 3.76 3.77 3.79

Ft. Wayne, Indiana 3.83 3.84 3.87

Indianapolis, Indiana 3.85 3.84 3.87

Lansing, Michigan 3.93 4.04 3.99

Lexington, Kentucky 3.79 3.78 3.79

Louisville, Kentucky 3.78 3.84 3.79

Muncie, Indiana 3.81 3.84 3.86

Toledo, Ohio 3.69 3.83 3.86

Use= .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 "0".

Source DF SS MS F p

Metropolitan Area

Brand

Error

Total

Thep-value is- Select your answer -

less than .05

between .05 and .125

between .025 and .05

between .05 and .10

greater than .05

.

What is your conclusion?

- Select your answer -

Conclude that there is a significant difference in the mean price per gallon.

Conclude that there is no significant difference in the mean price per gallon.

P/s: Please show me how to solve it on Excel