How to chart a bell curve with x, mean, standard deviation, cumula

K

kujhac

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.
 
M

Mike Middleton

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top