Regression Part 3
Introduction
Lecture by Tamar Kugler, Associate Professor of Management and Organizations at the University of Arizona Eller MBA.
Regression Analysis Overview
Regression analysis helps to establish relationships between various variables.
Focus is given to predicting salary based on different independent factors using regression models.
Regression #2: Salary Predicted from Performance Evaluation Rating
Scatter Plot: Illustrates the relationship between rating (x-axis) and salary (y-axis).
Rating scale: 2 to 9 (no data for a rating of 1).
Displays a positive trend indicating a relationship.
R-Square Value: R^2 = 0.71
Represents that 71% of the variance in salary can be explained by the rating.
Compared to previous findings (minority status R-square = 0.086).
Indicates a strong predictive capability of ratings on salary.
Adjusted R-Square: Almost unchanged due to a favorable ratio of observations (n = 140) to predictors (one predictor).
Regression Equation:
\text{Predicted Salary} = 636 + 151 \times \text{Rating}
Interpretation of intercept (636): This value represents an average score for a theoretical rating of 0, which doesn’t exist in this model.
Slope Interpretation: For each unit increase in rating, salary increases by 151.
Statistical Significance:
T-statistic = 18.5, suggesting it's significantly greater than zero.
P-value = 2.28 \times 10^{-39}, effectively zero.
Conclusion: There is a significant relationship, and the effect of rating on salary is statistically proven.
Regression #3: Salary Predicted from Age
Scatter Plot: Indicates no significant relationship between age and salary, displaying a flat regression line.
R-Square Value: R^2 = 0.009
Less than 1% of salary variance can be attributed to age.
Coefficient Interpretation:
Coefficient for age: 7.2; suggests an increase of 7 in salary for each additional year of age.
Statistical Significance: P-value = 0.26, indicating a lack of significance (greater than alpha level of 0.05).
Conclusion: No significant relationship found between age and salary.
Regression #4: Salary Predicted from Gender
Scatter Plot: Illustrates minimal spread around two gender categories (0 for women, 1 for men).
Regression line remains flat, indicating no relationship.
R-Square Value: Very close to zero.
Coefficient Interpretation:
Coefficient for gender: approximately 11, suggesting men earn 11 more than women on average.
Statistical Significance: P-value = 0.88; therefore, can be treated as zero.
Conclusion: There is no significant evidence that gender impacts salary in this organization.
Regression #5: Salary Predicted from Tenure
Scatter Plot: Positive relationship observed between tenure (in years) and rating, upward trending regression line.
R-Square Value: R^2 = 0.73
This indicates that 73% of the variance in rating can be explained by tenure.
Regression Equation:
\text{Predicted Rating} = 0.86 + 1.78 \times \text{Tenure}
Interpretation: Each additional year of tenure increases the rating by approximately 1.78 points, which is significant as ratings range from 1 to 9.
Statistical Significance:
P-value = 1.98 \times 10^{-41}, which is significantly lower than alpha.
Conclusion: We reject the null hypothesis and conclude tenure significantly impacts rating.
Summary of Findings
Significant effects are observed:
Minority status affecting salary.
Rating score significantly predicts salary.
Tenure positively correlates with ratings.
No significant effect observed from age or gender on salary.
Need for further analysis to control for confounding factors affecting salary, including performance evaluation ratings and tenure.
Upcoming discussion will include extending the regression model to include multiple predictors simultaneously for a more comprehensive analysis.