MBA 6350 – Week 6 – Case Study #4
Single and Multiple Regression Analysis
(Version 8-20-2020)
The data file “MBA6350 Week 6 – Case Study 4-WAGE-FILE-ver8-20-2020.xlsx”
contains 50 rows of data that represent data for 50 employees of a large
manufacturing plant. The data includes each worker’s hourly rate (Hourly Rate $),
Years of Higher Education (“Higher Ed Yrs”), Years of Work Experience (“Experience
Yrs”), and their Age in years (“Age”).
Your job is to perform an analysis of this data and develop regression models that can
help to analyze and estimate the Hourly Rate based on these variables.
Watch the Videos in the Case Study Assignment Module in Canvas which
demonstrate how to use the Data Analysis Toolpak to perform Single Regression
Analysis and Multiple Regression Analysis of variables. Make sure you understand the
