What ANOVA TABLE in excel is used Two way with or without re

What ANOVA TABLE in excel is used? Two way with, or without, replication? What data is included? Do we include the metropolitan names as well? Or do we just input the numbers?

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 b BP, and Marathon) located in eleven metropolitan areas across the upper Midwest region (OhioGasPrices.com website, March 18, 2012) Click on the webfile logo to reference the data. WEB litan Area Marathon 3.78 3.87 Akron, OH Cincinnati, OH Cleveland, OH Columbus, OH Ft. Wayne, IN Indianapolis, IN Lansing, MI Lexington, KY Louisville, KY Muncie, IN Toledo, OH 3 3.72 3.87 3.76 3.83 3.85 3.93 3.79 3.78 3.81 3.69 3.83 3.83 3.85 3.77 3.84 3.84 4.04 3.78 3.84 3.84 3.83 3.79 3.87 3.87 3.99 3.79 3.79 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 7 decimals, F to 2 decimals and p to 3 decimals, if necessary MS ·010801 .00791 .00130: DF Metropolitan Area Brand Error Total 8.30 0.000 .015834 0.009 32 14987 The p-value is less than.05 What is your conclusion? Condlude that there is a significant difference in the mean price per gallon.

Solution

SOl)

The above table is ANOVA two way with out replication.

Here Brands are treatments and Metrropolitan names are Blocks.

Conclusion: since P < alpha we accept Ho