How to Create a Bell Curve chart for Performance Rating Distribution

  Рет қаралды 70,230

Caripros HR Analytics

Caripros HR Analytics

Күн бұрын

Пікірлер: 21
@mariananitasueable
@mariananitasueable Жыл бұрын
Great video how did you come up with the expected ratings?
@lindachall8372
@lindachall8372 9 ай бұрын
You are very kind to share, thank you.
@summer_be
@summer_be 10 ай бұрын
How to decide expexted percentage and how to calculate actual result based on your video.
@simonblunden2151
@simonblunden2151 Жыл бұрын
Excellent video!
@virginiamanyara2253
@virginiamanyara2253 4 жыл бұрын
Very easy to follow and helpful! Thank you!
@CariprosHRAnalytics
@CariprosHRAnalytics 4 жыл бұрын
You're very welcome!
@antonioespinoza62
@antonioespinoza62 4 жыл бұрын
How would you do quartiles?
@jamalcheema1573
@jamalcheema1573 4 жыл бұрын
Very Helpful. Thank you
@johnlackey9063
@johnlackey9063 3 жыл бұрын
I need to know how did you create the list, outstanding excellent and so on basically setting up the info for the chart
@CariprosHRAnalytics
@CariprosHRAnalytics 3 жыл бұрын
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
@1000000trs 9 ай бұрын
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
@TheSpsdub
@TheSpsdub Жыл бұрын
Thanks !
@shannon8035
@shannon8035 3 жыл бұрын
THANK YOU SO MUCH OMGGGG!!!!
@WenzyGO
@WenzyGO 3 жыл бұрын
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
@CariprosHRAnalytics 3 жыл бұрын
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.
@BattusWorld
@BattusWorld Жыл бұрын
the scatter option is not helping me create a bell like curve
@sujitdipta
@sujitdipta 4 жыл бұрын
can u make a video on normalization of score in performance apprisal
@pinar.z
@pinar.z Жыл бұрын
how to insert the chart?
@IamIsuru
@IamIsuru Жыл бұрын
Thanks
@atulpunjani
@atulpunjani 4 жыл бұрын
SPOILER ALERT: If we add up 9+10+75+4+1=99% not 100% which you have mentioned in the Actual performance
@CariprosHRAnalytics
@CariprosHRAnalytics 4 жыл бұрын
There are roundings. The unrounded numbers shall add up to 100%
How to Create a Merit Matrix for Salary Increase with Goal Seek Function
20:06
Caripros HR Analytics
Рет қаралды 48 М.
The Normal Distribution and the 68-95-99.7 Rule (5.2)
8:50
Simple Learning Pro
Рет қаралды 1,5 МЛН
Sigma Kid Mistake #funny #sigma
00:17
CRAZY GREAPA
Рет қаралды 30 МЛН
Что-что Мурсдей говорит? 💭 #симбочка #симба #мурсдей
00:19
Гениальное изобретение из обычного стаканчика!
00:31
Лютая физика | Олимпиадная физика
Рет қаралды 4,8 МЛН
How Strong Is Tape?
00:24
Stokes Twins
Рет қаралды 96 МЛН
How to Create a Bell Curve in Excel
10:33
ExcelDemy
Рет қаралды 28 М.
How to Plot a Normal Distribution (Bell Curve) in Excel - with Shading!
6:55
Excel for HR: Salary Structure Floating Bar Chart with Employee Data
5:54
Caripros HR Analytics
Рет қаралды 64 М.
The Normal Distribution, Clearly Explained!!!
5:13
StatQuest with Josh Starmer
Рет қаралды 1,5 МЛН
🚨 YOU'RE VISUALIZING YOUR DATA WRONG. And Here's Why...
17:11
Adam Finer - Learn BI Online
Рет қаралды 272 М.
How to Remember Everything You Read
26:12
Justin Sung
Рет қаралды 2,3 МЛН
How We’re Fooled By Statistics
7:38
Veritasium
Рет қаралды 3,6 МЛН
7 Outside The Box Puzzles
12:16
MindYourDecisions
Рет қаралды 107 М.
Sigma Kid Mistake #funny #sigma
00:17
CRAZY GREAPA
Рет қаралды 30 МЛН