bell-shape normal distribution curve

[Guest]

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

 

[Guest]

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.

 

[R.VENKATARAMAN]

there is a java programme
check this url

http://www.math.csusb.edu/faculty/stanton/m262/normal_distribution/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

 

[Guest]

Many thanks for all the suggestions. will try them.