can any one tell me how to make the normal distribution curve once the appraisals are done.....For example, if we have 5-point rating and the data is as follows:
1 15
2 20
3 145
4 30
5 10
how do we make a normal distribution curve..If anyone has an experience or knowledge of making the curve, kindly help me...
waiting for ur reply,
Regards,
Nirali Desai
From India, Mumbai
61 15
2 20
3 145
4 30
5 10
how do we make a normal distribution curve..If anyone has an experience or knowledge of making the curve, kindly help me...
waiting for ur reply,
Regards,
Nirali Desai
From India, Mumbai
Hey Nirali,
Normal Distribution curves can be made in MS- Excel.
I am giving an example of normal curve department wise.
First of all, u must be having the ideal numbers for all ratings.
For eg.
In most of the orgn, the ideal percentages are:
Rating 5(Excellent) - 10%
Rating 4 (V Good) - 35%
Rating 3 (Good) - 45%
Rating 2 (Average)- 7 %
Rating 1 (Below Average) - 3%
that means, if in any particular deaprtment there toatal 100 people, then
Rating Desired numbers actual numbers
5 10 15
4 35 42
3 45 38
2 7 3
1 3 2
now u can draw a normal curve by selecting this data in excel sheet illustrating the gap between desired and actual curve.
Graphs can be made easily in excel :
insert --> chart --> Line Chart ---> choose third option amongst the choice of chart.
I hope this info would help you.
in case u still feel any difficulty. we can talk on this further through this thread.
Here is an attachment for your reference.
Regards
Ritu07
From India, Meerut
Normal Distribution curves can be made in MS- Excel.
I am giving an example of normal curve department wise.
First of all, u must be having the ideal numbers for all ratings.
For eg.
In most of the orgn, the ideal percentages are:
Rating 5(Excellent) - 10%
Rating 4 (V Good) - 35%
Rating 3 (Good) - 45%
Rating 2 (Average)- 7 %
Rating 1 (Below Average) - 3%
that means, if in any particular deaprtment there toatal 100 people, then
Rating Desired numbers actual numbers
5 10 15
4 35 42
3 45 38
2 7 3
1 3 2
now u can draw a normal curve by selecting this data in excel sheet illustrating the gap between desired and actual curve.
Graphs can be made easily in excel :
insert --> chart --> Line Chart ---> choose third option amongst the choice of chart.
I hope this info would help you.
in case u still feel any difficulty. we can talk on this further through this thread.
Here is an attachment for your reference.
Regards
Ritu07
From India, Meerut
hi ritu,
Thnx a lot 4 ur help
but the graph in the attachment is a line graph and not a curve
there is some scientific method for drawing the curve
where u have to calculate the mean or standard deviation
I wanted to know how the curve can be drawn using this method
if u kno about this pls do reply
how is it done in organisations?
thanx 1ce again,
regards,
Nirali Desai
From India, Mumbai
Thnx a lot 4 ur help
but the graph in the attachment is a line graph and not a curve
there is some scientific method for drawing the curve
where u have to calculate the mean or standard deviation
I wanted to know how the curve can be drawn using this method
if u kno about this pls do reply
how is it done in organisations?
thanx 1ce again,
regards,
Nirali Desai
From India, Mumbai
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