(Round all intermediate calculations to at least 4 decimal places.) (Use Excel)
ID: 3050749 • Letter: #
Question
(Round all intermediate calculations to at least 4 decimal places.) (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 Kept in Garage? Yes 8, 7, 7 7, 6,78, 9, 10 No 6,7,6 5,6,4 5,7,7 a. Use Excel to generate the appropriate ANOVA at the 5% significance level. (Round your answers except "df" to decimal 3 places.) ANOVA Source of Variation df MS p-value F crit at 5% Sample Columns Interaction Within TotalExplanation / Answer
applying excel data anlysis; two way ANOVA on above data:
b)
No since .. F stat is less than crtiical value
c)Yes since .. F stat is greater than crtiical value
d) Yes since .. F stat is greater than crtiical value
Source of Variation SS df MS F P-value F crit Sample 14.222 1 14.222 19.692 0.001 4.747 Columns 10.111 2 5.056 7.000 0.010 3.885 Interaction 2.111 2 1.056 1.462 0.270 3.885 Within 8.667 12 0.722 Total 35.111 17Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.