USA: +1(669)289-8683 
Sign in
Assignment: Application: Analyzing Summary Statistics
DUE 1/25/18 8P.M EST BE ON TIME AND KNOW SPSS
Application Data is attached and also worksheet to complete is attached.
Your goal for this Application is to compute the summary statistics for a data set provided. Use SPSS to calculate the summary statistics, including the mean, median, mode, range, quartiles, interquartile range, semi-interquartile range, and the standard deviation.
A worksheet is provided for this Application, in the form of a Microsoft Word document. Download the Module 5 Application Assignment Worksheet and paste your output—the summary statistics you calculated—at the end of the document. Then, based on your output, answer the questions on the worksheet, typing your answers directly into the document.
The Assignment:
Complete the Module 5 Application Assignment Worksheet, pasting your summary statistics output at the end of the document. Be sure that your completed worksheet contains your responses to all questions and your SPSS output.
>Sheet 1 2 .72
1 2 2 . 9
7
4
2 1 1 1 1 2 -1 1 1 1 1 1 43 4.77 2 1 20 1 2 0 34 1 1 44 2 2 0 42 4.84 1 2 0 64 2 1 1 1 -10 49 44 1 1 2 2 -1 41 5.26 1 1 -4 54 22 1 2 39 2 1 4.33 38 2 2 -2 41 43 1 1 -3 41 5.14 50 1 2 1 38 For this assignment, you create and compute summary statistics for a dataset provided as a Microsoft Excel file. Import the data into SPSS and then calculate the summary statistics, including the mean, median, mode, range, range, and the standard deviation as instructed below. Note: DATA IS ATTACHED. Type your answers to all questions directly into the worksheet, and paste the required summary statistics output at the end of this document.
AGE SEX GROUP CHNG_CHOL HDL GLYHB ———————————————————————————————————————
Step 1: Import the Microsoft Excel data file into SPSS or use the correct saved SPSS data file as noted in the instructions, above.
Step 2: Run descriptive/summary statistics (mean, median, mode, standard deviation, and range) for both groups 1 and 2 (medication and placebo), combined for each of the following: AGE, CHNG_CHOL,HDL, and GLYHB (be sure to save your output)
Step 3: Separate the data file by group
Step 4: Run descriptive/summary statistics for each group separately for each of the following: AGE, CHNG_CHOL,HDL, and GLYHB (be sure to save your output)
Step 5: Review your SPSS output and answer each of the following questions:
QUESTION
type answers below
1. What is the mean for AGE?
________________
2. What is the median for AGE? ________________ 3. What is the standard deviation for AGE? ________________ 4. What is the mean for CHANGE_CHOL? ________________ 5. What is the median for CHANGE_CHOL? ________________ 6. What is the standard deviation for CHANGE_CHOL? ________________ 7. What is the mean for HDL? ________________ 8. What is the median for HDL? ________________ 9. What is the standard deviation for HDL? ________________ 10. What is the mean for GLYHB? ________________ 11. What is the median for GLYHB? ________________ 12. What is the standard deviation GLYHB? ________________ 13. What is the mean for CHANGE_CHOL? ________________ 14. What is the median for CHANGE_CHOL? ________________ 15. What is the standard deviation for CHANGE_CHOL? ________________ 16. What is the range for CHANGE_CHOL? ________________ 17. What is the mean for CHANGE_CHOL? ________________ 18. What is the median for CHANGE_CHOL? ________________ 19. What is the standard deviation for CHANGE_CHOL? ________________ 20. What is the range for CHANGE_CHOL? ________________
Step 6: Paste all required SPSS output below.
© 2014 Laureate Education, Inc. Page 1 of 3
2
3
ID
AGE
SEX
GROUP
CHNG_CHOL
HDL
GLYHB
1
5
0
-2
33
7
2
21
35
6
9
3 35 1 1
-5
4
4.
8
4
49
-1
51
4.33
5
38
–
16
47
4.81
6
42
34
5.
26
7
17
43
4.77
8
20
-6
9 49 2 2 -2 43
4.84
10
41
-4
53
4.
44
11
5.
28
12
55
-9
39
4.
64
13
14
23
30
5.78
15
-10
54
4.47
16
65
4.67
17 23 2 2 1
50
5.14
18
-7
56
4.59
19
29
20
32
4.63
21 18 1 2 1 28
6.75
22
-3
37
4.97
23 43 2 1 -3
52
4.
31
24
-8
46
25
5.28
26 22 2 2 -1 53
6.72
27
4.53
28 37 2 2 -2 39
5.12
29 49 2 1 -2 64
3.98
30 32 1 2 -1 49 5
31 43 2 1 0 51
4.25
32 35 2 2 0 44
4.64
33 47 1 1 -4 44
4.52
34 31 1 2 0
36
35 37 2 2 -1 47 4.67
36 28 2 1 -10 51
3.41
37 49 2 1 -7
69
3.94
38 35 2 2 2 46
6.22
39 28 2 1 -5 49 3.94
40
4.87
Module 5 Application Assignment Worksheet
SPSS Summary Statistics
Instructions
Research Scenario
A researcher is interested in the effect of a new medication on serum cholesterol, HDL cholesterol, and glycosylated hemoglobin of adults. The researcher randomly selects a sample of 40 (20 male and 20 female) participants who have been diagnosed with high cholesterol. Assuring equal distribution of males and females, the participants are randomly assigned to one of two conditions (or groups): Following pretest measures of serum cholesterol (CHOL), High density lipoprotein cholesterol (HDL), and glycosylated hemoglobin (GLYHB), the experimental group (group 1) is given the medication for a period of six months while the control group (group 2) is given a placebo. After the six months, CHOL, HDL and GLYHB are again measured.
The post-test data for each participant are provided in the data set “Module 5 DATA applic assign data_Cholesterol etc” and can be found in the module learning resources. The codebook for the data provided is as follows:
Age in years
1 =male, 2=female
1 =medication, 2=placebo
change in cholesterol from pre-test to post-test
High density lipoprotein at post-test
Glycosylated hemoglobin at post-test
For groups 1 and 2 (medication and placebo) combined:
For group 1 (medication) only:
For group 2 (placebo) only:
