Create and Analyze Frequency Distributions of Data Order Instructions:
Kindly view the attached files
SAMPLE ANSWER
Module 4 Application Assignment Worksheet
SPSS Frequencies
Instructions
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, 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.
Create and Analyze Frequency Distributions of Data 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 4, 5, and 6 application assign data_Cholesterol etc” and can be found in module 4 learning resources. The codebook for the data provided is as follows:
AGE Age in years
SEX 1 =male, 2=female
GROUP 1 =medication, 2=placebo
CHNG_CHOL change in cholesterol from pre-test to post-test
HDL High-density lipoprotein at post-test
GLYHB Glycosylated hemoglobin at post-test
———————————————————————————————————————
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.
Create and Analyze Frequency Distributions of Data Sample Answer
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,H DL, 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? | Numerical variable: |
| What type of variable is SEX? | Nominal variable |
| What type of variable is GROUP? | Nominal variable |
| What type of variable is CHNG_CHOL? | Numerical variable |
| What type of variable is HDL? | Numerical variable |
| How many participants were aged 30-39 years? | They were 11 participants |
| What percent of participants were 49 years old or younger? | They were 87.5% of participants how were 49 years old or younger. |
| How many participants had no change in their cholesterol value? | 15.00% of the participants had no change in their cholesterol level. |
| What percent of participants had HDL values of 43 mg/dL? | 7.5% of the participants had a HDL values of 43 mg/dL. |
| How many participants had GLYHB values of 4.67 or less? | 45.0% of the participants had a GLYHB values of 4.67 or less. |
Step 4: Paste each required frequency distribution table below.
| Age in years | |||||
| Frequency | Percent | Valid Percent | Cumulative Percent | ||
| Valid | 17 | 1 | 2.5 | 2.5 | 2.5 |
| 18 | 1 | 2.5 | 2.5 | 5.0 | |
| 20 | 2 | 5.0 | 5.0 | 10.0 | |
| 21 | 1 | 2.5 | 2.5 | 12.5 | |
| 22 | 2 | 5.0 | 5.0 | 17.5 | |
| 23 | 2 | 5.0 | 5.0 | 22.5 | |
| 28 | 2 | 5.0 | 5.0 | 27.5 | |
| 29 | 1 | 2.5 | 2.5 | 30.0 | |
| 31 | 1 | 2.5 | 2.5 | 32.5 | |
| 32 | 2 | 5.0 | 5.0 | 37.5 | |
| 35 | 3 | 7.5 | 7.5 | 45.0 | |
| 37 | 2 | 5.0 | 5.0 | 50.0 | |
| 38 | 2 | 5.0 | 5.0 | 55.0 | |
| 39 | 1 | 2.5 | 2.5 | 57.5 | |
| 41 | 1 | 2.5 | 2.5 | 60.0 | |
| 42 | 1 | 2.5 | 2.5 | 62.5 | |
| 43 | 3 | 7.5 | 7.5 | 70.0 | |
| 44 | 2 | 5.0 | 5.0 | 75.0 | |
| 47 | 1 | 2.5 | 2.5 | 77.5 | |
| 49 | 4 | 10.0 | 10.0 | 87.5 | |
| 50 | 2 | 5.0 | 5.0 | 92.5 | |
| 55 | 1 | 2.5 | 2.5 | 95.0 | |
| 64 | 1 | 2.5 | 2.5 | 97.5 | |
| 65 | 1 | 2.5 | 2.5 | 100.0 | |
| Total | 40 | 100.0 | 100.0 | ||
| sex | |||||
| Frequency | Percent | Valid Percent | Cumulative Percent | ||
| Valid | male | 20 | 50.0 | 50.0 | 50.0 |
| female | 20 | 50.0 | 50.0 | 100.0 | |
| Total | 40 | 100.0 | 100.0 | ||
| group | |||||
| Frequency | Percent | Valid Percent | Cumulative Percent | ||
| Valid | Medication | 20 | 50.0 | 50.0 | 50.0 |
| Placebo | 20 | 50.0 | 50.0 | 100.0 | |
| Total | 40 | 100.0 | 100.0 | ||
| change in cholesterol from pre-test to post-test | |||||
| Frequency | Percent | Valid Percent | Cumulative Percent | ||
| Valid | -16 | 1 | 2.5 | 2.5 | 2.5 |
| -10 | 3 | 7.5 | 7.5 | 10.0 | |
| -9 | 1 | 2.5 | 2.5 | 12.5 | |
| -8 | 1 | 2.5 | 2.5 | 15.0 | |
| -7 | 2 | 5.0 | 5.0 | 20.0 | |
| -6 | 1 | 2.5 | 2.5 | 22.5 | |
| -5 | 2 | 5.0 | 5.0 | 27.5 | |
| -4 | 3 | 7.5 | 7.5 | 35.0 | |
| -3 | 3 | 7.5 | 7.5 | 42.5 | |
| -2 | 5 | 12.5 | 12.5 | 55.0 | |
| -1 | 6 | 15.0 | 15.0 | 70.0 | |
| 0 | 6 | 15.0 | 15.0 | 85.0 | |
| 1 | 4 | 10.0 | 10.0 | 95.0 | |
| 2 | 2 | 5.0 | 5.0 | 100.0 | |
| Total | 40 | 100.0 | 100.0 | ||
| High density lipoprotein at post-test | |||||
| Frequency | Percent | Valid Percent | Cumulative Percent | ||
| Valid | 28 | 1 | 2.5 | 2.5 | 2.5 |
| 30 | 1 | 2.5 | 2.5 | 5.0 | |
| 33 | 1 | 2.5 | 2.5 | 7.5 | |
| 34 | 2 | 5.0 | 5.0 | 12.5 | |
| 35 | 1 | 2.5 | 2.5 | 15.0 | |
| 36 | 1 | 2.5 | 2.5 | 17.5 | |
| 37 | 1 | 2.5 | 2.5 | 20.0 | |
| 38 | 1 | 2.5 | 2.5 | 22.5 | |
| 39 | 2 | 5.0 | 5.0 | 27.5 | |
| 41 | 3 | 7.5 | 7.5 | 35.0 | |
| 42 | 1 | 2.5 | 2.5 | 37.5 | |
| 43 | 3 | 7.5 | 7.5 | 45.0 | |
| 44 | 2 | 5.0 | 5.0 | 50.0 | |
| 46 | 2 | 5.0 | 5.0 | 55.0 | |
| 47 | 3 | 7.5 | 7.5 | 62.5 | |
| 49 | 3 | 7.5 | 7.5 | 70.0 | |
| 50 | 1 | 2.5 | 2.5 | 72.5 | |
| 51 | 3 | 7.5 | 7.5 | 80.0 | |
| 52 | 1 | 2.5 | 2.5 | 82.5 | |
| 53 | 2 | 5.0 | 5.0 | 87.5 | |
| 54 | 2 | 5.0 | 5.0 | 92.5 | |
| 56 | 1 | 2.5 | 2.5 | 95.0 | |
| 64 | 1 | 2.5 | 2.5 | 97.5 | |
| 69 | 1 | 2.5 | 2.5 | 100.0 | |
| Total | 40 | 100.0 | 100.0 | ||
| Glycosylated hemoglobin at post-test | |||||
| Frequency | Percent | Valid Percent | Cumulative Percent | ||
| Valid | 3.41 | 1 | 2.5 | 2.5 | 2.5 |
| 3.94 | 2 | 5.0 | 5.0 | 7.5 | |
| 3.98 | 1 | 2.5 | 2.5 | 10.0 | |
| 4.25 | 1 | 2.5 | 2.5 | 12.5 | |
| 4.31 | 1 | 2.5 | 2.5 | 15.0 | |
| 4.33 | 2 | 5.0 | 5.0 | 20.0 | |
| 4.44 | 1 | 2.5 | 2.5 | 22.5 | |
| 4.47 | 1 | 2.5 | 2.5 | 25.0 | |
| 4.52 | 1 | 2.5 | 2.5 | 27.5 | |
| 4.53 | 1 | 2.5 | 2.5 | 30.0 | |
| 4.59 | 1 | 2.5 | 2.5 | 32.5 | |
| 4.63 | 1 | 2.5 | 2.5 | 35.0 | |
| 4.64 | 2 | 5.0 | 5.0 | 40.0 | |
| 4.67 | 2 | 5.0 | 5.0 | 45.0 | |
| 4.77 | 2 | 5.0 | 5.0 | 50.0 | |
| 4.81 | 1 | 2.5 | 2.5 | 52.5 | |
| 4.84 | 3 | 7.5 | 7.5 | 60.0 | |
| 4.87 | 1 | 2.5 | 2.5 | 62.5 | |
| 4.97 | 1 | 2.5 | 2.5 | 65.0 | |
| 5.00 | 1 | 2.5 | 2.5 | 67.5 | |
| 5.12 | 1 | 2.5 | 2.5 | 70.0 | |
| 5.14 | 2 | 5.0 | 5.0 | 75.0 | |
| 5.26 | 2 | 5.0 | 5.0 | 80.0 | |
| 5.28 | 2 | 5.0 | 5.0 | 85.0 | |
| 5.78 | 1 | 2.5 | 2.5 | 87.5 | |
| 6.22 | 1 | 2.5 | 2.5 | 90.0 | |
| 6.72 | 1 | 2.5 | 2.5 | 92.5 | |
| 6.75 | 1 | 2.5 | 2.5 | 95.0 | |
| 6.99 | 1 | 2.5 | 2.5 | 97.5 | |
| 7.72 | 1 | 2.5 | 2.5 | 100.0 | |
| Total | 40 | 100.0 | 100.0 | ||
