Question

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 11 metropolitan areas across the upper Midwest region.†

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.83
Toledo, Ohio	3.69	3.83	3.86

Find the value of the test statistic. (Round your answer to two decimal places.)

Find the p-value. (Round your answer to three decimal places.)

Answer 1

We have to compare average price per gallon for regular gasoline for three major brands of gasoline (Shell, BP, and Marathon)

So we have to perform one way ANOVA.

We can use excel to perform one way ANOVA.

Go to Data menu ---> data analysis ----> Select Anova: Single Factor

For Input range select the entire data table ( with headings Shell, BP, and marathon).

Check the box for "Labels in the first Row" . ( If you did not selected the column headings Shell, BP, and marathon then do not need to check this box )

Then click on OK.

The analysis output will be as follows :

Test statistic :  F = 1.77

p-value : 0.187