(Use Excel) An automotive parts manufacturer is testing three potential halogen
ID: 3054993 • Letter: #
Question
(Use Excel) An automotive parts manufacturer is testing three potential halogen headlight designs, one of which ultimately will be promoted as providing best-in-class nighttime vision. The distance at which a traffic sign can be read in otherwise total darkness is the variable of interest. Since older drivers often have lower visual acuity, driver age must be controlled in this experiment. The following results (in feet) were obtained from sampling 12 drivers (four age groups for each headlight design).
Use Excel to construct an ANOVA table. Assume nighttime viewing distances are normally distributed. (Round 'SS' and 'MS' to 2, 'F', 'p-value' and F crit to 3 decimal places.)
At the 5% significance level, can you conclude that the mean nighttime viewing distance is different among the headlight designs?
Practically, this implies that (Click to select)no singleat least one headlight design (of the three designs tested) is superior.
(Use Excel) An automotive parts manufacturer is testing three potential halogen headlight designs, one of which ultimately will be promoted as providing best-in-class nighttime vision. The distance at which a traffic sign can be read in otherwise total darkness is the variable of interest. Since older drivers often have lower visual acuity, driver age must be controlled in this experiment. The following results (in feet) were obtained from sampling 12 drivers (four age groups for each headlight design).
Driver Age
(Factor B) Headlight Design (Factor A) Design 1 Design 2 Design 3 Below 30 293 268 270 30-45 254 243 254 46-59 224 249 231 60-up 238 214 205 Click here for the Excel Data File a.
Use Excel to construct an ANOVA table. Assume nighttime viewing distances are normally distributed. (Round 'SS' and 'MS' to 2, 'F', 'p-value' and F crit to 3 decimal places.)
ANOVA Source of Variation SS df MS F p-value F crit @ 5% Rows Columns Error Totalb-1.
At the 5% significance level, can you conclude that the mean nighttime viewing distance is different among the headlight designs?
Yes, since the p-value associated with headlight design is less than ?. Yes, since the p-value associated with headlight design is greater than ?. No, since the p-value associated with headlight design is less than ?. No, since the p-value associated with headlight design is greater than ?. b-2. Practically speaking, what does your conclusion imply?Practically, this implies that (Click to select)no singleat least one headlight design (of the three designs tested) is superior.
c. At the 5% significance level, was including the blocking variable Driver Age beneficial to this experiment? Yes, since it is significant at the 5% level. Yes, since it is not significant at the 5% level. No, since it is significant at the 5% level. No, since it is not significant at the 5% level.Explanation / Answer
b1)
No, since the p-value associated with headlight design is greater than ?.
p - value = 0.455
b2)
Practically, this implies that no single headlight design (of the three designs tested) is superior.
c)
Yes, since it is significant at the 5% level.
SUMMARY Count Sum Average Variance Below 30 3 831 277 193 30-45 3 751 250.3333 40.33333 46-59 3 704 234.6667 166.3333 60-up 3 657 219 291 Design 1 4 1009 252.25 888.25 Design 2 4 974 243.5 500.3333 Design 3 4 960 240 800.6667 ANOVA Source of Variation SS df MS F P-value F crit Rows 5504.917 3 1834.972 10.35895 0.008688 4.757063 Columns 318.5 2 159.25 0.899012 0.455512 5.143253 Error 1062.833 6 177.1389 Total 6886.25 11Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.