DOE blog graph.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	2^3 Full Factorial Array (Similar to the Taguchi L8 Orthogonal Array)
2	CP5070 DOE Tutorial Example 1 on Practical
3
4
5			Factor Assignment			Response Table (Data)								Quick Calculations
6			Main Effects				Replicates used to normalize the data
7	Run#	Run Order	A	B	C	R1	R2	R3	R4	R5	R6	R7	R8	Ave.	Std.Dev.
8	1	1	-	-	-	80	80	79.5	81.5	83.5	81	80.5	10.5	72.1	24.91		Each run was replicated 8 times (R1, R2, etc)
9	2	3	+	-	-	78	80	83.5	74.5	87	84	74.5	83	80.6	4.60		The response variable is dissolution of lactose (minutes)
10	3	2	-	+	-	80.5	80	81.5	79	81.5	79.4	77.5	80.5	80.0	1.34
11	4	6	+	+	-	73	75.5	77	83.7	81	89.5	88.5	76.9	80.6	6.12
12	5	4	-	-	+	85	87	87	90	90	87	88.5	97	88.9	3.67
13	6	5	+	-	+	89.3	101.5	94.5	92.5	89.7	94.5	91.5	91.5	93.1	3.89
14	7	8	-	+	+	88.5	89	86	86	91	87.5	88.5	90	88.3	1.77
15	8	7	+	+	+	88	86	88.5	88.7	87	90.5	96	96.5	90.2	3.99
16
17	Reference Key to Factor Selection
18	Factor A = Your factor:					Arm length	; B =	projectile weight			; C =	stop angle
19
20																	#NAME?
21	Confounding Column Information (for alternative factor assignment considerations)
22	The Taguchi L8 array is very similar to this arrray but has slightly different columns that confound with each other. This
23	array does not have confounding columns. Using the L8 array requires an uderstanding of column confounding.
24
25	Calculating the Significance of Main Effects (Solving for Means)
26																	- (LOW)
27	Factor A					81	+	81	+	93	+	90	=	344	/ 4 = Ave=	86.11875	+ (HIGH)
28						72	+	80	+	89	+	88	=	329	/ 4 = Ave=	82.33	- (LOW)
29															Total Effect = Difference =	3.79
30
31	Factor B					80	+	81	+	88	+	90	=	339	/ 4 = Ave=	84.771875	+ (HIGH)
32						72	+	81	+	89	+	93	=	335	/ 4 = Ave=	83.67	- (LOW)
33															Total Effect = Difference =	1.10
34
35	Factor C					89	+	93	+	88	+	90	=	361	/ 4 = Ave=	90.13125	+ (HIGH)
36						72	+	81	+	80	+	81	=	313	/ 4 = Ave=	78.31	- (LOW)
37															Total Effect = Difference =	11.82
38
39
40
41
42	Calc. the Sig. of 2nd Order Interaction Effects or Aliased Effects (Solving for Means)
43
44	Factor D (AB)					72	+	81	+	89	+	90	=	332	/ 4 = Ave=	82.946875	+ (HIGH)
45						81	+	80	+	93	+	88	=	342	/ 4 = Ave=	85.50	- (LOW)
46															Total Effect = Difference =	-2.55
47
48	Factor E (AC)					72	+	80	+	93	+	90	=	335	/ 4 = Ave=	83.83125	+ (HIGH)
49						81	+	81	+	89	+	88	=	338	/ 4 = Ave=	84.61	- (LOW)
50															Total Effect = Difference =	-0.78
51
52	Factor F (BC)					72	+	81	+	88	+	90	=	331	/ 4 = Ave=	82.771875	+ (HIGH)
53						80	+	81	+	89	+	93	=	343	/ 4 = Ave=	85.67	- (LOW)
54															Total Effect = Difference =	-2.90
55
56
57
58
59	Calc. the Sig. of 3rd Order Interaction Effects, Error, or Aliased Effects (Solving for Means)
60
61	Factor G (ABC)					81	+	80	+	89	+	90	=	340	/ 4 = Ave=	84.909375
62						72	+	81	+	93	+	88	=	334	/ 4 = Ave=	83.53
63															Total Effect = Difference =	1.38
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