How to Make a Normal Distribution Curve in Excel 2007

Written by stephanie ellen
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Make a Normal Distribution Curve in Excel 2007
Use Excel to calculate the normal distribution curve from a data set. (John Foxx/Stockbyte/Getty Images)

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:


  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

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.