Question: In Excel, run the correct statistical test A researcher is interested to learn if there is a linear relationship between the hours in a week
In Excel, run the correct statistical test
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 |
Run descriptive statistics on the data. Report the mean, variance and standard deviation for the data of hours of exercise per week by the participants. Copy and paste the SPSS or Excel output into the word document.
Run a bivariate correlation to determine if there is a linear relationship between the hours of exercise per week and life satisfaction. In 3-4 sentences interpret the results in words, then write the statistical results in APA style. Report the Pearson's Correlation and probability statistic.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
