bell-shape normal distribution curve
 

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

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

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

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

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

"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

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

Many thanks for all the suggestions. will try them.



"Barb Reinhardt" wrote:

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

"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