Is there an easy way to chart a normal distriubtion curve??

Posted by GLITZ on January 06, 2001 10:02 PM

I already have the mean and standard deviation...

Anything that makes it particularlly easy?

Posted by Mark W. on January 08, 2001 9:43 AM

Use NORMDIST(). If cells A1:A7 contain {-3;-2;-1;0;1;2;3}
then the entry of a single array formula, {=NORMDIST(A1:A7,0,1,0)}
into cells B1:B7 will produce:

{0.00443184841193801
;0.053990966513188
;0.241970724519143
;0.398942280401433
;0.241970724519143
;0.053990966513188
;0.00443184841193801}

You can then chart cells A1:B7 as a column chart.