Normal distributions

[Kristine]

I am having difficultly figuring out the process for
graphing and shading within the normal distribution curve
(bell curve). I am using excel for statistics and do have
the data analysis functions. Where can I get this
information.
Kristine

 

[Jerry W. Lewis]

The following links might be helpful

http://groups.google.com/groups?selm=uAeBJoh0BHA.1796@tkmsftngp02
http://www.tushar-mehta.com/excel/charts/normal_distribution/index.htm

Jerry

 

[G. Boyd Swartz]

This works, don't think I would want student to do it.

Let scores be normal with mean 100 and sd 10. Find area of scores
between 80 and 110.
In column A enter 70 to 132 in steps of 2
In column B enter normdist(a1,100,10,false)
Replicate down to 132
Select all B values and take chart wizard of type fill
Select b values from 70 to 110, copy, paste special on chart, new
series
Select b values from 70 to 80, copy, paste special on chart
Set colors in format data series to match the upper area.
Select chart and take source data, set category x values to column A
area =NORMDIST(110,100,10,TRUE)-NORMDIST(80,100,10,TRUE)
0.818594614
Select a cumulative area and move B column selection to new value

boyd