there is a java programme
check this url

http://www.math.csusb.edu/faculty/st...tion/normal_di
stribution.html

here as you can see the assumption is mean is 0 and sd 1.0 (what the
statisticians called normalised variables)

now you write your own mean and standard deviation
and then if you want the probability between two values you enter x1 and x2
and click caluculate you gtet the area under and that is probility of
values between those two values.

I tried with mean as 95 and standardeviation as 12 and calculated probaility
between 85 and 100 it came to
0.45921.

try that url

Barb Reinhardt wrote in message
...
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/Cha...mmySeries.html

May help you as well.


"SM" wrote in message
...
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" wrote:

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

http://www.peltiertech.com/Excel/Cha...AreaChart.html

"SM" wrote in message
...
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