Major League Baseball (MLB) consists of teams that play in the American League and the National League. MLB collects a wide variety of team and player statistics. Some of the statistics often used to evaluate pitching performance are as follows:

• ERA: The average number of earned runs given up by the pitcher per nine innings. An earned run is any run that the opponent scores off a particular pitcher except for runs scored as a result of errors.
• SO/IP: The average number of strikeouts per inning pitched.
• HR/IP: The average number of home runs per inning pitched.
• R/IP: The number of runs given up per inning pitched.

The data in the Excel Online file below show values for these statistics for a random sample of 20 pitchers from the American League for a season. Construct a spreadsheet to answer the following questions.

Complete the equation below for an estimated regression equation developed to predict the average number of runs given up per inning pitched (R/IP) given the average number of strikeouts per inning pitched (SO/IP) and the average number of home runs per inning pitched (HR/IP) (to 3 decimals).

R/IP=______+_________SO/IP + _________HR/IP

Use the F test to determine the overall significance of the relationship.

Compute test statistic (to 2 decimals).

The P-value is __________________(to 3 decimals).

What is your conclusion at the .05 level of significance?

1. a significant overall relationship.

Use the t test to determine the significance of each independent variable.

Compute the t- test statistic for the significance of SO/IP (to 2 decimals).

The p-value is (to 3 decimals).

What is your conclusion at the .05 level of significance?

1. SO/IP _______significant.

Compute the t-test statistic for the significance of HR/IP (to 2 decimals).

The p-value is ________ (to 3 decimals).

What is your conclusion at the .05 level of significance?

HR/IP _________

Player	Team	W	L	ERA	SO/IP	HR/IP	R/IP
Verlander, J	DET	24	5	2.39	0.99	0.10	0.28
Beckett, J	BOS	13	7	2.88	0.90	0.10	0.34
Wilson, C	TEX	16	7	2.93	0.91	0.07	0.39
Sabathia, C	NYY	19	8	3.00	0.97	0.06	0.37
Haren, D	LAA	16	10	3.16	0.81	0.08	0.38
McCarthy, B	OAK	9	9	3.31	0.71	0.06	0.42
Santana, E	LAA	11	12	3.38	0.78	0.11	0.41
Lester, J	BOS	15	9	3.47	0.94	0.09	0.40
Hernandez, F	SEA	14	14	3.46	0.95	0.08	0.42
Buehrle, M	CWS	13	9	3.58	0.52	0.09	0.44
Pineda, M	SEA	9	10	3.74	1.00	0.10	0.43
Colon, B	NYY	8	10	3.99	0.81	0.12	0.52
Tomlin, J	CLE	12	7	4.24	0.53	0.14	0.47
Pavano, C	MIN	9	13	4.29	0.46	0.10	0.54
Danks, J	CWS	8	12	4.32	0.78	0.10	0.52
Guthrie, J	BAL	9	17	4.32	0.62	0.13	0.53
Lewis, C	TEX	14	10	4.39	0.83	0.17	0.51
Scherzer, M	DET	15	9	4.42	0.88	0.14	0.52
Davis, W	TB	11	10	4.44	0.56	0.12	0.52
Porcello, R	DET	14	9	4.75	0.56	0.09	0.57