Quantitative Literacy | MAT106 A01

Linear Regression

Now that you’ve completed your analysis and determined the linear regression formula and r2, it now time to report on the results of your study and examine your findings.

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 help to pinpoint what factors are causal?

Sheet1

3

5

80

6

65

4

8

9

12

94

Hours of Study	Exam score
7		6	3
	4	60
4	8
2.	5	51
16		80
	65
1.7	53
13	83
	12
73
	9
18	82
85
67
69
11.5	72
74
14	75
17	78
21	91.5
20		94
25	97
22	93
24	89
19	90
26	88
27	95
18.5	84
25.5
19.6	90.5

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.600000000000001 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

Sheet2

Sheet3