There is probably some variation in the exact measurements you obtained for each of the settings you used for the variables number-of-books and launcher-position. However, this variation should be relatively small. Therefore, you can assume that each of the four settings has a single value. Based on this assumption, you can view each setting as a different treatment.
1. Based on your analysis of each explanatory variable, which (if any) of these variables has a significant impact on the distance the penny traveled? State your conclusion with regard to both 1% and 5% significance levels (a).
2. Do your data violate any of the requirements of the ANOVA analysis?
See attached file for full problem description.© BrainMass Inc. brainmass.com June 3, 2020, 7:18 pm ad1c9bdddf
The solution gives the step step procedure for analysis of variance in Excel. Interpretation of the results are also given.