# 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

***Content***

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 https://goo.gl/WejijZ 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: https://www.paypal.me/caripros

******More Videos in Playlists******

Excel for HR https://goo.gl/JdeVnd

Excel for HR – Master Class https://goo.gl/LYfq2f

Excel Macro – Beginner https://goo.gl/Yae5nc

Excel Macro/VBA – Splitting a Master File https://goo.gl/m8CHya

Excel Charts Data Visualization https://goo.gl/2ao6BP

Excel Vlookup Function https://goo.gl/kP2Wpz

Excel Pivot Table Function https://goo.gl/rukkPs

Excel Array Function https://goo.gl/i4sQH8

Excel Index and Match Function https://goo.gl/i7VGU4

Excel Solver/Goal Seek Functions https://goo.gl/FTkTnj

Excel Cell Formatting Solutions https://goo.gl/gpa6MY

HR Analytics – Merit Matrix https://goo.gl/Koy7co

HR Analytics – Salary Structure https://goo.gl/uZBnFa

Excel Tricks https://goo.gl/TeqGDw

Excel Troubleshooting https://goo.gl/bdY5by

Fun HR Topics https://goo.gl/7zVg8h

For more successful stories, view at: http://caripros.com/index.php/success-stories/

******Tools I use for this channel******

Channel management: https://www.tubebuddy.com/HRAnalytics

“I Love Spreadsheets” Mug: https://amzn.to/2D0bYmL

source

### 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