Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
SM
 
Posts: n/a
Default 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
  #2   Report Post  
Barb Reinhardt
 
Posts: n/a
Default

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



  #3   Report Post  
SM
 
Posts: n/a
Default

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




  #4   Report Post  
Barb Reinhardt
 
Posts: n/a
Default

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






  #5   Report Post  
Barb Reinhardt
 
Posts: n/a
Default

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








  #6   Report Post  
R.VENKATARAMAN
 
Posts: n/a
Default

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









  #7   Report Post  
SM
 
Posts: n/a
Default

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






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"