# More bell curve questions

#### thespacecowboy

##### New Member
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
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
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!!

Replies
1
Views
293
Replies
3
Views
991
Replies
1
Views
451
Replies
3
Views
91
Replies
34
Views
924

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.

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.

### Which adblocker are you using?

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

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