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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!