-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Charting - Bell Curve
- Thread starter Hayesk
- Start date
Jeffrey Chin
Board Regular
- Joined
- Aug 10, 2002
- Messages
- 87
Hi Hayesk
I plotted a normal dist curve on some data points myself. This is what I did:
1. group the data points into buckets, eg. age 10-15, age 16-20, etc.. count the no. of data points in each bucket.
2. calculate the mean using AVERAGE() and std dev using STDEV().
3. calculate the norm dist of each bucket using NORMDIST()..
4. i will setup a table with columns for age bucket, no. of data points for the corresponding age bucket, and NORMDIST(age, mean, stdev, FALSE).
5. then i will plot using these 3 columns..
you can see whether your data sample fits a norm dist curve..
cheers
jeffrey
I plotted a normal dist curve on some data points myself. This is what I did:
1. group the data points into buckets, eg. age 10-15, age 16-20, etc.. count the no. of data points in each bucket.
2. calculate the mean using AVERAGE() and std dev using STDEV().
3. calculate the norm dist of each bucket using NORMDIST()..
4. i will setup a table with columns for age bucket, no. of data points for the corresponding age bucket, and NORMDIST(age, mean, stdev, FALSE).
5. then i will plot using these 3 columns..
you can see whether your data sample fits a norm dist curve..
cheers
jeffrey
Upvote
0
