Compute summary statistics for a dataset

Reference no: EM131697579

Application Assignment Worksheet

Summary Statistics

Instructions

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.

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

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

Reference no: EM131697579

Questions Cloud

Importance of photosynthesis to life on earth : 1. In a paragraph or two, describe the importance of photosynthesis to life on earth.

Prepare the journal entry to record the transaction : Prepare the journal entry to record the transaction of December 31, 2015, for the Pronghorn Co

Accounts for the small differences in dna : What is the mechanism that accounts for the small differences in our DNA? What are the details of the processes by which we obtain the DNA

Determine average unit cost : Basic accounting: using the Perpetual Accounting in weighted Average method, Determine average unit cost after Jan. 22 purchase

Compute summary statistics for a dataset : Compute summary statistics for a dataset provided as a Microsoft Excel file. Import the data into SPSS and then calculate the summary statistics

Digestive breakdown beginning in the mouth : Trace a molecule of CHO (carbohydrate) from Hot Fudge Cake from your fork to a cell of the left biceps. This should include all parts the Hot Fudge Cake touches

Describe what mattel should or could have done differently : Describe what Mattel should or could have done differently. Describe what was responsible for the fact that children were exposed to potentially dangerous toys.

Prepare an overview of the product : Prepare an overview of the product, its brand category, and the niche that it is intended to fill.

Restoring the grand am or to buy the neon : In trying to decide whether to restore the Grand Am or to buy the Neon, Heather is distressed because she already has spent $11,300 on the Grand Am.

Reviews

len1697579

10/30/2017 5:33:51 AM

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: If you correctly saved the data file from Module 4 assignment, you may open and use that saved file to complete this assignment. Type your answers to all questions directly into the worksheet, and paste the required summary statistics output at the end of this document.

Write a Review

Required(*) Message

User Account

All Pages