13.5 Excel Activity 1a - ANOVA, Factorial Experiment (Structured) Question 1 5.22/10 Submit rating study obtained...

Transcribed Image Text:

13.5 Excel Activity 1a - ANOVA, Factorial Experiment (Structured) Question 1 5.22/10 Submit rating study obtained for two hybrid small cars, two hybrid midsize cars, two hybrid small SUVs, two hybrid midsize SUVs, and eight similarly equipped conventional models are contained in the Excel Online file below. Construct a spreadsheet to answer the following questions. X Open spreadsheet a. At the a= .05 level of significance, test for significant effects due to class, type, and interaction. Source of Variation Class Type Interaction Error Total Sum of Squares (to 2 decimals) 458.75 * 189.06 M 18.69 x * * 63.5 700.94 Degrees of Freedom 3 1 3 Check My Work 8 15 M M ✔ 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 S c. The p-value for the type of vehicle is 0.0012 What is your conclusion with respect to the type of vehicle? There is sufficient Reset Problem Mean Square (to 2 decimals) 143.23 X 189.06 M 6.23 X 7.94 X F (to 2 decimals) 18.04 23.82 X .78 evidence to conclude that the fuel efficiency is not the same for the four classes of vehicle. d. The p-value for the interaction between class and type of vehicle is 1 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. X evidence to conclude that the fuel efficiency is not the same for the two types of vehicle. B 3 0 11 12 13 A Make/Model Honda Civic Honda Civic Toyota Prius Toyota Corolla Chevrolet Malibu Chevrolet Malibu Nissan Altima Nissan Altima Ford Escape Ford Escape Saturn Vue Saturn Vue Lexus RX Lexus RX 14 15 16 Toyota Highlander 17 Toyota Highlander 18 B Class Small Car Small Car Small Car Small Car Midsize Car Midsize Car Midsize Car Midsize Car Small SUV Small SUV Small SUV Small SUV Midsize SUV Midsize SUV Midsize SUV Midsize SUV C Type Hybrid Conventional Hybrid Conventional Hybrid Conventional Hybrid Conventional Hybrid Conventional Hybrid Conventional Hybrid Conventional Hybrid Conventional D MPG 36 28 44 33 28 23 33 26 27 22 28 22 24 18 24 17 13.5 Excel Activity 1a - ANOVA, Factorial Experiment (Structured) Question 1 5.22/10 Submit rating study obtained for two hybrid small cars, two hybrid midsize cars, two hybrid small SUVs, two hybrid midsize SUVs, and eight similarly equipped conventional models are contained in the Excel Online file below. Construct a spreadsheet to answer the following questions. X Open spreadsheet a. At the a= .05 level of significance, test for significant effects due to class, type, and interaction. Source of Variation Class Type Interaction Error Total Sum of Squares (to 2 decimals) 458.75 * 189.06 M 18.69 x * * 63.5 700.94 Degrees of Freedom 3 1 3 Check My Work 8 15 M M ✔ 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 S c. The p-value for the type of vehicle is 0.0012 What is your conclusion with respect to the type of vehicle? There is sufficient Reset Problem Mean Square (to 2 decimals) 143.23 X 189.06 M 6.23 X 7.94 X F (to 2 decimals) 18.04 23.82 X .78 evidence to conclude that the fuel efficiency is not the same for the four classes of vehicle. d. The p-value for the interaction between class and type of vehicle is 1 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. X evidence to conclude that the fuel efficiency is not the same for the two types of vehicle. B 3 0 11 12 13 A Make/Model Honda Civic Honda Civic Toyota Prius Toyota Corolla Chevrolet Malibu Chevrolet Malibu Nissan Altima Nissan Altima Ford Escape Ford Escape Saturn Vue Saturn Vue Lexus RX Lexus RX 14 15 16 Toyota Highlander 17 Toyota Highlander 18 B Class Small Car Small Car Small Car Small Car Midsize Car Midsize Car Midsize Car Midsize Car Small SUV Small SUV Small SUV Small SUV Midsize SUV Midsize SUV Midsize SUV Midsize SUV C Type Hybrid Conventional Hybrid Conventional Hybrid Conventional Hybrid Conventional Hybrid Conventional Hybrid Conventional Hybrid Conventional Hybrid Conventional D MPG 36 28 44 33 28 23 33 26 27 22 28 22 24 18 24 17