DISCOVER
×

How to Make a Normal Distribution Curve in Excel 2007

Updated February 21, 2017

A normal distribution curve is a statistical function that describes how data behaves around any given mean. Also known as a Gaussian distribution or bell curve, a normal distribution curve allows statisticians to analyse data and make predictions. Graphing a normal distribution curve is a frequent activity in any elementary statistics class. Microsoft's Excel 2007 can make this activity easy for you by providing you with dynamic graphing tools that can create professional-looking graphs from your data.

Open a new worksheet in Excel.

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.

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 .

Highlight the two columns by left clicking on cell A1 and dragging your cursor down to cell B41.

Choose "Insert | Scatter| Scatter with Smooth Lines and Markers."

Tip

The more x-values you put in, the more your normal distribution will look like a bell curve. For example, try increments of 0.1 instead of 0.5. Instead of manually entering all of your values, use Excel's fill tool to fill in cells. For example, to fill in the x-values, write "-10" in cell A1, "-9" in cell A2, highlight both cells and drag the fill tool to cell A41.

bibliography-icon icon for annotation tool Cite this Article

About the Author

Stephanie Ellen teaches mathematics and statistics at the university and college level. She coauthored a statistics textbook published by Houghton-Mifflin. She has been writing professionally since 2008. Ellen holds a Bachelor of Science in health science from State University New York, a master's degree in math education from Jacksonville University and a Master of Arts in creative writing from National University.