Biostats HW WORKSHEET "Comparing 2 means"
vwccspt12
HELPFULHINTwk2assign.doc—Week 2 Assignment 1
Hands on SPSS!
(Rubric included)
Instructions
You will 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. Type your answers to all questions and paste all required output directly into the worksheet at the end of this document.
---------------------------------------------------------------------------------------------------------------------
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 |
Score (to be entered by instructor) |
|
1. How many participants were female? |
_______18_________ |
____ / 2 point |
|
2. How many participants were aged 40–49 years? |
______8__________ |
____ / 2 points |
|
3. What percent of participants were 39 years old or younger? |
_______65%_________ |
____ / 2 points |
|
4. How many participants had 5 liter/min. increase in their maximal oxygen uptake? |
_______5_________ |
____ / 2 points |
|
5. How many participants had >7 liter/min. increase in their maximal oxygen uptake? |
________4________ |
____ / 2 points |
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.69__________ |
____ / 2 points |
|
9. What is the mean for CHANGE_ENDUR? |
_______4.18_________ |
____ / 2points |
|
10. What is the median for CHANGE_ ENDUR? |
____4.00____________ |
____ / 2 points |
|
11. What is the range for CHANGE_ ENDUR? |
_____7___________ |
____ / 2 points |
|
12. What is the standard deviation for CHANGE_ ENDUR? |
___1.752_____________ |
____ /2 points |
For exercise type 1 (walking and strength training):
|
|
|
|
13. What is the mean for CHANGE_ ENDUR? |
________4.85________ |
____ / 2 points |
|
14. What is the median for CHANGE_ ENDUR? |
________5________ |
____ / 2 points |
|
15. What is the standard deviation for CHANGE_ ENDUR? |
_______1.424_________ |
____ / 2 points |
For exercise type 2 (walking only):
|
|
|
|
16. What is the mean for CHANGE_ ENDUR? |
___3.50_____________ |
____ / 2 points |
|
17. What is the median for CHANGE_ ENDUR? |
___3_____________ |
____ /2 points |
|
18. What is the standard deviation for CHANGE_ ENDUR? |
_____1.821___________ |
____ /2 points |
Step 11: Paste all required output below.
A. Output—SPSS Codebook
|
AGE |
||||
|
|
Value |
Count |
Percent |
|
|
Standard Attributes |
Position |
2 |
|
|
|
|
Label |
<none> |
|
|
|
|
Type |
Numeric |
|
|
|
|
Format |
F4 |
|
|
|
|
Measurement |
Nominal |
|
|
|
|
Role |
Input |
|
|
|
Valid Values |
18 |
|
2 |
5.0% |
|
|
19 |
|
1 |
2.5% |
|
|
22 |
|
3 |
7.5% |
|
|
23 |
|
1 |
2.5% |
|
|
25 |
|
1 |
2.5% |
|
|
26 |
|
1 |
2.5% |
|
|
27 |
|
3 |
7.5% |
|
|
28 |
|
1 |
2.5% |
|
|
29 |
|
3 |
7.5% |
|
|
30 |
|
1 |
2.5% |
|
|
31 |
|
1 |
2.5% |
|
|
33 |
|
1 |
2.5% |
|
|
34 |
|
1 |
2.5% |
|
|
35 |
|
1 |
2.5% |
|
|
37 |
|
1 |
2.5% |
|
|
38 |
|
2 |
5.0% |
|
|
39 |
|
2 |
5.0% |
|
|
40 |
|
1 |
2.5% |
|
|
41 |
|
1 |
2.5% |
|
|
42 |
|
1 |
2.5% |
|
|
43 |
|
2 |
5.0% |
|
|
45 |
|
1 |
2.5% |
|
|
47 |
|
1 |
2.5% |
|
|
49 |
|
1 |
2.5% |
|
|
50 |
|
2 |
5.0% |
|
|
54 |
|
1 |
2.5% |
|
|
55 |
|
1 |
2.5% |
|
|
61 |
|
1 |
2.5% |
|
|
63 |
|
1 |
2.5% |
|
SEX |
||||
|
|
Value |
Count |
Percent |
|
|
Standard Attributes |
Position |
3 |
|
|
|
|
Label |
<none> |
|
|
|
|
Type |
Numeric |
|
|
|
|
Format |
F4 |
|
|
|
|
Measurement |
Nominal |
|
|
|
|
Role |
Input |
|
|
|
Valid Values |
1 |
|
22 |
55.0% |
|
|
2 |
|
18 |
45.0% |
|
EXERCISE |
||||
|
|
Value |
Count |
Percent |
|
|
Standard Attributes |
Position |
4 |
|
|
|
|
Label |
<none> |
|
|
|
|
Type |
Numeric |
|
|
|
|
Format |
F4 |
|
|
|
|
Measurement |
Nominal |
|
|
|
|
Role |
Input |
|
|
|
Valid Values |
1 |
|
20 |
50.0% |
|
|
2 |
|
20 |
50.0% |
|
CHNG_ENDUR |
||||
|
|
Value |
Count |
Percent |
|
|
Standard Attributes |
Position |
5 |
|
|
|
|
Label |
<none> |
|
|
|
|
Type |
Numeric |
|
|
|
|
Format |
F4 |
|
|
|
|
Measurement |
Nominal |
|
|
|
|
Role |
Input |
|
|
|
Valid Values |
1 |
|
2 |
5.0% |
|
|
2 |
|
3 |
7.5% |
|
|
3 |
|
12 |
30.0% |
|
|
4 |
|
8 |
20.0% |
|
|
5 |
|
5 |
12.5% |
|
|
6 |
|
6 |
15.0% |
|
|
7 |
|
2 |
5.0% |
|
|
8 |
|
2 |
5.0% |
B. Output—all ungrouped frequency distribution tables:
|
AGE |
|||||
|
|
Frequency |
Percent |
Valid Percent |
Cumulative Percent |
|
|
Valid |
18 |
2 |
5.0 |
5.0 |
5.0 |
|
|
19 |
1 |
2.5 |
2.5 |
7.5 |
|
|
22 |
3 |
7.5 |
7.5 |
15.0 |
|
|
23 |
1 |
2.5 |
2.5 |
17.5 |
|
|
25 |
1 |
2.5 |
2.5 |
20.0 |
|
|
26 |
1 |
2.5 |
2.5 |
22.5 |
|
|
27 |
3 |
7.5 |
7.5 |
30.0 |
|
|
28 |
1 |
2.5 |
2.5 |
32.5 |
|
|
29 |
3 |
7.5 |
7.5 |
40.0 |
|
|
30 |
1 |
2.5 |
2.5 |
42.5 |
|
|
31 |
1 |
2.5 |
2.5 |
45.0 |
|
|
33 |
1 |
2.5 |
2.5 |
47.5 |
|
|
34 |
1 |
2.5 |
2.5 |
50.0 |
|
|
35 |
1 |
2.5 |
2.5 |
52.5 |
|
|
37 |
1 |
2.5 |
2.5 |
55.0 |
|
|
38 |
2 |
5.0 |
5.0 |
60.0 |
|
|
39 |
2 |
5.0 |
5.0 |
65.0 |
|
|
40 |
1 |
2.5 |
2.5 |
67.5 |
|
|
41 |
1 |
2.5 |
2.5 |
70.0 |
|
|
42 |
1 |
2.5 |
2.5 |
72.5 |
|
|
43 |
2 |
5.0 |
5.0 |
77.5 |
|
|
45 |
1 |
2.5 |
2.5 |
80.0 |
|
|
47 |
1 |
2.5 |
2.5 |
82.5 |
|
|
49 |
1 |
2.5 |
2.5 |
85.0 |
|
|
50 |
2 |
5.0 |
5.0 |
90.0 |
|
|
54 |
1 |
2.5 |
2.5 |
92.5 |
|
|
55 |
1 |
2.5 |
2.5 |
95.0 |
|
|
61 |
1 |
2.5 |
2.5 |
97.5 |
|
|
63 |
1 |
2.5 |
2.5 |
100.0 |
|
|
Total |
40 |
100.0 |
100.0 |
|
|
SEX |
|||||
|
|
Frequency |
Percent |
Valid Percent |
Cumulative Percent |
|
|
Valid |
1 |
22 |
55.0 |
55.0 |
55.0 |
|
|
2 |
18 |
45.0 |
45.0 |
100.0 |
|
|
Total |
40 |
100.0 |
100.0 |
|
|
EXERCISE |
|||||
|
|
Frequency |
Percent |
Valid Percent |
Cumulative Percent |
|
|
Valid |
1 |
20 |
50.0 |
50.0 |
50.0 |
|
|
2 |
20 |
50.0 |
50.0 |
100.0 |
|
|
Total |
40 |
100.0 |
100.0 |
|
|
CHNG_ENDUR |
|||||
|
|
Frequency |
Percent |
Valid Percent |
Cumulative Percent |
|
|
Valid |
1 |
2 |
5.0 |
5.0 |
5.0 |
|
|
2 |
3 |
7.5 |
7.5 |
12.5 |
|
|
3 |
12 |
30.0 |
30.0 |
42.5 |
|
|
4 |
8 |
20.0 |
20.0 |
62.5 |
|
|
5 |
5 |
12.5 |
12.5 |
75.0 |
|
|
6 |
6 |
15.0 |
15.0 |
90.0 |
|
|
7 |
2 |
5.0 |
5.0 |
95.0 |
|
|
8 |
2 |
5.0 |
5.0 |
100.0 |
|
|
Total |
40 |
100.0 |
100.0 |
|
C. Output—descriptive/summary statistics for both exercise groups combined:
|
Statistics |
|||
|
|
AGE |
CHNG_ENDUR |
|
|
N |
Valid |
40 |
40 |
|
|
Missing |
0 |
0 |
|
Mean |
35.70 |
4.18 |
|
|
Median |
34.50 |
4.00 |
|
|
Mode |
22a |
3 |
|
|
Std. Deviation |
11.815 |
1.752 |
|
|
Range |
45 |
7 |
|
|
a. Multiple modes exist. The smallest value is shown |
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:
|
Statistics |
||||
|
EXERCISE |
AGE |
CHNG_ENDUR |
||
|
1 |
N |
Valid |
20 |
20 |
|
|
|
Missing |
0 |
0 |
|
|
Mean |
34.85 |
4.85 |
|
|
|
Median |
33.50 |
5.00 |
|
|
|
Mode |
27a |
4a |
|
|
|
Std. Deviation |
11.198 |
1.424 |
|
|
|
Range |
43 |
5 |
|
|
2 |
N |
Valid |
20 |
20 |
|
|
|
Missing |
0 |
0 |
|
|
Mean |
36.55 |
3.50 |
|
|
|
Median |
36.00 |
3.00 |
|
|
|
Mode |
22 |
3 |
|
|
|
Std. Deviation |
12.634 |
1.821 |
|
|
|
Range |
45 |
7 |
|
|
a. Multiple modes exist. The smallest value is shown |
|
Questions
|
|
18 questions (worth 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:
© 2017 Laureate Education, Inc. Page 1 of 11
