How to evaluate and visualize an internal equity or pay compression issue?

New course Launched! I created it to show you step-by-step how to design a salary structure with regression analysis in Excel. Check out the detail here:

Topic: HR Topic - In this video we discussed how we define internal equity or pay compression issue and how I would go about to analyze my sample employee data and visualize in Excel to uncover the issue.

******Follow-up Consulting Services******

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

#ExcelforHR#HRAnalytics#Excel#HR

[shwetatiwary]

Could you please explain this with large data sets and how to incorporate performance rating in the chart'

[amiiiraj]

Your skills are great 👍 I am one of your subscriber for last 2 years.. please never stop sharing and uploading videos .. all videos are very helpful .. thankss🇮🇳

[lynnefranklin]

Really enjoyed your content. Hope you will be sharing more Compensation insight. Thank you!

[supa.scoopa]

Wow. Thank you so much, your videos are gold.

[ethanbednarek]

Amazing video. One question: When you made the scatter plot comparing tenure and salary, you mentioned that in a mathematical world you would see a 45 degree line. Is it safe to say that the 45 degree line is an industry benchmark or a goal to try a reach to? That question excludes performance.

[mukeshmohanty]

Very Nice, explanation on pay compression

[aosm]

Thanks for the video. A quick question, if I have a large set of data, how can I color the dots based on performance? Is there a quick way, or it should be done manually? :-)

[Kaths_bucket_list]

Thanks for sharing. Could you please tell me how to combine the rating into chart? I only manage the get the scatter chart with compo ratio and tenure 🙏🙏🙏

[alejbriceno]

Right on target! My sheets look very similar to yours. Ya!

[romaink]

Many thanks for your videos, they are super useful! 👍🏻👍🏻👍🏻