Normal distribution

[John Smith]

I have some numbers between 0 and 100 that I want to fit to a normal curve.

I want the resulting curve to give me numbers that are still between 0 and
100.

I would appreciate some ideas on how to do this in Excel 2003.

I see the normdist function, but have no idea how to use it.
thank you

 

[Harlan Grove]

I have some numbers between 0 and 100 that I want to fit to a normal curve.

Use the mean (AVERAGE) and standard deviation (STDEV) of your sample data as
parameters to NORMDIST.

I want the resulting curve to give me numbers that are still between 0 and
100.

...

That's up to you. Fill another range with 0 to 100 in steps of 1, and use
NORMDIST as above to generate the cumulative distribution values for each value
between 0 and 100.

I see the normdist function, but have no idea how to use it.
thank you

Then buy a stats textbook and learn how. Few things are more dangerous that
trying to learn stats from Excel newsgroup responses.

 

[Dana DeLouis]

Don't know if this will help...

XL: How to Create a Bell Curve Chart
http://support.microsoft.com/default.aspx?scid=kb;en-us;213930&Product=xlw

Dana DeLouis