Saturday, June 22, 2013

How to Make a Normal Distribution Curve in Excel 2007

1. Open a new worksheet in Excel.
2. Fill in your x-values in column 1, starting at cell A1. For example, if you want your x-values to be from -10 to 10, write '-10' in cell A1, '-9.5' in cell A2, and '-9' in cell A3, all without quotes. Continue down the column until you have entered all of your values through to cell A41.
3. Enter '=NORMDIST(A1,0,1,0)' without quotes into cell B2. This formula is for the standard normal distribution, with a mean of 0 and a standard deviation of 1. You can enter any mean or standard deviation into this formula. For example, if you want a mean of 10 and a standard deviation of 2, enter '=NORMDIST(A1,10,2,0)' without quotes .
4. Highlight the two columns by left clicking on cell A1 and dragging your cursor down to cell B41.
5. Choose 'Insert | Scatter| Scatter with Smooth Lines and Markers.'

Blogger news