12
A bell curve is a plot of normal distribution of a given data set. The file which i have attached describes how you can create a chart of a bell curve in Microsoft Excel.
Acknowledge(0)
Amend(0)
Acknowledge(0)Amend(0)
hi Urvashi A bell curve is a plot of normal distribution of a given data set. The file which i have attached describes how you can create a chart of a bell curve in Microsoft Excel.
Acknowledge(0)Amend(0)
Acknowledge(0)Amend(0)
can anyone pls tell me how to go about using this bell curve .I am still not clear with the usage of this curve as increment/Appraisal?:(
From India, Mumbai
Acknowledge(0)Amend(0)
0
0
From India, Mumbai
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The Bell Curve is a performance appraisal method that assesses employees' performance relative to their peers. It helps in determining increments and promotions. (1 Acknowledge point)
0
0
We intend to introduce some HR policies for use during annual increments and promotions of our employees.
In view of that, we want to share the HR policies that are being implemented in the automobile and dealership sectors.
From India, Kanpur
Acknowledge(0)Amend(0)
0
0
In view of that, we want to share the HR policies that are being implemented in the automobile and dealership sectors.
From India, Kanpur
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-[response] (1 Acknowledge point)
0
0
Hi Smriti!
Please check with the person who had given you this Excel sheet. This is a classic example of misunderstanding the concepts and using them erroneously. What you call a bell curve is actually the "Normal Probability Curve" (since it is bell-shaped it is called a bell curve).
The Normal Probability Curve (NPC) is an ideal distribution plot of any measurable characteristic that is supposed to be normally distributed in the larger population. For example, if you measure the height of all people in the world, the distribution of the height will be close to the NPC (but it will never be exactly like that).
This is a misuse of NPC to project it as ideal in small samples that are conceptually "not normally distributed," e.g., if you plot the IQ of IITians, it would never be similar to the NPC as IITians are supposed to (and actually are) be on the higher side.
It is a misconception that the general big NPC is composed of several small NPCs. The graph here is a complete misrepresentation of the applicability of the concept.
Regards,
Vijai Pandey
Central Test: Leader in online psychometric testing
From India, Hyderabad
Acknowledge(0)Amend(0)
0
0
Please check with the person who had given you this Excel sheet. This is a classic example of misunderstanding the concepts and using them erroneously. What you call a bell curve is actually the "Normal Probability Curve" (since it is bell-shaped it is called a bell curve).
The Normal Probability Curve (NPC) is an ideal distribution plot of any measurable characteristic that is supposed to be normally distributed in the larger population. For example, if you measure the height of all people in the world, the distribution of the height will be close to the NPC (but it will never be exactly like that).
This is a misuse of NPC to project it as ideal in small samples that are conceptually "not normally distributed," e.g., if you plot the IQ of IITians, it would never be similar to the NPC as IITians are supposed to (and actually are) be on the higher side.
It is a misconception that the general big NPC is composed of several small NPCs. The graph here is a complete misrepresentation of the applicability of the concept.
Regards,
Vijai Pandey
Central Test: Leader in online psychometric testing
From India, Hyderabad
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The user's reply provides accurate information regarding the Normal Probability Curve (NPC) and its application in statistical analysis. Great job explaining the concept clearly. (1 Acknowledge point)
0
0
Hi Smriti seen your bell curve xls but could not opened it well keep putting knowledgable inputs for HR Professionals, if i can help you in any ways let me know. Poonam
From India, Pune
Acknowledge(0)Amend(0)
0
0
From India, Pune
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-[B]Response[/B]: Please ensure you review and resend the Excel file for the Bell curve. Your contributions are valued in the HR community. Thank you! (1 Acknowledge point)
0
0
Hi Smriti,
The Excel attachment really helps. I've been trying to find a simple Excel sheet to assist me with bell curve analysis for quite some time now, and this one's just what I needed.
Thanks a ton!
From India, Mumbai
Acknowledge(0)Amend(0)
The Excel attachment really helps. I've been trying to find a simple Excel sheet to assist me with bell curve analysis for quite some time now, and this one's just what I needed.
Thanks a ton!
From India, Mumbai
Acknowledge(0)Amend(0)
Dear Smriti,
Can you please help me in describing the fields, as I am doing the appraisal for the first time?
- Ratings
- Recommended
- Ideal Curve
My rating scale is:
- 91-100
- 81-90
- 71-80
- 61-70
- <60
Should I put the above ratings in the "Rating" or "Recommended" category? How should I represent the percentages in the Ideal bell curve?
Thank you for your assistance.
From Saudi Arabia
Acknowledge(0)Amend(0)
0
0
Can you please help me in describing the fields, as I am doing the appraisal for the first time?
- Ratings
- Recommended
- Ideal Curve
My rating scale is:
- 91-100
- 81-90
- 71-80
- 61-70
- <60
Should I put the above ratings in the "Rating" or "Recommended" category? How should I represent the percentages in the Ideal bell curve?
Thank you for your assistance.
From Saudi Arabia
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The ratings should be put in the "Rating" field. The "Recommended" field is for the suggested rating, while "Rating" is for the actual score given. The % in the Ideal Bell Curve should represent the distribution of ratings across the curve. (1 Acknowledge point)
0
0
Looking for something specific? - Join & Be Part Of Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
CiteHR.AI
(Fact Checked)-[The user reply is correct and provides a clear explanation of a bell curve as a plot of normal distribution and how to create it in Microsoft Excel. Well done!] (1 Acknowledge point)