“Correlation and Regression”
View the 2014 SAT Scores by State: http://www.commonwealthfoundation.org/policyblog/detail/sat-scores-by-state-2014
Using Microsoft Excel, draw a scatter plot of the Participation Rate (x-axis) vs. Combined SAT Scores (y-axis). DO NOT USE THE %-SYMBOLS when putting the data into the spreadsheet. ALSO, DO NOT change the percents to decimals. For example, North Dakota has a participation rate of 2.3% and a combined SAT score of 1816. In the Excel spreadsheet, you would simply input 2.3 & 1816 for the North Dakota data. Provide a copy of your scatter plot in the discussion thread.
Once you draw the scatter plot, describe the relationship between participation rate and combined SAT scores. Make sure you state whether it is a positive or negative relationship and whether the relationship is strong, moderate, or weak. Also, what does this relationship say in “simple language?”
Find the value of the correlation coefficient (r) and explain what that means in relationship to the problem.
Find the equation of the least squares regression line.
Use the equation of the least squares regression line to “predict” the combined SAT score for a state whose participation rate is 21.8%. Does “correlation imply causation?” Use the example of SAT scores and participation rate to discuss this with your classmates.