13.5 Excel Activity 1b - ANOVA, Factorial Experiment (Freeform) Question 1 4.35/10 Submit Open spreadsheet a. At the a = .05 level of significance, test for significant effects due to class, type, and interaction. Source Sum of Squares Degrees of Variation (to 2 decimals) of Freedom Class 3 Mean Square (to 2 decimals) 73.42 x F (to 2 decimals) 9.27 Type 1 Interaction Error 3 8 Total 15 [ b. The p-value for the class of vehicle is 0.0006 What is your conclusion with respect to the class of vehicle? There is sufficient evidence to conclude that the fuel efficiency is not the same for the four classes of vehicle. c. The p-value for the type of vehicle is 0.0002 What is your conclusion with respect to the type of vehicle? There is sufficient evidence to conclude that the fuel efficiency is not the same for the two types of vehicle. d. The p-value for the interaction between class and type of vehicle is What is your conclusion with respect to the interaction between class and type of vehicle? The interaction between type and class of vehicle is not statistically significant. Check My Work Reset Problem Back 20 Autosaved at 11:24 AM DII 4 " F10 E14 E Arial 10 B fx Anova: Two-Factor With Replication XV fx F 14 Anova: Two-Factor With Replication 15 16 SUMMARY Small car G+ A General .00 $ 700 40 H I J K M N 0 38 Total 17 18 Count 2 2 4 19 Sum 69 53 122 20 Average 34.5 26.5 30.5 21 Variance 144.5 40.5 83 22 23 24 Count 2 2 4 25 Sum 61 44 105 26 Average 30.5 22 26.25 27 Variance 12.5 8 30.91667 28 29 30 Count 2 2 4 31 Sum 51 42 93 32 Average 25.5 21 23.25 33 Variance 4.5 8 10.91667 34 35 36 Count 1 1 2 37 Sum 38 Average 223 18 41 18 20.5 39 Variance 40 41 Total 42 Count 7 43 Sum 44 Average 204 29.142857 45 Variance 47.809524 46 47 ANOWA < > ===U Data + Workbook Statistics esc F1 1 ! @ 2 F2 7 157 22.42857143 18.95238095 12.5 80 a F3 F4 $ % 3 4 5 F5 MacBook Air 66 F6 F7 DII FB & 7 8 9