Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating Bell Shape
Hi,
I have the following test scores: 10 11 12 13 14 15 16 17 18 19 20 21 22 and its frequency: 0 1 3 4 4 5 6 5 4 4 3 1 0 Can anyone help me on how to create a normal distribution curve? Khaledity |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating Bell Shape
First of all, you can simply do a bar chart using the results and the
frequency that approximately looks like bell shaped. But obviously it is not perfectly bell shaped because it is not perfectly normal distribution. But what you see is the actual shape of your data. However, if you would like to draw an envelope on the top of the bars that looks like a perfectly normal distribution then what you should do is to use the equation of the normal distribution and use the mean (16) and standard deviation (2.582) from your data to generate the values for each of the results values. If you plotted this new series on the same graph as a line and turned on the option of smoothed line then you will see a perfectly normal distribution on the top of your real data. Let me know if you need me to email the file to you. Regards, - AG |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating bell curve in excel | Charts and Charting in Excel | |||
Creating a bell curve chart | Charts and Charting in Excel | |||
How do I create and/or edit a bell shape graph? | Charts and Charting in Excel | |||
Bell Shape Graphs | Excel Discussion (Misc queries) | |||
bell-shape normal distribution curve | Charts and Charting in Excel |