bell-shape normal distribution curve

[SM]

I know a rough bell-shaped curve can be drawn in Excel using random numbers.
Can normal distribution curves showing an area under the curve, i.e z-test or
t-test area, be drawn in Excel? If yes, how?

Thanks

 

[Barb Reinhardt]

If you know what you want for your X and Y coordinates, you can use this
tutorial

http://www.peltiertech.com/Excel/Charts/XYAreaChart.html

 

[SM]

Thanks for the suggestion.

I need to have 2 values ONLY shown on the x-axis, the value of the mean and
the z-value (or equivalent). Is this possible?

 

[Barb Reinhardt]

I've never tried that, but I'm sure it's possible. Let's assume your
primary X axis values are Z scores from say -6 to +6 and you want to include
the Mean.

You'll need another series of data with

X Y Label (Mean)
-6 0 Mean for Z=-6
-5 0 Mean for Z=-5
and so on.

Plot the X and Y axis labels on the chart. These will eventually be made
invisible so don't worry about the color.

You can use Rob Bovey's XY Chart Labeler to put a secondary label on those
points. It's found at www.appspro.com

http://www.peltiertech.com/Excel/Charts/DummySeries.html

May help you as well.

 

[Barb Reinhardt]

You could also contatenate the Mean and Z value and use the chart labeler to
add those at the appropriate location.

 

[SM]

Many thanks for all the suggestions. will try them.