Summary PUBH 6033 Week2Assgn1.UchenduD.doc

Walking plus strength training exercise program results



Master of Public Health, Walden University

PUBH 6033: Interpretation and Application of Public Health
Data




Hands on SPSS
Instruction
s
For this assignment, review this week’s Learning Resources, and then create and analyze
frequency distributions and summary statistics of data provided as a Microsoft Excel file. Import
the data into SPSS. Then run frequency distribution graphs and tables and calculate summary
statistics in SPSS as instructed below. Note: It is recommended that you save the SPSS data file,
as you will use the same file for a Week 7 Application Assignment. Type your answers to all
questions and paste all required output directly into the worksheet at the end of this document.

Submit this Application Assignment by Day 7.
---------------------------------------------------------------------------------------------------------------------

Research Scenario

A study was conducted to determine if a walking plus strength training exercise program results
in a significantly greater increase in aerobic capacity as compared to a walking only exercise
program. Participants are randomly selected and then randomly assigned to one of the exercise

,groups. Participants’ aerobic endurance was assessed at the beginning of the study and, again,
after 6-months of exercise.

Coding for study variables:
AGE—age in years
SEX—1 =male, 2=female
EXERCISE—1= walking and strength training; 2 = walking;


 CHNG_ENDUR—change in maximal oxygen uptake (liters per minute) from pre-test
to post-test
---------------------------------------------------------------------------------------------------------------------
Note: Save all of your SPSS output. You will paste copies of in Step
11.

Step 1: Review this week’s Learning Resources.

Step 2: Import the Microsoft Excel data file provided in this week’s learning resources into
SPSS.

Step 3: Run and save the Codebook for your SPSS data file.

Step 4: Create an ungrouped frequency distribution table for each of the following:

, AGE, SEX, EXERCISE, and
CHNG_ENDUR.

Step 5: Run descriptive/summary statistics (mean, median, mode, standard deviation, and
range) for both exercise types combined for AGE and CHNG_ENDUR.

Step 6: SPLIT the data file by exercise type (EXERCISE).

Step 7: Create a line graph that illustrates CHNG_ENDUR for each exercise type separately.

Step 8: Create pie charts for SEX for each exercise type group.

Step 9: Run descriptive/summary statistics (mean, median, mode, standard deviation, and
range) for each exercise type separately for AGE and CHNG_ENDUR.

Step 10: Review all of your SPSS output and answer each of the following questions:



QUESTION type answers below
Scor(etoentered biynstruc
1. How many participants were female? 18 / 2 point

2. How many participants were aged 40–49
8 / 2 points
years?
3. What percent of participants were 39
65 / 2 points
years old or younger?
4. How many participants had 5 liter/min.
8 / 2 points
increase in their maximal oxygen uptake?
5. How many participants had >7 liter/min.
2 / 2 points
increase in their maximal oxygen uptake?
For exercise types 1 and 2 combined:

6. What is the mean for AGE? 35.70_ / 2 points

7. What is the median for AGE? 34.50 / 2 points

8. What is the standard deviation for AGE? 11.815 / 2 points

9. What is the mean for CHANGE_ENDUR? 4.175 / 2 points

10. What is the median for CHANGE_ ENDUR? 4.00 / 2 points

11. What is the range for CHANGE_ ENDUR? 7.00 / 2 points