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).
This question has the following supporting file(s):
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.
This answer includes:
- Plain text
- Cited sources when necessary
- Attached file(s)
Active since 2004
Responses 637 | eBooks 1