Normal Distribution curves

[JohnAcc]

Hi There,

Does anybody know how to show normal distribution curves in excel graphs?

The one that looks like a hill !

Thanx for any help in advance!

Rgds, John

 

[dyarwood]

After you have drawn a chart the best way would be to add a trend line. If you want something like the normal distribution use polynomial with period 4. Think that should work

dyarwood

 

[JohnAcc]

Hi There,

Thanx for the quick response but it didn't work. I just want 1 hill!

Rgds, John

 

[dyarwood]

Use degree 2

this will give you just one hill but will not give the tails.

 

[combo]

Choose xy graph and use formula for y:
=NORMDIST(x,E_value,STD_value,FALSE)
(false for not cumulative)

combo