Note: So you don't have to type in all this data, you may want to right mouse click on a sheet name and "Insert" another sheet. Then copy and Paste special (as text) the entire chart to the new sheet. You can then copy and paste any column from the new sheet to the sheet you need to put the data in.

The following is a chart of 25 baseball players' salaries and statistics from 2016.

Player Name	RBI's	HR's	AVG	Salary (in millions)
Mike Trout	100	29	0.315	16.083
Troy Tulowitzki	79	24	0.256	20.000
Ben Zobrist	76	18	0.272	10.500
Miquel Cabrera	108	38	0.316	28.050
Brandon Crawford	84	12	0.275	6.000
Justin Upton	87	31	0.246	22.125
Jayson Werth	70	21	0.244	21.571
Chris Davis	84	38	0.221	21.119
Joey Votto	97	29	0.326	20.000
Matt Wieters	66	17	0.243	15.800
Adrian Beltre	104	32	0.300	18.000
Prince Fielder	44	8	0.212	18.000
Victor Martinez	86	27	0.289	18.000
Robinson Cano	103	39	0.298	24.050
J.D. Martinez	68	22	0.307	6.750
Ryan Braun	91	31	0.305	20.000
Jason Heyward	49	7	0.230	21.667
Buster Posey	80	14	0.288	20.802
Jacoby Ellsbury	56	9	0.263	21.143
Mark Teixeira	44	15	0.204	23.125
Justin Turner	90	27	0.277	5.100
Matt Kemp	108	35	0.268	21.500
Jean Segura	64	20	0.320	2.600
Evan Gattis	72	32	0.251	3.300
Hunter Pence	57	13	0.289	18.500

In order to have correlation at the 0.05 significance between RBI's and Annual Salary, what is the critical r-value that we would like to have?  

(Round to three decimal places for all answers on this assignment.)

RBI vs. Salary

Complete a correlation analysis, using RBI's as the x-value and salary as the y-value. 

Correlation coefficient:

Regression Equation: $\displaystyle {y}=$ Preview Question 6 Part 3 of 12  

Do you have significant correlation? ? Yes No

HR vs. Salary

Complete a correlation analysis, using HR's as the x-value and salary as the y-value. 

Correlation coefficient:

Regression Equation: $\displaystyle {y}=$ Preview Question 6 Part 6 of 12    

Do you have significant correlation? ? Yes No  

AVG vs. Salary

Complete a correlation analysis, using AVG as the x-value and salary as the y-value. 

Correlation coefficient:  

Regression Equation: $\displaystyle {y}=$ Preview Question 6 Part 9 of 12    

Do you have significant correlation? ? Yes No

Prediction

Based on your analysis, if you had to predict a player's salary, which method would be the best? Select an answer Regression equation with RBI's Regression equation with HR's Regression equation with AVG The average of the 25 salaries

Using that method, predict the salary for Aaron Hill. His stats were:

RBI: 38

HR: 10

AVG: 0.262

Based on your analysis, his predicted salary would be: $ million 

His actual salary was $12.000 million.