Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

(Use Excel) A consumer advocate examines whether the longevity of car batteries

ID: 3368350 • Letter: #

Question

(Use Excel) A consumer advocate examines whether the longevity of car batteries (measured in years) is affected by the brand name (factor A) and whether or not the car is kept in a garage (factor B). Interaction is suspected. The results are shown in the accompanying table

Brand Name of Battery

Click here for the Excel Data File

a-1. Construct an ANOVA table. (Round intermediate calculations to at least 4 decimal places. Round "SS", "MS" to 4 decimal places and "F", "p-value" to 3 decimal places.)

Brand Name of Battery

Kept in Garage? A B C Yes 7, 8, 8 6, 7, 7 8, 9, 9 No 5, 6, 6 4, 5, 4 6, 7, 7

Explanation / Answer

Anova: Two-Factor With Replication SUMMARY A B C Total Yes Count 3 3 3 9 Sum 23 20 26 69 Average 7.666667 6.666667 8.666667 7.666667 Variance 0.333333 0.333333 0.333333 1 No Count 3 3 3 9 Sum 17 13 20 50 Average 5.666667 4.333333 6.666667 5.555556 Variance 0.333333 0.333333 0.333333 1.277778 Total Count 6 6 6 Sum 40 33 46 Average 6.666667 5.5 7.666667 Variance 1.466667 1.9 1.466667 ANOVA Source of Variation SS df MS F P-value F crit Sample 20.05556 1 20.05556 60.16667 5.15E-06 4.747225 Columns 14.11111 2 7.055556 21.16667 0.000116 3.885294 Interaction 0.111111 2 0.055556 0.166667 0.848408 3.885294 Within 4 12 0.333333 Total 38.27778 17