CPDD DOE BLOG EXCEL.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD
1
2	Run Order	A	B	C	Bullets (Grams)
3	1	+	-	-	3.5
4	2	-	+	-	1.6
5	3	-	-	+	0.7
6	4	+	+	-	1.2
7	5	+	-	+	0.7
8	6	+	+	+	0.3
9	7	-	+	+	0.5
10	8	-	-	-	3.1
11
12	Factor A	Bowl Diameter			the measured variable is the amount of “bullets” formed in grams
13	Factor B	Microwaving Time
14	Factor C	Power
15
16
17	Calculating Significance of Main Effects (Solving for Means)												Mean values								Bowl Diameter (A)	Microwaving time (B)	Power
18	Factor A	Run When A is + :		3.5	+	1.2	+	0.7	+	0.3	=	5.7	5.7	/4 =	1.43	(+)				(-)	1.48	2	2.35
19		Run When A is - :		1.6	+	0.7	+	0.5	+	3.1	=	5.9	5.9	/4 =	1.48	(-)				(+)	1.43	0.9	0.55
20													Total Effect / Difference		-0.05
21	Factor B	Run When B is + :		1.6	+	1.2	+	0.3	+	0.5	=	3.6	3.6	/4 =	0.90	(+)
22		Run When B is - :		3.5	+	0.7	+	0.7	+	3.1	=	8.0	8.0	/4 =	2.00	(-)
23													Total Effect / Difference		-1.10
24	Factor C	Run When C is + :		0.7	+	0.7	+	0.3	+	0.5	=	2.2	2.2	/4 =	0.55	(+)
25		Run When C is - :		3.5	+	1.6	+	1.2	+	3.1	=	9.4	9.4	/4 =	2.35	(-)
26													Total Effect / Difference		-1.80
27
28
29
30													Interaction Effects FULL factorial
31
32
33	A x B											A x C										B x C
34	At low B,	Average of low A =		(0.7+3.1)	/2	=	1.9					At low C,	Average of low A =		(1.6+3.1)	/2	=	2.35				At low C,	Average of low B =		(3.5+3.1)	/2	=	3.3
35		Average of high A =		(3.5+0.7)	/2	=	2.1						Average of high A =		(3.5+1.2)	/2	=	2.35					Average of high B =		(1.6+1.2)	/2	=	1.4
36		Total effect of A =		2.1 - 1.9		=	0.2	Increase	(+)				Total effect of A =		2.35 - 2.35		=	0	NIL	0			Total effect of B =		1.4 - 3.3		=	-1.9	Decrease	(-)
37	At high B	Average of high A =		(1.2+0.3)	/2	=	0.75					At high C,	Average of low A =		(0.7+0.5)	/2	=	0.6				At high C,	Average of low B =		(0.7+0.7)	/2	=	0.7
38		Total effect of A =		0.75 - 1.05		=	-0.3	Decrease	(-)				Average of high A =		(0.7+0.3)	/2	=	0.5					Average of high B =		(0.3+0.5)	/2	=	0.4
39													Total effect of A =		0.5 - 0.6		=	-0.1	Decrease	(-)			Total effect of B =		0.4 - 0.7		=	-0.3	Decrease	(-)
40
41
42			(-)	(+)									(-)	(+)										(-)	(+)
43		At Low B	1.9	2.1								At Low C	2.35	2.35									At Low C	3.3	1.4
44		At High B	1.05	0.75								At High C	0.6	0.5									At High C	0.7	0.4
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100