Explore BrainMass

Analysis of Variance in Excel


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.


Solution Summary

The solution gives the step step procedure for analysis of variance in Excel. Interpretation of the results are also given.