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

  • Thread starter Thread starter alphaone
  • Start date Start date
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.
 
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
 
Back
Top