Question

Collapsing and Graphing an AxBxC Experimental Design

Consider the following outcome of a hypothetical experiment:

		B
		1		2
		C		C
		1	2	1	2
A	1	10	12	8	11
	2	49	24	16	22

List ALL of the cells (i.e., conditions) in the study and the mean of each.

Answer 1

		B
		1		2
		C		C
		1	2	1	2
A	1	10	12	8	11
	2	49	24	16	22
	mean
		1	2
	A	10.25	27.75
	B	23.75	14.25
	C	20.75	17.25

		B
		1		2
		C		C
		1	2	1	2
A	1	10	12	8	11
	2	49	24	16	22
		1	2
	A	=AVERAGE(C5:F5)	=AVERAGE(C6:F6)
	B	=AVERAGE(C5:D6)	=AVERAGE(E5:F6)
	C	=1/4*(C5+C6+E5+E6)	=1/4*(D5+D6+F5+F6)