Means and Statistics
Descriptive Statistics Worksheet
Directions: Answer each question completely, showing all your work. Refer to the SPSS tutorials located in the Topic 4 materials as needed. Copy and Paste the SPSS output into the word document for the calculations portion of the problems. (Please remember to answer the questions you must interpret the SPSS output).
1. A researcher is interested to learn if there is a linear relationship between the hours in a week spent exercising and a person’s life satisfaction. The researchers collected the following data from a random sample, which included the number of hours spent exercising in a week and a ranking of life satisfaction from 1 to 10 ( 1 being the lowest and 10 the highest).
|
Participant |
Hours of Exercise |
Life Satisfaction |
|
1 |
3 |
1 |
|
2 |
14 |
2 |
|
3 |
14 |
4 |
|
4 |
14 |
4 |
|
5 |
3 |
10 |
|
6 |
5 |
5 |
|
7 |
10 |
3 |
|
8 |
11 |
4 |
|
9 |
8 |
8 |
|
10 |
7 |
4 |
|
11 |
6 |
9 |
|
12 |
11 |
5 |
|
13 |
6 |
4 |
|
14 |
11 |
10 |
|
15 |
8 |
4 |
|
16 |
15 |
7 |
|
17 |
8 |
4 |
|
18 |
8 |
5 |
|
19 |
10 |
4 |
|
20 |
5 |
4 |
2. Find the mean hours of exercise per week by the participants.
3. Find the variance of the hours of exercise per week by the participants.
4. Determine if there is a linear relationship between the hours of exercise per week and the life satisfaction by using the correlation coefficient.
5. Describe the amount of variation in the life satisfaction ranking that is due to the relationship between the hours of exercise per week and the life satisfaction.
6. Develop a model of the linear relationship using the regression line formula.
© Grand Canyon University 2016 1