Are you nervous about using regression analysis for rewards work? Watch Excel expert Dianne Auld demonstrate how Excel can help you with three different types of regression analysis:
- Using linear regression to predict executive pay
- Using multilinear regression to predict executive pay and test for pay discrimination
- Using exponential regression to create a base pay policy line and pay scales using market and internal pay data
Dianne will explain how to use and interpret the slope, intercept and R-squared (R2) values created by the regression formulas. In addition, you’ll learn how to create a scatter chart, combined with traditional rectangular pay scales, and market and internal median pay lines, using the regressed data. This is a challenging but effective chart, and you must use a specific process to create it.
What You Will Learn:
- How to conduct linear and exponential regression in Excel using scatter charts and trend lines to predict pay, create a base pay policy line and create pay scales
- How to conduct multilinear regression using the add-in regression analysis tool in Excel to predict executive pay
- How to conduct multilinear regression using the add-in regression analysis tool in Excel to test for gender pay discrimination
- How to use and interpret the slope, intercept and R-squared (R2) values generated by the regression formulas
- How to create scatter charts with rectangular pay scales, and market and internal median lines overlaid on the chart.
After the session, you’ll get the Excel spreadsheets used in the demonstration and instructions for replicating the functionality with your own data.