Coding / Programming Videos

Post your favorite coding videos and share them with others!

Design Salary Structure with Regression Analysis [Part 2 of 3]

Download Video link >

Design Salary Structure with Regression Analysis [Part 2 of 3]

Topic: Excel Function – Design Salary Structure with Regression Analysis (Simplified Version)
Function: Regression Analysis, Combo Chart
Business Scenario: You need to create a salary structure with Regression Modelling

Part 1
Overview – Design Key Steps:
1 Prepare market benchmark job salary data by job grade
2 Create regression model from benchmark job data
3 Use regression line to anchor salary structure mid-point
4 Use assumed band width and level progression % to develop the full structure
5 Make adjustment until satisfied

Part 2
Demonstration – How to create regression line and graphs step by step

Part 3
Discussion – Adjustment can be applied based on the following consideration:
1 Market data adjustment, survey selection, job selection, percentile selection, etc.
2 Band width
3 Level progression
4 Regression model selection
5 Actual employee salary spread
6 Compa ratio
7 Market competitiveness
8 Legislative requirement
9 Budget
10 Business/Strategy considerations

******Follow-up Consulting Services******
If you have specific question regarding your issue, you can email me at the email here Note that there will be a fee of US$50 charged for solving your issue. The turnaround is within 24 hours. Any follow-up issue in 3 days will also be answered with no charge. Payment link:

******More Videos in Playlists******
Excel for HR
Excel for HR – Master Class
Excel Macro – Beginner
Excel Macro/VBA – Splitting a Master File
Excel Charts Data Visualization
Excel Vlookup Function
Excel Pivot Table Function
Excel Array Function
Excel Index and Match Function
Excel Solver/Goal Seek Functions
Excel Cell Formatting Solutions
HR Analytics – Merit Matrix
HR Analytics – Salary Structure
Excel Tricks
Excel Troubleshooting
Fun HR Topics

For more successful stories, view at:

******Tools I use for this channel******
Channel management:
“I Love Spreadsheets” Mug:




View Comments source >

Transcript view all >

00:01 hello everyone today is part 2 for the

00:05 design salary structure with regression

00:08 analysis widows so as I promised I would

00:11 give you a live demonstration of how I

00:14 created the salad structures step by

Leave a Reply

Please Login to comment
Notify of
Translate »