PSY-380 Introduction to Probability and Statistics

Project 3 -Excel Analyses in 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).

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

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 Excel output into the word document

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.

2. Insomnia has become an epidemic in the United States. Much research has been done in the development of new pharmaceuticals to aide those who suffer from insomnia. Alternatives to pharmaceuticals are being sought by sufferers. A new relaxation technique has been tested to see if it is effective in treating the disorder. Sixty insomnia sufferers between the ages of 18 to 40 with no underlying health conditions volunteered to participate in a clinical trial. They were randomly assigned to either receive relaxation treatment or a proven pharmaceutical treatment. Thirty were assigned to each group. The amount of time it took each of them to fall asleep was measured and recorded. The data is shown below

a. Run a two-independent samples t-test to determine if the relaxation treatment is more effective than the pharmaceutical treatment at a level of significance of 0.05.

Copy and paste the Excel output into the word document.

b. In 3-4 sentences interpret the results in words, then write the statistical results in APA style. Report the t statistic and probability statistic.

Relaxation Pharmaceutical

98 20

117 35

51 130

28 83

65 157

107 138

88 49

90 142

105 157

73 39

44 46

53 194

20 94

50 95

92 161

112 154

71 75

96 57

86 34

92 118

75 41

41 145

102 148

24 117

96 177

108 119

102 186

35 22

46 61

74 75

3.A researcher is interested to learn if the level of interaction a woman in her 20s has with her mother influences her life satisfaction ratings. Below is a list of women who fit into each of four levels of interaction. Conduct a One-way Between Subjects ANOVA on the data to determine if there are differences between groups; does the level of interaction influence women's ratings of life satisfaction?

a. Report the results of the One-way Between Subjects ANOVA. If significance is found, run the appropriate post-hoc test and report between what levels the significant differences were found.

Copy and paste the Excel output into the word document.

b. In 3-4 sentences interpret the results in words, then write the statistical results in APA style. Report the F statistic and probability statistic.

No Interaction Low Interaction Moderate Interaction High Interaction

2 3 3 9

4 3 10 10

4 5 2 8

4 1 1 5

7 2 2 8

8 2 3 4

1 7 10 9

1 8 8 4

8 6 4 1

4 5 3 8