Find the value of the correlation coefficient

Assignment Help Basic Statistics

Reference no: EM13987591

"Correlation and Regression"

View the 2014 SAT Scores by State: https://www.commonwealthfoundation.org/policyblog/detail/sat-scores-by-state-2014

Using Microsoft Excel, draw a scatterplot 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 scatterplot in the discussion thread.

Once you draw the scatterplot, 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.

Reference no: EM13987591

Questions Cloud

Amount of cash paid to suppliers : Purchases on credit during Year 3 amount to £20m. The trade payables (creditors) at the start of Year 3 were £6m. The trade payables (creditors) at the end of Year 3 were £4m. What is the amount of cash paid to suppliers during Year 3?

Purchases of goods or materials : Explain how the purchases of goods or materials is calculated if we know the cost of goods sold and the inventory (stock) at the start and end of the period.

What is the probability of randomly choosing red jelly bean : What is the probability of randomly choosing a red jelly bean from a jar containing 20 red, 23 green, and 7 black jelly beans

What happens to cash flow when working capital increases : 1. What happens to cash flow when working capital increases? 2. How is taxation paid calculated from the taxation payable and the taxation liability at the start and end of the period?

Find the value of the correlation coefficient : "Correlation and Regression"- 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

Effect on cash flow of increase in inventory levels : 1. What is the effect on cash flow of an increase in inventory levels? 2. What is the effect on cash flow of an increase in trade receivables (debtors)? 3. What is the effect on cash flow of an increase in trade payable..

What is the definition of cash : 1. What is the definition of ‘cash'? 2. What is the definition of ‘cash equivalent'?

Trend analysis on safe and sure plc : Carry out a trend analysis on Safe and Sure plc, using the historical summary set out in Appendix I. Write a short report on the key features emerging from the trends.

Limitations of historical cost accounting : What are the limitations of historical cost accounting? Why is it desirable to remeasure assets and liabilities subsequent to acquisition?

User Account

All Pages