Normal distributions

  • Thread starter Thread starter Kristine
  • Start date Start date
K

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
 
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
 
Back
Top