Watch the instructional video attached here Line of best fit video [+] before you start this problem.
Download the Excel sheet linked here. Baseball.xlsx
Give all answers to two decimal places.
1. Using all your data, get the line of best fit between "At Bats" and "Hits"
a) What percent of variability in "Hits" can be explained by the variability in "At Bats" %
b) The slope tells us that for every 100 "At bats" the number of "Hits" should go up by how many?
c) Use your equation to predict the number of hits if there are 1000 "at bats".
2) Filter the data by League to only have data from "AL->AL".
a) Using your filtered data, what percent of variability in "Hits" can be explained by the variability in "At Bats" %
b) Using your filtered data, the slope tells us that for every 100 "At bats" the number of "Hits" should go up by how many?
c) Use your equation to predict the number of hits if there are 1000 "at bats".
[more..]
Enter your answer as a number (like 5, -3, 2.2172) or as a calculation (like 5/3, 2^3, 5+4)
Enter DNE for Does Not Exist, oo for Infinity
Enter your answer as a number (like 5, -3, 2.2172) or as a calculation (like 5/3, 2^3, 5+4)
Enter DNE for Does Not Exist, oo for Infinity
Enter your answer as a number (like 5, -3, 2.2172) or as a calculation (like 5/3, 2^3, 5+4)
Enter DNE for Does Not Exist, oo for Infinity
Enter your answer as a number (like 5, -3, 2.2172) or as a calculation (like 5/3, 2^3, 5+4)
Enter DNE for Does Not Exist, oo for Infinity
Enter your answer as a number (like 5, -3, 2.2172) or as a calculation (like 5/3, 2^3, 5+4)
Enter DNE for Does Not Exist, oo for Infinity
Enter your answer as a number (like 5, -3, 2.2172) or as a calculation (like 5/3, 2^3, 5+4)
Enter DNE for Does Not Exist, oo for Infinity