NORM.DIST / Gauss Distribution

[primamateria]

Hello Mr.Excel Board,
following question: I have 20 measurements between 0,76mm and 0,79mm. The average is 0,772 and the standard Deviation is 0,00853

Now I would like to plot the Gauss curve and to use the NORM.DIST Function for this 20 measurements. As a newbie, I'am a bit unsecure how to do this correctly.

Have I to do this manually or is there some way Excel can do this for me? I would really appreciate if someone could give me some advice, how to do this correctly.
Standard Deviation: Normal distribution - Wikipedia

 

[xenou]

I think you would want to convert your values to z-scores. Then you can just plot the points as a typical line or bar chart (for the x values you can just use a sequence from 1-20 and for the y values use the z-scores - they should be in order from lowest to highest).

Note that I don't see any particular need for the norm.dist function here. You could use that to create data for a normal distribution and graph it if you had no data, but in this case you have your actual measurements so it makes more sense to graph your actual data.

 

[AhoyNC]

Something like this? My 20 numbers are not going to be the same as yours, so a different mean and StDev from what you had.

Book1
	A	B	C	D	E
1	Measurements	P(x)		Average	0.7750
2	0.76	11.93898431		StDev	0.0094
3	0.7615	15.18305704
4	0.7625	17.57312502
5	0.7645	22.76025181
6	0.766	26.82891193
7	0.7675	30.83475074
8	0.768	32.11769146
9	0.7705	37.75281689
10	0.772	40.21803975
11	0.7735	41.77378444
12	0.775	42.30562631
13	0.7765	41.77378444
14	0.778	40.21803975
15	0.7795	37.75281689
16	0.782	32.11769146
17	0.783	29.51994916
18	0.784	26.82891193
19	0.7855	22.76025181
20	0.787	18.82619057
21	0.7885	15.18305704
22	0.79	11.93898431
Sheet1

Cell Formulas
Range	Formula
E1	E1	=AVERAGE(A2:A22)
E2	E2	=STDEV.S($A$2:$A$22)
B2:B22	B2	=NORM.DIST(A2,$E$1,$E$2,0)

 

[primamateria]

hey guys, thank you for your answers. I belive my Question was a bit unclear (sorry I'am no native speaker). I think I (there was help in another forum) already "solved" the problem. If there are any other ideas or issues you want to discuss just tell me. I attached the Excel sheet with the original measurements plus the gauss curve / figure.