Trying to chart a bell curve in Excel to help my wife with a statistics
course required for a BSN in nursing.

Here is the problem:

Using excel, the values would be x=5.5, mean=1.88, standard deviation=1.20,
cum.=true. The answer is 0.9987 which equals 99.87%.

Now I need to know how to graph it. I have the formula
=NORMDIST(B2,$F$1,$H$1,TRUE) using X in B2, the mean in F1 and the standard
deviation in H1. I need step by step instructions. Thanks ahead of time for
any help.

kujhac -

(1) If you do a web search for "Excel normal curve" or "excel bell curve"
(without the quote marks) via Google or bing, you get numerous hits.

(2) I have an Excel worksheet you could download from
http://www.mikemiddleton.com/ShadedNormalDensity.xls
On the "left tail" worksheet of that workbook, enter mean 1.88, stdev 1.20,
and left tail max 5.5. Then format the x-axis for min = -4 and max = 8.

(3) If you need more assistance, be sure to mention which version of Excel
you're using.

- Mike
http://www.MikeMiddleton.com



"kujhac" <(E-Mail Removed)> wrote in message
news:2A12E7FE-2BE2-4BA3-8443-(E-Mail Removed)...
> Trying to chart a bell curve in Excel to help my wife with a statistics
> course required for a BSN in nursing.
>
> Here is the problem:
>
> Using excel, the values would be x=5.5, mean=1.88, standard
> deviation=1.20,
> cum.=true. The answer is 0.9987 which equals 99.87%.
>
> Now I need to know how to graph it. I have the formula
> =NORMDIST(B2,$F$1,$H$1,TRUE) using X in B2, the mean in F1 and the
> standard
> deviation in H1. I need step by step instructions. Thanks ahead of time
> for
> any help.