EDD611 Inquiry I Lab 5

Lab 5 focuses on conducting a multiple regression utilizing 10-15 independent variables grounded in Astin's I-E-O model. 

By the end of Lab 5, students will be able to:

  • Conduct a multiple regression analysis
  • Apply Astin's I-E-O model to multiple regression analysis
  • Run a descritves to determine usability of variables
Getting Started

Before starting your exercises, ensure that your SPSS is open.

For instructions on how to download and/or open the SPSS software, please see the following guide: EDD611 Inquiry I Getting Started

It is strongly recommended to run a descriptive analysis of the variables you plan to use. 

This will allow you to verify that the selected variables have data. 

Astin's I-E-O Model
Diagram of Astin’s I-E-O model showing Inputs, Environment,  and Outputs. The model illustrates how student inputs interact with the educational environment to influence outcomes

Astin, A.W. (2012). Assessment for excellence: The philosophy and practice of assessment and evaluation in higher education. Rowman & Littlefield Publishers. 

Multiple Regression 

This multiple regression lab is based on the following research question: 

What is the relationship with student background characteristics, college experiences, and (your chosen variable)?

Example: What is the relationship with student background characteristics, college experiences, and Sense of Belonging?

Step 1:

Click on Analyze, Regression, then Linear

SPSS Data Editor screen highlight Analze, Regression, and Linear selections

Step 2:

Select the dependent (outcome) variable of your choice

Example: CSS Sense of Belong Score [SENSE_BELONG]

Linear Regression screen, highlight of a selected variable

Step 3:

Click on the top arrow button to add it to the Dependent field

Arrow pointing to arrow button on Linear Regression screen

Step 4:

Select the (input) variable of your choice

Example: Your sex: [SEX] 

Highlight of a selected variable on the Linear Regression screen

Step 5:

Click on the (second from top) arrow to add it to the Independent(s) field in Block 1 of 1

Arrow pointing to arrow button

Step 6:

Click on the Next button to move to Block 2

Arrow pointing to Next button on Linear Regression window

The block will update to show 'Block 2 of 2'

Highlight of 'Block 2 of 2'

Step 7:

Select the (environment) variable(s) of your choice

Highlight of a variable on the Linear Regression window

Step 8:

Click on the (second from top) arrow to add it to the Block 2 of 2 field

Arrow pointing to arrow button

See the Descriptives section for instructions on how to run a descriptive analysis

Step 9:

Repeat Steps 7 and 8 to add the additional (environment) variables of your choice:

Example: 

  • Satisfaction: Academic advising [SATIS01]
  • Act: Discussed course content with students outside of class[ACT14]
  • Act: Felt isolated from campus life [ACT23]
  • Act: Studied with other students [ACT55]

Step 10:

When you ahev added all of your variables, click on the Statistics button

Arrow pointing to Statistics button

Step 11:

Ensure the following checkboxes are checked:

  • Model fit

  • R squared change

  • Descriptives

  • Collinearity diagnostics

Highlight of the following fields: Model fit,  R squared change,  Descriptives,  Collinearity diagnostics

Step 13:

Click the Continue button 

Arrow pointing to Continue button

Step 14:

Click the OK button

Arrow pointing to OK button

The results will populate in your Output window

Highlight of the Coefficient table on the Output window
Errors?

If encounter the following error, you most likely included a variable with valid, complete, and usable information.

Sample Regression error stating there are no valid cases for models with dependent variable

It is recommended to select other variables and run a descriptive analysis to ensure there is usable data for that variable.

See the Descriptives section for more information

Descriptives

A descriptive analysis allow you to confirm that the variables you intend to use contain valid information.

Step 1:

Click Analyze, Descriptive Statistics, then Descriptives

SPSS Data Editor screen highlighting Analyze, Descriptive Statistics, and Descriptives options

Step 2:

Select the variable(s) you would like to check for data

Highlight of the Variables field

Step 3:

Click on the arrow button to move the variable to the Variable(s) field

Arrow pointing to the arrow button

Step 4:

When you have added all the variables you would like to check, click the OK button

Arrow pointing to the OK button

Step 5:

In your Output window, review the output for any field with a zero

Overview of the Output screen showing the Frequencies table

Any field with a '0' indicates that there is no data for that variable.

Frequencies table highlighting columns with a 0 result

You may want to change variables or just eliminate the variables with no data.

Assignment

Write up your multiple regression analysis, making sure to include the following elements:

  • Research question, noting your final variable
  • Dependent variable (Outcome)
  • Block 1 variables (Inputs)
  • Block 2 variables (Environment)

Example:

Sample Lab 5 assignment format

You are welcome to use some of the variables, but please avoid using duplicating this example set.  

Questions? Need More Help?

Contact your professor Dr. Newman at: [email protected]