# How to Make a Normal Distribution Curve in Excel 2007

Written by stephanie ellen
• Share
• Tweet
• Share
• Pin
• Email

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.

Skill level:
Easy

## Instructions

1. 1

Open a new worksheet in Excel.

2. 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. 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. 4

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

5. 5

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

#### Tips and warnings

• 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.

### Don't Miss

#### References

• All types
• Articles
• Slideshows
• Videos
##### Sort:
• Most relevant
• Most popular
• Most recent