Bell-curve

gldtkn77gary

New Member
Joined
Dec 9, 2003
Messages
3
Can anyone help me find the correct formula for creating a standard normal distribution chart to look like a bell-shaped curve?
 

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".
hi
heres a shorter one!

=NORMDIST(A2,AVERAGE($A$2:$A$30),STDEV($A$2:$A$30),0)

this formula assumes that the data you have is not a subset of another
larger data that has known average value and std deviation. the mean is taken from the data itself and so with the std deviation. my first post just shows the formula of the function normdist.
 
Upvote 0
I appreciate your response, however, I don't see the bell-shaped curve. Perhaps I'm doing it wrong. I plugged in the formula you gave me and got a squiggly line...but that's it. It doesn't look symetrical at all.
Back to the drawing board...
Gary
 
Upvote 0
hi!
try to sort your data so that you will achieve a bell shape graph.
one reason that you do not get the perfect bell is that
your data is randomize. perfect bell is only achieve on
infinite number of data that is the range is from -infinity to +infinity. your data is bounded and will just approach the bell
shape of the normal curve distribution.
Refer to some statistical books and site for further explanation of normal curve!
try this value bellow and you will see a bell shape and symetric
cause the values are not random but does not approach the x axis because of limited number of data entry.

try this page!
http://www.symynet.com/educational_...rces/Statistics/normal_distribution/intro.htm




ps.
to everyone in the board!
I just whant to ask if how to post a graph in this board to show the result
in graph of the above example!
thanks!
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,213
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top