Week 4 assignments

Title ABC/123 Version X

1

Comparing Means Worksheet PSYCH/625 Version 5

1

University of Phoenix Material

Comparing Means Worksheet

The following questions require that you access Microsoft® Excel® for analysis. The team must work together to solve these questions. The data set for this assignment is located in the Pulse Rate Dataset.

1. 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 2591.026

b. Sums of squares for the exercise effect

c. Mean for moderate exercisers

d. P value for exercise effect 2.59E-77

2. Write a 125- to 175-word summary of the results, formatted according to APA guidelines.

Copyright © XXXX by University of Phoenix. All rights reserved.

Copyright © 2018 by University of Phoenix. All rights reserved.

Anova: Single Factor

SUMMARY

GroupsCountSumAverageVariance

Exercise551202.1818180.373737

Pulse 155413975.25455112.971

ANOVA

Source of VariationSSdfMSFP-valueF crit

Between Groups146839.61146839.62591.0262.59E-773.929012

Within Groups6120.61810856.67239

Total152960.3109