# University of Phoenix Comparing Means Worksheet John is interested in determining if frequency of exercise affects pulse rate. John randomly samples indivi

University of Phoenix Comparing Means Worksheet John is interested in determining if frequency of exercise affects pulse rate. John randomly samples individuals at a local gym to ask if they will participate in his study. 55 individuals agree, and they are divided into three groups of exercisers: 1 = high frequency, 2 = moderate frequency, 3 = low frequency. Next, John measures their pulse after their workout. Do pulse rates differ among individuals who exercise with high frequency versus those who exercise moderately versus those who exercise with low frequency?

Note: Make sure you adjust the data so that there are three exercise variables (one for each level).

Conduct a one-way ANOVA to investigate the relationship between exercise frequency (Exercise) and pulse rate (Pulse1). Conduct Tukey’s HSD post hoc tests, if necessary. On the output, identify the following:

a. F ratio for the group effect

b. Sums of squares for the exercise effect

c. Mean for moderate exercisers

d. P value for exercise effect Height Weight Age Gender Smokes Alcohol Exercise Ran Pulse1 Pulse2
173
57 18
2
2
1
2
2
86
88
179
58 19
2
2
1
2
1
82
150
167
62 18
2
2
1
1
1
96
176
195
84 18
1
2
1
1
2
71
73
173
64 18
2
2
1
3
2
90
88
184
74 22
1
2
1
3
1
78
141
162
57 20
2
2
1
2
2
68
72
169
55 18
2
2
1
2
2
71
77
164
56 19
2
2
1
1
2
68
68
168
60 23
1
2
1
2
1
88
150
170
75 20
1
2
1
1
1
76
88
178
58 19
1
2
2
3
2
74
76
170
68 22
1
1
1
2
2
70
71
187
59 18
1
2
1
1
2
78
82
180
72 18
1
2
1
2
2
69
67
185
110 22
1
2
1
3
2
77
73
170
56 19
1
2
2
3
2
64
63
180
70 18
1
2
1
2
1
80
146
166
56 21
2
1
2
2
2
83
79
155
50 19
2
2
2
2
2
78
79
175
60 19
1
2
2
3
2
88
86
140
50 34
2
2
2
3
1
70
98
163
55 20
2
2
2
3
2
78
74
182
75 26
1
1
1
2
2
80
76
176
59 19
1
2
2
2
2
68
69
177
74 18
2
2
2
2
1
70
96
170
60 18
1
2
1
2
2
62
59
172
60 21
2
2
2
3
2
81
79
189
60 19
1
2
1
2
1
78
168
178
56 21
2
2
1
2
1
86
150
175
75 20
1
2
1
2
1
59
92
180
85 19
1
1
1
2
1
68
125
160
57 19
2
2
2
2
1
75
130
164
66 23
2
2
2
3
1
74
168
175
65 19
1
2
1
2
1
60
104
163
55 20
2
2
2
2
1
70
119
185
90 18
1
2
2
3
1
80
140
169
68 19
1
2
2
2
2
58
58
165
63 18
2
2
1
2
2
84
84
155
49 18
2
2
1
2
2
104
92
175
66 20
1
2
1
2
2
66
68
178
63 23
1
2
1
3
2
84
90
184
65 21
1
1
2
2
2
65
67
170
60 19
2
2
1
2
2
80
80
162
60 19
2
2
1
2
2
66
60
164
46 18
2
2
2
2
2
104
96
171
182
174
167
157
183
167
171
182
70
85
60
70
41
73
75
67
63
26
20
19
22
20
20
20
18
20
2
1
2
1
2
1
2
2
1
2
1
2
1
2
2
2
2
2
2
1
1
1
2
1
1
1
1
2
3
3
3
2
2
2
3
1
2
2
1
2
1
2
2
2
1
76
70
66
92
70
63
65
76
56
76
68
89
84
95
65
67
74
110
Variable
Height
Weight
Age
Gender
Smokes
Alcohol
Exercise
Description
Height (cm)
Weight (kg)
Age (years)
Sex (1 = male, 2 = female)
Regular smoker? (1 = yes, 2 = no)
Regular drinker? (1 = yes, 2 = no)
Frequency of exercise (1 = high, 2 = moderate, 3 = low)
Whether the student ran or sat between the first and
Ran
second pulse measurements (1 = ran, 2 = sat)
Pulse1 First pulse measurement (rate per minute)
Pulse2 Second pulse measurement (rate per minute)
Comparing Means Worksheet
PSYCH/625 Version 5
University of Phoenix Material
Comparing Means Worksheet
The f ollowing questions require that you access Microsof t ® Excel® for analysis. The team must work
together to solve these questions. The data set f or this assignment is located in the Pulse Rate Dataset.
1.
John is interested in determining if f requency of exercise af f ects pulse rate. John randomly samples
individuals at a local gym to ask if they will participate in his study. 55 individuals agree, and they are
divided into three groups of exercisers: 1 = high f requency, 2 = moderate f requency, 3 = low
f requency. Next, John measures their pulse af ter their workout. Do pulse rates dif f er among
individuals who exercise with high f requency versus those who exercise moderately versus those
who exercise with low f requency?
Note: Make sure you adjust the data so that there are three exercise variables (one f or each level).
Conduct a one-way ANOVA to investigate the relationship between exercise f requency (Exercise)
and pulse rate (Pulse1). Conduct Tukey’s HSD post hoc tests, if necessary. On the output, identify
the f ollowing:
a. F ratio f or the group ef f ect
b. Sums of squares f or the exercise ef f ect
c. Mean f or moderate exercisers
d. P value f or exercise ef f ect
2.
Write a 125- to 175-word summary of the results, f ormatted according to APA guidelines.