Explore BrainMass

Explore BrainMass

    Analysis of Variance in Excel

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!


    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


    Solution Summary

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