Minitab or Excel:

Find the following:

1. Use each model to predict PITCH when TEMP=1650, SOAKTIME=1, SOAKPCT=1.1, DIFFTIME=1 and DIFFPCT=0.8. Also construct a confidence interval for these predicted values.

2. Construct a 95% confidence interval on each of the coefficients that were identified to be significant.

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