Minitab or Excel:

Utilize stepwise regression to identify a model. Find the following:

a. The equation

b. Value of 2

c. Values of the standard errors

d. ANOVA results

e. VIF values

f. P-values and T-test on each regression coefficient. Use = 0.05.

g. Normal probability plot of the residuals

DATA
X1	X2	X3	X4	X5	Y
TEMP	SOAK TIME	SOAK PCT	DIFF TIME	DIFF PCT	PITCH
1650.00	0.58	1.10	0.25	0.90	0.01
1650.00	0.66	1.10	0.33	0.90	0.02
1650.00	0.66	1.10	0.33	0.90	0.02
1650.00	0.66	1.10	0.33	0.95	0.02
1600.00	0.66	1.15	0.33	1.00	0.02
1600.00	0.66	1.15	0.33	1.00	0.02
1650.00	1.00	1.10	0.50	0.80	0.01
1650.00	1.17	1.10	0.58	0.80	0.02
1650.00	1.17	1.10	0.58	0.80	0.02
1650.00	1.17	1.10	0.58	0.80	0.02
1650.00	1.17	1.10	0.58	0.90	0.02
1650.00	1.17	1.10	0.58	0.90	0.02
1650.00	1.17	1.15	0.58	0.90	0.02
1650.00	1.20	1.15	1.10	0.80	0.03
1650.00	2.00	1.15	1.00	0.80	0.03
1650.00	2.00	1.10	1.10	0.80	0.03
1650.00	2.20	1.10	1.10	0.80	0.02
1650.00	2.20	1.10	1.10	0.80	0.03
1650.00	2.20	1.15	1.10	0.80	0.02
1650.00	2.20	1.10	1.10	0.90	0.03
1650.00	2.20	1.10	1.10	0.90	0.03
1650.00	2.20	1.10	1.50	0.90	0.03
1650.00	3.00	1.15	1.50	0.80	0.03
1650.00	3.00	1.10	1.50	0.70	0.03
1650.00	3.00	1.10	1.50	0.75	0.03
1650.00	3.00	1.15	1.66	0.85	0.03
1650.00	3.33	1.10	1.50	0.80	0.03
1700.00	4.00	1.10	1.50	0.70	0.04
1650.00	4.00	1.10	1.50	0.70	0.04
1650.00	4.00	1.15	1.50	0.85	0.04
1700.00	12.50	1.00	1.50	0.70	0.06
1700.00	18.50	1.00	1.50	0.70	0.07