Calculate two way anova with replication. Please explain using excel step by step.

QUESTION 1: A research rm tests the miles per gallon characteristics of three brands of gasoline. Because of different gasoline performance characteristics in different brands of automobiles, ve brands of automobiles are selected and treated as blocks in the experiment; that is, each brand of automobile is tested with each type of gasoline. The results of the experiment (in miles per gallon) follow. _ Gasoline Brands Automobiles I [[ 111 A 1 8 2 1 20 B 24 26 27 C 30 29 34 D 22 25 24 E 20 23 24 a. How many factors and treatments involved in the study? State the factors and list all the possible treatments b. Is there any interaction effect between automobiles and gasoline brands on the miles per gallon at 6% signicance level. Use Microsoft excel to solve this problem. (13 Marks)