## Question

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.

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 applic assign data_Cholesterol etc” and can be found in the module 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 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

For groups 1 and 2 (medication and placebo) combined:

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? ________________

For group 1 (medication) only:

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? ________________

For group 2 (placebo) only:

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.

## Solution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

1. What is the mean for AGE? 37.172. What is the median for AGE? 37.50

3. What is the standard deviation for AGE? 12.262

4. What is the mean for CHANGE_CHOL? -3.05

5. What is the median for CHANGE_CHOL? -2.00

6. What is the standard deviation for CHANGE_CHOL? 4.006

7. What is the mean for HDL? 45.08...