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