PSY-380 Introduction to Probability and Statistics
Project 3 – SPSS or Excel Analyses
*My outputs were not pasting correctly to the word document and were
unreadable. Hope is okay I screenshotted and pasted them instead.
In SPSS or Excel, run the correct statistical test for each study.
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).
Participan Hours of Life
t Exercise 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
© 2024. Grand Canyon University. All Rights Reserved.
This study source was downloaded by 100000897871198 from CourseHero.com on 04-08-2025 12:01:38 GMT -05:00
https://www.coursehero.com/file/243954172/Project-3-SPSS-Excel-Analysesdocx/
, a. 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.
Response: Mean: 8.85 / Variance: 13.397 or 13.4 / Standard Deviation: 3.66
b. 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.
Response: According to the chart above, there is a negative correlation between exercise and
satisfaction. R= -.103 P
© 2024. Grand Canyon University. All Rights Reserved.
This study source was downloaded by 100000897871198 from CourseHero.com on 04-08-2025 12:01:38 GMT -05:00
https://www.coursehero.com/file/243954172/Project-3-SPSS-Excel-Analysesdocx/
Project 3 – SPSS or Excel Analyses
*My outputs were not pasting correctly to the word document and were
unreadable. Hope is okay I screenshotted and pasted them instead.
In SPSS or Excel, run the correct statistical test for each study.
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).
Participan Hours of Life
t Exercise 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
© 2024. Grand Canyon University. All Rights Reserved.
This study source was downloaded by 100000897871198 from CourseHero.com on 04-08-2025 12:01:38 GMT -05:00
https://www.coursehero.com/file/243954172/Project-3-SPSS-Excel-Analysesdocx/
, a. 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.
Response: Mean: 8.85 / Variance: 13.397 or 13.4 / Standard Deviation: 3.66
b. 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.
Response: According to the chart above, there is a negative correlation between exercise and
satisfaction. R= -.103 P
© 2024. Grand Canyon University. All Rights Reserved.
This study source was downloaded by 100000897871198 from CourseHero.com on 04-08-2025 12:01:38 GMT -05:00
https://www.coursehero.com/file/243954172/Project-3-SPSS-Excel-Analysesdocx/
