Analysis of a factorial ANOVA in EXCEL

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).

Attachments

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.