analysis and determined the linear regression formula and r2

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:Report the sample you selected and the question that was explored in the study.Report the r2 linear correlation coefficient and the linear regression equation produced in the Excel spreadsheet.What would be the value of Pearson’s r (simply the square root of r2)?Would Pearson’s r be positive or negative? What does this imply about the relationship between the factors in this study?What is the implication of any correlation found between the variables in the study you picked?Does this correlation imply a causal relationship? Explain.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.
sebensd_m3_a2.xls

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