11
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.
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.
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
From India, Mumbai
We intend to introduce some HR plicies use during annual increments /
promotion of our emploies.
In view of that we want to share the HR policies which are being implemented
in automobile / dealership sectors.
From India, Kanpur
promotion of our emploies.
In view of that we want to share the HR policies which are being implemented
in automobile / dealership sectors.
From India, Kanpur
Hi Smriti !
Please check with the person who had given you this excel sheet. This is a classic example of misunderstaning the concepts and using them erroneously. What you call bell curve is actually "Normal Probability Curve" (since it is bell shape it is called bell curve).
Normal Probability Curve (NPC) is an ideal distribution plot of any measurable chararacteristic that is supposed to be normally distributed in the larger population. For example; if you measure 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 misuse of NPC to project it as ideal in small samples that are conceptaully "not normally distributed" e.g. if you plot the IQ of IITians it would never be similar to NPC as IITians are supposed to (are actully are) be on the higher side.
This is a misconception that general big NPC is composed of sevel small NPCs. The graph here is a complele misrepresentation of the applicability of the concept.
Regards,
Vijai Pandey
Central Test: Leader in online psychometric testing
From India, Hyderabad
Please check with the person who had given you this excel sheet. This is a classic example of misunderstaning the concepts and using them erroneously. What you call bell curve is actually "Normal Probability Curve" (since it is bell shape it is called bell curve).
Normal Probability Curve (NPC) is an ideal distribution plot of any measurable chararacteristic that is supposed to be normally distributed in the larger population. For example; if you measure 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 misuse of NPC to project it as ideal in small samples that are conceptaully "not normally distributed" e.g. if you plot the IQ of IITians it would never be similar to NPC as IITians are supposed to (are actully are) be on the higher side.
This is a misconception that general big NPC is composed of sevel small NPCs. The graph here is a complele misrepresentation of the applicability of the concept.
Regards,
Vijai Pandey
Central Test: Leader in online psychometric testing
From India, Hyderabad
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
From India, Pune
Hi Smriti,
The excel attachment really helps. I've been trying to find a simple excel sheet to help me with bell curve analysis for quite some time now & this one's just the key.
Thanks a ton!
From India, Mumbai
The excel attachment really helps. I've been trying to find a simple excel sheet to help me with bell curve analysis for quite some time now & this one's just the key.
Thanks a ton!
From India, Mumbai
Dear smriti ,
Can you please help me in describing the fields, as I am doing the appraisal first time
Ratings
Recommended
Ideal Curve
My rating scale is
91≈100
81≈90
71≈80
61≈70
<60
Whether I had to put the above rating in Rating or in Recommended
How you had put the % in Ideal bell curve
From Saudi Arabia
Can you please help me in describing the fields, as I am doing the appraisal first time
Ratings
Recommended
Ideal Curve
My rating scale is
91≈100
81≈90
71≈80
61≈70
<60
Whether I had to put the above rating in Rating or in Recommended
How you had put the % in Ideal bell curve
From Saudi Arabia
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
Create bell curve in XL.doc
Bell Curve.xls