How to Create a Bell Curve chart for Performance Rating Distribution

Want to learn how to design a salary structure? Check: www.caripros.c...
FREE template for my video: Excel for HR - Create Annual Employee Salary Increase Template from Scratch. You can download and try it out yourself here: bit.ly/2MLLdb7
FREE actual workbook for my video "Split a Master Spreadsheet into Multiple Sheets with 1 click - VBA for Beginner". You can download and try it out yourself here: bit.ly/2UmeX2v
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:
caripros-hr-an... How to Create a Bell Curve chart for Performance Rating Distribution. Compare the actual Performance Rating Distribution with the expected Performance Rating Distribution.
For more successful stories, view at: caripros.com/in...
*****Follow-up Consulting Services*****
If you have specific question regarding your issue, you can email me at the email here goo.gl/WejijZ Note that there will be a fee of US$200 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: www.paypal.me/...
*****More Videos in Playlists*****
Power BI for Beginners: bit.ly/3ivKitD
Power BI for Advanced Users: bit.ly/3lE9zmO
Excel for HR goo.gl/JdeVnd
Excel for HR - Master Class goo.gl/LYfq2f
Excel Macro - Beginner goo.gl/Yae5nc
Excel Macro/VBA - Splitting a Master File goo.gl/m8CHya
Excel Macro/VBA - Auto-hide Rows or Columns bit.ly/2Mzteb5
Excel Charts Data Visualization goo.gl/2ao6BP
Excel Vlookup Function goo.gl/kP2Wpz
Excel Pivot Table Function goo.gl/rukkPs
Excel Array Function goo.gl/i4sQH8
Excel Index and Match Function goo.gl/i7VGU4
Excel Solver/Goal Seek Functions goo.gl/FTkTnj
Excel Cell Formatting Solutions goo.gl/gpa6MY
HR Analytics - Merit Matrix goo.gl/Koy7co
HR Analytics - Salary Structure goo.gl/uZBnFa
Excel Tricks goo.gl/TeqGDw
Excel Troubleshooting goo.gl/bdY5by
Fun HR Topics goo.gl/7zVg8h
For more successful stories, view at: caripros.com/in...
#ExcelforHR#HRAnalytics#Excel#HR

[@mariananitasueable]

Great video how did you come up with the expected ratings?

[@lindachall8372]

You are very kind to share, thank you.

[@simonblunden2151]

Excellent video!

[@summer_be]

How to decide expexted percentage and how to calculate actual result based on your video.

[@virginiamanyara2253]

Very easy to follow and helpful! Thank you!

[@CariprosHRAnalytics]

You're very welcome!

[@TheSpsdub]

Thanks !

[@IamIsuru]

Thanks

[@BattusWorld]

the scatter option is not helping me create a bell like curve

[@jamalcheema1573]

Very Helpful. Thank you

[@shannon8035]

THANK YOU SO MUCH OMGGGG!!!!

[@sujitdipta]

can u make a video on normalization of score in performance apprisal

[@antonioespinoza62]

How would you do quartiles?

[@WenzyGO]

Great job! Thank you. However why would the management decide to change the actual flow of appraisals to make their bell curve look like the expected? Please respond because that will help me as i am about to create bell curve for our appraisal reports

[@CariprosHRAnalytics]

Well there could be many reasons, one reason is the affordability. We cannot pay everyone the same high performance rewards. Management can choose to pay all employees average rewards with smaller performance differentiation, or they can choose to pay only selected employees high rewards (and the rest low rewards) with high performance differentiation. It's a compensation philosophy question in terms of where you want to allocate your limited resources. Another reason is that managers tend to avoid making tough decisions/give low ratings, so the above average performer will almost always be greater than 50% if you don't have some kind of enforcement in place.

[@johnlackey9063]

I need to know how did you create the list, outstanding excellent and so on basically setting up the info for the chart

[@CariprosHRAnalytics]

Hi John, that has to do with Performance Management which is different for every organization. I may create future video about it as it's a different and complicated topic

[@1000000trs]

she didn't understand the question. I have the same question. Basically she's shown us how to do the easy part, create a chart, but skipped over the tricky part

[@pinar.z]

how to insert the chart?

[@atulpunjani]

SPOILER ALERT: If we add up 9+10+75+4+1=99% not 100% which you have mentioned in the Actual performance

[@CariprosHRAnalytics]

There are roundings. The unrounded numbers shall add up to 100%