Explore BrainMass

Explore BrainMass

    Analysis of a factorial ANOVA in EXCEL

    Not what you're looking for? Search our solutions OR ask your own Custom question.

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

    Using the attached EXCEL file, complete a factorial ANOVA. You may need to reclassify the DV as numeric. You may want to make sure that your output includes cell means (to help interpret any interactions).

    © BrainMass Inc. brainmass.com September 24, 2022, 5:58 pm ad1c9bdddf


    Solution Preview

    Attached is an Excel Worksheet to this response. The sheet shows all ...

    Solution Summary

    In this solution, EXCEL was used to conduct an analysis of variance on data from a two factor factorial experiment. The output from the EXCEL sheet shows and ANOVA table for evaluating the significance of both main effects and the interaction effect. Interaction plots are also included along with a discussion of how to interpret the plots in terms of significant main effects and interactions.