simple regression 1 Find the simple correlation coefficient

1) Find the simple correlation coefficient, r, value between Won and Runs. Put your formula in cell 06 on the sheet named Basebal12011 2) Is the value of r you found in Part 1 statistically significantly different than 0? Do an appropriate statistical test. We covered three different tests in the notes- use any of the three (HINT: One of them is particularly easy to do). Please put your answer on the Basebal12010 sheet in the area provided. In addition, discuss what the value of r you found means in terms of the relationship between Won and Runs. 3) Create a scatter plot between Won and Runs, treating Runs as the independent variable (X-axis). Your scatter plot should have a title and axis labels and should live on its own chart sheet. Name this sheet Scatter. 4) Add a linear trend line to your scatter plot. Show the fitted trend line equation and R2 value on the graph. Make sure the trend line equation is readable - adjust font and other formatting as you deem appropriate. 5) What is the relationship between the simple correlation coefficient, r, that you found in part 1 and the value of R2 that you found in part 4? Put your answer below your answer to part 2 on the Baseball2010 sheet. 6) In class I demonstrated how we can use Excel to compute all of the detailed items we need to find the least squares estimate of the slope and Y-intercept of a simple linear regression model. See Global100- InClass.xlsx as well as 12-06 RegressionCalculations-wFunctionsSolverLINEST.xlsx (sheet Calculations). I\'ve already include column headings (starting in R3) for the quantities you need to compute for each row of the data set. After doing that, create a formula in Excel to compute the slope and intercept using the equations:

Solution