Question

PLease answer the questions given, I dont need just the conclusion of anova test

Three brands of gasoline (Shell, BP, and Marathon) were deliberately selected for an observational study. The study was conducted to understand which brand of gasoline among the three selected is cheaper across the metropolitan areas of mid-west. A gas station for each brand of gas from 10 metropolitan areas were randomly selected for the study.

It is a well-known fact that, the price drivers pay for gasoline often varies a lot from one gas station to another throughout the United States (hence is “heterogeneous”) and metropolitan areas in the mid-west region are no different from that fact. Therefore, a decision was made to block the effect of metropolitan areas out of testing for the differences in prices for different brands of gasoline.

Although the sample data is not provided here, data on price-per-gallon (in $) for regular gasoline for a random sample of service stations located in 10 metropolitan areas across the Midwest region for three major brands of gasoline was collected and analyzed using Excel.

	Gasoline Brands
Metropolitan Area	Shell	BP	Marathon	Average
Akron, OH	---	---	---	3.793
Cincinnati, OH	---	---	---	3.807
Cleveland, OH	---	---	---	3.870
Columbus, OH	---	---	---	3.773
Ft. Wayne, IN	---	---	---	3.847
Indianapolis, IN	---	---	---	3.853
Lansing, MI	---	---	---	3.987
Lexington, KY	---	---	---	3.787
Louisville, KY	---	---	---	3.803
Muncie, IN	---	---	---	3.827
Average	3.811	3.846	3.847

In Phase I of the analysis of the test data, the following partial ANOVA results were obtained.

ANOVA - Phase I
Source of Variation	df	SS	MS	F
Rows		0.1083
Columns		0.0084
Error
Total		0.1287

In Phase II of the analysis of the sample data, the following partial ANOVA results were obtained.

ANOVA - Phase II
Source of Variation	df	SS	MS	F
Between Groups		0.0084
Within Groups
Total		0.1287

Answer the following questions: Problem 2a) Complete the ANOVA Table below. In Phase I of the analysis of the test data, the following partial ANOVA results were obtained. ANOVA - Phase I Source of Variation df SS MS F Rows 0.1083 Columns 0.0084 Error Total 0.1287 Problem 2b) Name the “Rows” factor. Name the “Columns” factor. Problem 2c) Which experimental design was considered for analysis under Phase I Problem 2d) Type in the Excel function with inputs to be used to determine p-value. What is the p-value? Conduct the Hypothesis Test using p-value approach (at 0.04 level of significance) on the “Rows” factor. What is your conclusion? 0 words Problem 2e) Is the above Hypothesis Test on the “Rows” factor meaningful? Why or why not? Problem 2f) State the Hypotheses that the user would be interested in testing using population parameter symbols. Problem 2g) Write down the hypothesis statements that the user would be interested in testing in English sentences. Problem 2h) Type in the Excel function with inputs to be used to determine the Critical-value. What is the Critical-value? Conduct the Critical-Value based Hypothesis Test on what the user is interested in (at 0.04 level of significance). What is your decision on the Hypothesis Test? Problem 2i) State the conclusion (what meaning the decision under ‘2h’ carries) based on the Hypothesis Test that the user is interested in under Phase I analysis. Problem 2j) If at all there are any differences between gasoline brands, identify which gasoline brand(s) are different from the rest with respect to price-per-gallon, (use 0.04 level of significance)? Problem 2k) Complete the ANOVA Table below. In Phase II of the analysis on the sample data, the following partial ANOVA results were obtained. ANOVA - Phase II Source of Variation df SS MS F Between Groups 0.0084 Within Groups Total 0.1287 Problem 2l) Which experimental design was considered for the analysis under Phase II? Problem 2m) Type in the Excel function with inputs to be used to determine the Critical-value. What is the Critical-value? Conduct a Critical-value based Hypothesis test (at 0.04 level of significance). What is your decision on the Hypothesis test? Problem 2n) State the conclusion (what meaning the decision under ‘2m’ carries) based on the Hypothesis Test that the user is interested in under Phase II analysis. Problem 2o) Which one among Phase I and Phase II analyses is able to properly test what the user was interested in? Why (justify your reasoning behind your answer)? Problem 2p) Which method among Phase I and Phase II provides the correct method of analysis for this problem? Problem 2q) You own and operate a large fleet of vehicles across the metropolitan areas in this region. Based on the analysis results, which brand/s of Gasoline would you recommend using? State the reasoning behind such a decision.

Answer 1