Application assignment
Swamped with your writing assignments? We'll take the academic weight off your shoulders. We complete all our papers from scratch. You can get a plagiarism report upon request just to confirm.
Order a Similar Paper Order a Different Paper
Instructions are attached, its due today
PUBH 6033—Week 2 Assignment 1
Hands on SPSS!
(Rubric included)
Instructions
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 6months 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 pretest to posttest
———————————————————————————————————————
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 
Score (to be entered by instructor)

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



6. What is the mean for AGE? 
________________ 
____ / 2 points 
7. What is the median for AGE? 
________________ 
____ / 2 points 
8. What is the standard deviation for AGE? 
________________ 
____ / 2 points 
9. What is the mean for CHANGE_ENDUR? 
________________ 
____ / 2 points 
10. What is the median for CHANGE_ ENDUR? 
________________ 
____ / 2 points 
11. What is the range for CHANGE_ ENDUR? 
________________ 
____ / 2 points 
12. What is the standard deviation for CHANGE_ ENDUR? 
________________ 
____ / 2 points 
For exercise type 1 (walking and strength training):



13. What is the mean for CHANGE_ ENDUR? 
________________ 
____ / 2 points 
14. What is the median for CHANGE_ ENDUR? 
________________ 
____ / 2 points 
15. What is the standard deviation for CHANGE_ ENDUR? 
________________ 
____ / 2 points 
For exercise type 2 (walking only):



16. What is the mean for CHANGE_ ENDUR? 
________________ 
____ / 2 points 
17. What is the median for CHANGE_ ENDUR? 
________________ 
____ / 2 points 
18. What is the standard deviation for CHANGE_ ENDUR? 
________________ 
____ / 2 points 
Step 11: Paste all required output below.
A. Output—SPSS Codebook
B. Output—all ungrouped frequency distribution tables:
C. Output—descriptive/summary statistics for both exercise groups combined:
D. Output—line graphs for CHNG_ENDUR for each exercise group separately:
E. Output—pie charts for SEX for each exercise group separately:
F. Output—descriptive/summary statistics for each exercise group separately:
Section below (scoring) is to be completed by Instructor
Scoring Rubric for Week 2 Assignment1—Hands on SPSS (60 points)
Timeliness

Fully Met

Partially Met/Good 
Partially Met/Fair 
Not Met 
Timeliness Indicators 
Posted by the deadline 
Posted 1 day late 
Posted 2–4 days late 
Posted 5 or more days late 
Grade impact 
No impact 
10% reduction in overall assignment score 
20% reduction in overall assignment score 
0 points 
Questions

18 questions (worth 2 points each) ____ / 36 points possible 
SPSS Output

Six SPSS outputs (4 points each for each of the following): A. Output—SPSS Codebook B. Output—all ungrouped frequency distribution tables: C. Output—descriptive/summary statistics for both exercise groups combined: D. Output—line graphs for CHNG_ENDUR for each exercise group separately: E. Output—pie charts for SEX for each exercise group separately: F. Output—descriptive/summary statistics for each exercise group separately: ____ / 24 points possible 
Initial Score (60 possible points):
Timeliness Factor (late points deducted):
Total Score (60 possible points):
Instructor comments:
© 2014 Laureate Education, Inc.
Page 1 of 4
Sheet3
ID  AGE  SEX  EXERCISE  CHNG_ENDUR 
1  53  1  2  5 
2  62  1  2  2 
3  34  1  1  6 
4  38  1  1  5 
5  39  1  1  4 
6  27  1  2  5 
7  18  1  1  7 
8  19  1  1  4 
9  49  1  2  5 
10  60  1  1  3 
11  22  1  2  7 
12  54  1  1  5 
13  55  2  2  3 
14  38  1  2  8 
15  62  2  1  6 
16  41  1  1  5 
17  63  2  2  3 
18  41  1  1  4 
19  29  2  2  4 
20  33  1  1  5 
21  26  2  2  8 
22  22  1  2  3 
23  43  2  1  6 
24  29  2  1  3 
25  48  2  2  4 
26  29  2  2  3 
27  43  1  1  4 
28  37  2  2  5 
29  25  2  1  6 
30  42  1  2  3 
31  43  2  1  5 
32  39  2  2  3 
33  45  1  1  4 
34  31  1  2  2 
35  57  2  2  3 
36  27  2  1  3 
37  49  2  1  8 
38  35  2  2  2 
39  27  2  1  5 
40  50  1  2  3 
W A L D E N U N I V E R S I T Y
P U B H 6 0 3 2 / 8 0 3 2
S P S S R E V E A L E D
P U B H 6 0 3 3 / 8 0 3 3
I N T E R P R E T A T I O N & A P P O F D A T A
Data Dictionary vs. Codebook
DATA DICTIONARY
Is used to show dictionary information for the
current working file
Is considered to be a simplified codebook
Contains less information than the codebook
DATA DICTIONARY
DICTIONARY INFORMATION :
All information on variables
Variable names
Variable labels – what it represents or what it measures
Measurement scale for variable nominal, ordinal ,etc.
Missing values
How variable originally recorded/reported including if numbers or
strings, how many characters if a string variable or how many
decimals if numeric)
For continuous or scale data variables: measurement units (inches,
feet, mL, lbs, etc.)
For string or categorical variables: If coded with numbers (not letters),
what the numbers mean per representing the underlying categorical
variable like 1=male
DATA DICTIONARY STEPS
Click on File > Display Data File Information
> Working File.
The codebook will print to the Output Viewer
window.
All information will be contained in a single
aggregate table
DATA DICTIONARY EXAMPLE
CODEBOOK
Provides all information you need on a variable in a
single table
Contains all the data dictionary information and
descriptive statistical information
Combines Display for dictionary information, the
Frequency command for categorical variables, and
the Descriptives command for scale variables.
CODEBOOK
CODEBOOK INFORMATION:
All display dictionary information
Descriptive statistical information
Each variable is shown in a separate table
Categorical variables will include counts and percentages
Scale variables will include summary statistics
CODEBOOK STEPS
Click on Analyze > Reports > Codebook.
In Variables tab: Add the variables you want to include. If you
want to include all variables, click inside the Variables box, then
press Ctrl + A, and then click arrow button. Then click OK to run
and display your codebook.
If you want to customize your codebook, which is optional, you can
click on the following tabs:
Output tab: You can choose the variable and datafile properties want
Variable display order: If you want to change the order of your variables in the
data file, you can change to make them alphabetical or by measurement level, etc..
Statistics tab: You can choose the statistics you wan. If no changes are made,
the default setting includes, counts and percentages for nominal and ordinal
variables; and mean and standard deviation for scale variables.
When finished, click OK.
CODEBOOK EXAMPLE
REFERENCES
Horber, E. (2016). Codebook. Retrieved from
http://www.unige.ch/ses/sococ/cl///spss/cmd/codebook.ht
ml?
Horber, E. (2016). Display dictionary. Retrieved from
http://www.unige.ch/ses/sococ/cl//spss/cmd/display.html
Kent State University. (2014). Creating a Codebook – SPSS
Tutorials. Retrieved from
http://libguides.library.kent.edu/SPSS/Codebooks
UCLA: Statistical Consulting Group. (2016). SPSS learning
module. Retrieved from
http://www.ats.ucla.edu/stat/spss/modules/labels.htm
We offer CUSTOMWRITTEN, CONFIDENTIAL, ORIGINAL, and PRIVATE writing services. Kindly click on the ORDER NOW button to receive an A++ paper from our masters and PhD writers.
Get a 10% discount on your order using the following coupon code SAVE10
Order a Similar Paper Order a Different Paper