More bell curve questions

thespacecowboy

New Member
Joined
Jan 9, 2004
Messages
8
I have a list of employee appraisal scores, ranging from 2-5. 3 Should be the norm (average) score.
I would like to plot these to show 1) normal distribution around 3 and 2) curve if possible.

I've looked through the posts on here and also some of the linked webpages, but cannot quite fathom it out!

I've pasted my sheet so far, can someone tell me where I'm going wrong!
Test deviation.xls
ABCDEF
1Sumofscore
2Score28Average3.38
32StdDeviation1.245
42NormDist0.382
52
62
72
82
92
102
11Score36
123
133
143
153
163
173
18Score43
194
204
214
22Score57
235
245
255
265
275
285
295
Sheet1 (3)
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

thespacecowboy

New Member
Joined
Jan 9, 2004
Messages
8
Yes I did thanks Andrew. It was all a little confusing for me though, I guess I should brush up on my maths a little!

I've understood the basics, but another reply on the board I trued to work through did unfortunately not advance my understanding.


Essentially I want to be able to plot the scores on a graph and show the distribution, which should give some kind of bell curve, although not a perfect one.

thanks
 

thespacecowboy

New Member
Joined
Jan 9, 2004
Messages
8
OK. I've worked through the example, and after some perseverance think I know where I'm going with this.
The enclosed is the example given on the webpage.
I have inputted the standad deviation and Mean from my list of values.
The graph given is a bell curve, but I'm not sure if the data in it is mine! if this makes sense!

I have a group of appraisal scores, such as 25 2's. 50 3's, 40 4's and 10 5's.

There are two things I want to do
1. Make sure the graph the below plots is actually mine
2. (additional). If we have 300 employees and I want a forced normal distribution, do I use standard percentages (i.e. 68% 1 deviation, 27% 2 deviations, 5% 3 deviations)?

This may be a bit mathematical, but hopefully someone can help!!
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,095
Messages
5,768,054
Members
425,451
Latest member
JohnBrooksBiddle

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top