HELP! how do i draw a normal curve in excel?

A

alphaone

I am working on this problem. Since I am a horrible artist, I need to
be able to draw a generic normal curve in Excel. To clarify the
problem, here is an example:

The birth weight of full-term babies is known to be normally
distributed with mean = 3400 grams and standard deviation = 505 grams
based upon data obtained from the National Vital Statistics Report,
Vol.48, No.3.
(a)Draw a normal curve with parameters labeled.
(b)Shade the region that represents the proportion of full-term babies
who weighed more than 4410 grams.

Again, this is just an example of what I want to do. To summarize, I
want to draw a generic normal curve in Excel using only the
information stated in the example problem (i.e. mean and standard
deviation.) I also want to be able to label the parameters and shade
the specified region on the graph for which I am calculating the
probability. And just so I am clear, I do not have any of the orignal
data. I only have the mean, standard deviation, and the specified
interval that needs to be shaded (i.e. X >= 4410.) If anyone can help
me, it would be much appreciated.
 
A

Alex Delamain

Try using =Normdist(x,mean,standard_dev,cumulative)

This will return the normal distribution. Apply it to a range of X
values and bingo you've got a normal curve
 

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