This project demonstrates how to build a Linear Regression Model to predict employee salaries using IBM SPSS Modeler (or similar tools). The dataset contains details of 474 employees.
- From Sources palette, drag a
Var. File
node to a blank canvas. - Edit the node, locate and select
employee_data.txt
. - Click OK to confirm.
- From Output palette, connect a
Table
node to theVar. File
node. - Run the node to preview data.
- ➤ Dataset contains 474 employees.
- Connect a
Data Audit
node to the same source. - Run it to inspect value distributions, types, and missing data.
- Add a
Type
node from Field Ops, connected to theVar. File
node. - Click Read Values.
- Set
educational_level
→ Ordinal - Set fields from
gender
tomonths_previous_experience
→ Input - Set
current_salary
→ Target
- Add a
Linear
node from the Modeling palette connected to theType
node.
- Go to Build Options tab:
- Under Basics: Uncheck
Automatically prepare data
. - Under Model Selection: Choose
Include all predictors
.
- Under Basics: Uncheck
- Click Run to build the model.
- Edit the model nugget and click Model Summary.
- Click Predictor Importance
job_category
→ Most important predictorgender
→ Second most importantregion
andage
→ Least important
- Click Predicted by Observed
- ➤ Predicted values show two major clusters rather than a smooth trend.
- Click Coefficients by Observed
- From the Style dropdown, select
Table
.
You now have a working linear regression model that:
- Uses job role, education, experience, and other features
- Identifies job category and gender as major salary predictors
- Can be used to further explore wage inequality or HR planning