This Excel file is a template for creating a chart of the eight cell means from a 2 x 2 x 2 full-factorial experiment. The output (on the worksheet titled “the Figure”) is a chart that is ready for inclusion in a manuscript.
The input (on the worksheet titled “2x2x2 ORIGINAL data”) is the names of the independent variables, the labels for each of their two levels (e.g., “High” and “Low”), the name of the dependent variable, and the eight cell means. The plotted range of the dependent variable is 1 – 5, but this can be adjusted by hand.
The Excel file is available here:
template for 2x2x2
– Eric DeRosia