analysis and determined the linear regression formula and r2

User Generated

frob968

Mathematics

Description

this spreadsheet contains the data from a study that attempted to see if there is a correlation between the hours that students studied and the grade that they earned on a test. The correlation test you are about to run will help you to determine if there is, in fact, a correlation between study time and test score. If you find a strong correlation, then you will postulate whether you feel this indicates a causal relationship.

In a Microsoft Word document, respond to the following:

  1. Report the sample you selected and the question that was explored in the study.
  1. Report the r2 linear correlation coefficient and the linear regression equation produced in the Excel spreadsheet.
  1. What would be the value of Pearson’s r (simply the square root of r2)?
  1. Would Pearson’s r be positive or negative? What does this imply about the relationship between the factors in this study?
  1. What is the implication of any correlation found between the variables in the study you picked?
  1. Does this correlation imply a causal relationship? Explain.
  1. Are there other variables that you think should have been examined that would have improved this study or helped to pinpoint what factors are causal?

For this assignment, you will submit a spreadsheet and a report. The

spreadsheet will be the Microsoft Excel file containing your scatterplot

and analysis.

Unformatted Attachment Preview

Hours of Study 7 4 3 2.5 16 5 1.7 13 12 6 9 18 4 8 9 11.5 12 14 17 21 20 25 22 24 19 26 27 18.5 25.5 19.6 Exam score 63 60 48 51 80 65 53 83 80 73 65 82 85 67 69 72 74 75 78 91.5 94 97 93 89 90 88 95 84 94 90.5 Exam score 120 100 80 60 40 20 0 0 5 10 Exam score y = 1.5608x + 55.767 R² = 0.785 15 20 25 30
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

If there is any...


Anonymous
I was stuck on this subject and a friend recommended Studypool. I'm so glad I checked it out!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags