USA: +1(669)289-8683 
Sign in
KNOW SPSS ACCURATE WORK!
Assignment: Application: Analyzing Frequency Distributions
DUE 1/10/18 9 P.M EST (APPLICATION DATA ATTCHED ALONG WITH WORKSHEET YOU MUST COMPLETE)
Your goal for this Application is to analyze the frequency distributions of data provided as an SPSS data file. A worksheet is provided for this Application, in the form of a Microsoft Word document. Download the Module 4 Application Assignment Worksheet and paste your output—the frequency distribution table—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:
Run data distributions on the data file provided. Complete the Module 4 Application Assignment Worksheet, pasting the frequency distributions table 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 analyze frequency distributions of data provided as a Microsoft Excel file. Import the data into SPSS using the techniques described in Module 3 which is to import, and then run frequency distribution tables, as instructed below, in SPSS. Note: It is recommended that you save the SPSS data file as you will use the same file for modules 5 and 6 application assignments. Type your answers to all questions directly into the worksheet, and paste the required frequency distributions table at the end of this document.
Submit this Application Assignment by Day 7 of Week 7. AGE SEX GROUP CHNG_CHOL HDL GLYHB ———————————————————————————————————————
Step 1: Import the Microsoft Excel data file into SPSS
Step 2: Create an ungrouped frequency distribution table for each of the following:
AGE, SEX, GROUP, CHNG_CHOL,HDL, and GLYHB (be sure to save each output and paste into this worksheet document)
Step 3: Review your SPSS output and answer each of the following questions:
QUESTION
type answers below
What type of variable is AGE?
________________
What type of variable is SEX? ________________ What type of variable is GROUP? ________________ What type of variable is CHNG_CHOL? ________________ What type of variable is HDL? ________________ How many participants were aged 30-39 years? ________________ What percent of participants were 49 years old or younger? ________________ How many participants had no change in their cholesterol value? ________________ What percent of participants had HDL values of 43 mg/dL? ________________ How many participants had GLYHB values of 4.67 or less? ________________
Step 4: Paste each required frequency distribution table below.
© 2014 Laureate Education, Inc. Page 1 of 2
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 4 Application Assignment Worksheet
SPSS Frequencies
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 applic assign data_Cholesterol etc” and can be found in the module 4 . 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
