Biostatistics

© 2018 Laureate Education, Inc.

PUBH6032 - Module 5 Application Step-By-Step Guide

Step 1: Import the Microsoft Excel data file into SPSS (see Module 4 step-by-step guide) or use

the correct saved SPSS data file from Module 4.

1. Open SPSS, select “Open an existing data source,” highlight “More Files,” and click OK.

2. Locate the folder where you saved the Module 4 Application dataset SPSS file, highlight

it, and click OK.

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

1. In the top menu bar select Analyze > Descriptive Statistics > Frequencies.

2. Highlight AGE, CHNG_CHOL, HDL, and GLYHB. Click on the arrow button to move them

over to the “Variables” box.

3. Click on the Statistics button. Under “Central Tendency,” select Mean, Median, and

Mode. Under “Dispersion,” select Std. deviation, Variance, and Range. Click Continue.

4. Click OK.

Step 3: Separate the data file by group

1. In the top menu bar, select Data > Split File. 2. Select “Organize output by groups.” 3. Highlight GROUP then click on the arrow button to move it over to the “Groups based on”

box. Click OK. 4. Any analyses will now reflect the split.

Note: To "un-split" the data, return to Data > Split File and select "Analyze All cases."

Step 4: Run descriptive/summary statistics for each group separately for each of the following:

AGE, CHNG_CHOL,HDL, and GLYHB

1. Repeat Step 2. Step 5: Review your SPSS output and answer each of the following questions:

1. Mean 2. Median 3. Mode 4. Std. Deviation 5. Range

Step 6: Paste each required frequency distribution table below.

© 2018 Laureate Education, Inc.

1. In the Viewer pane, select File > Export.

2. Under “Objects to Export,” select All.

3. From the “Type” drop-down list, select Word/RTF (*.doc).

4. In “File Name,” give the output a unique name (e.g., OUTPUT_Module4). (Note the file

folder where the Word document will be saved. The default is typically C:\Documents.)

5. Click OK to generate the Word file.

*Now you can cut-and-paste the information from this Word file into the Module worksheet.