Application: Analyzing Quantitative Data

© 2018 Laureate Education, Inc.

PUBH6032 - Module 6 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: Conduct an independent samples t-test to determine if there is a difference between

Group 1 (medication) and Group 2 (placebo) in terms of changes in cholesterol values. Note

that the independent variable is GROUP, and the dependent variable is CHNG_CHOL. For this

analysis, use the default setting for a two-tailed test of significance.

1. In the top menu bar select Analyze > Compare Means > Independent Sample T Test.

2. Highlight CHNG_CHOL then click on the arrow button to move it over to the “Test

Variable(s)” box.

3. Highlight GROUP then click on the arrow button to move it over to the “Grouping

Variable” box.

4. Click on the Define Groups button. In the “Group 1” box enter “1.” In the “Group 2”

enter “2.” Click Continue.

5. Click OK.

Step 3: Conduct a between-subjects ANOVA to determine if there is a difference between sex

(males vs. females) and HDL. Note that the independent variable is SEX, and the dependent

variable is HDL. For this analysis, use the default setting for a two-tailed test of significance.

1. In the top menu bar select Analyze > Compare Means > One-Way ANOVA.

2. Highlight HDL then click on the arrow button to move it over to the “Dependent List”

box.

3. Highlight SEX then click on the arrow button to move it over to the “Factor” box.

4. Click on the Options button and select “Descriptive.” Click Continue.

5. Click OK.

Step 4: Conduct a Pearson correlation to determine if there is a relationship between HDL and

GLYHB. For this analysis, use the default setting for a two-tailed test of significance.

1. In the top menu bar select Analyze > Correlate > Bivariate.

2. Highlight HDL and GLYHB then click on the arrow button to move it over to the

“Variables” box.

3. Click on the Options button and select “Means and standard deviations.” Click Continue.

© 2018 Laureate Education, Inc.

4. Click OK.

Step 5: Review your SPSS output and answer each of the following questions:

1. Mean and standard deviation can be found in the Group Statistics (T Test), Descriptives

(ANOVA), and Descriptive Statistics (Pearson correlation) tables.

2. The t-test score and probability (significance value) can found in the Independent

Samples Table, under t-test for Equality of Means. Look for “Equal variances assumed”

on the left side of the table and follow over to the “t” and “Sig. (2-tailed)” columns.

3. The F-value and probability (significance value) can be found in the ANOVA table. Look

for “Between groups” on the left side of the table and follow over to the “F” and “Sig.”

columns.

4. The Pearson correlation score and probability (significance value) can be found in the

Correlations table. Look for “Pearson correlation” listed next to HDL on the left side of

the table and follow over to the value listed under the GLYHB column. Notice that this

value is listed a second time below. This is because the table reports the Pearson

correlation in two combinations, HDL-GLYHB and GLYHB-HDL. The values should be the

same.

Step 6: Paste each required frequency distribution table below.

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_Module6). (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.