BUS 308 Week 5 Assignment
Problem Set Week Five.
1. Create a correlation table for the variables in our Employee Salary Data Set. (Use analysis ToolPak or StatPlus:mac LE function Correlation.) Interpret the results.
a. What variables seem to be important in seeing if we pay males and females equally for equal work?
2. Below is a regression analysis for salary being predicted/explained by the other variables in our sample (Mid, age, ees, sr, raise, and deg variables.)
Note: since salary and compa are different ways of expressing an employee’s salary, we do not want to have both used in the same regression.
3. Perform a regression analysis using compa as the dependent variable and the same independent variables as used in question 2. Show the result, and interpret your findings by answering the same questions.
Note: be sure to include the appropriate hypothesis statements