Question

SPSS: Correlation

Use SPSS or Excel to calculate the appropriate correlation coefficient for the following data for “Hours of Exercise” and “Life Satisfaction.” (0 = Not at all satisfied). Provide an APA-style results section write – up. (b) Graph the relationship.

HINT: Below you will find instructions for the APA-style write-up.

Complete the write-up on a word document and upload the file for submission.

Hours of Exercise.   

2

0

5

6

1

2

4

4

3

4

life satisfaction

6

2

13

15

3

6

10

12

8

10

Answer 1

Hours	Satisfaction
2	6
0	2
5	13
6	15
1	3		Correlation	0.988842
2	6
4	10
4	12
3	8
4	10

The correlation coefficient is 0.9884. This is obtained by the CORREL(B2:B11,C2:C11) function in EXCEL. This gives a high degree of liner relationship between the hours of exercise and the Life satisfaction. This indicates that the relationship is positive indicating that the higher the exercise hours put, the higher is the life satisfaction. This correlation coefficient is significant (at 5% since the critical value for 8 df is 0.6319).since it is more than the critical value.

(b). The Scatterplot with the trendline drawn is presented below:

We can see clearly that the points are closer to the line.