Please use excel functions

decision a s testing. 3) A research firm tests the miles-per-gallon characteristics of three brands of gasoline, Automobiles were randomly subjected to treatments and the results of the experiment (in miles per gallon) are presented below. Please note that in this problem raw data is not provided - you would not need It as partial results are already provided. You will be able to use the partial results to solve the problem and answer the questions, The five automobile types are suspected to introduce "Heterogencity" as gasoline brands are expected to performance differently in different automobile types. The experimenter would prefer to remove any corruptive effect of heterogeneity to get clean results on Gasoline Brands. Hence the analysis is performed in two phases. Gasoline Brands Average X Y Z 23.67 20.33 Automobile 25.00 Type 27.00 32.33 Average 24.40 26.80 25.80 In Phase I of the analysis on the above data, the following partial ANOVA results were obtained. Source OF SS MS Gasoline Brand 14.5 Error Total 14 2673 d) Complete the above ANOVA Table. e) What experimental design was considered for the analysis under Phase 17 f) State the Null and Alternate Hypotheses. Customize your hypothesis to the business problem context (do not use generic terms). g) Determine Critical-value. Conduct a Critical-value based Hypothesis test (at a = 0.10). What is your decision on the Hypothesis test? h) State your conclusion (what meaning the decision under part 'd' carries in the problem context) In phase II of the analysis of the test data, the following partial ANOVA results were obtained. Source MS Automobile Typ Gasoline Brand 145 Error 15.5 Total 2673 1) Complete the above ANOVA Table. What experimental design was considered for the analysis under Phase II?