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:
Easy

Other People Are Reading

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

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

No articles available

No slideshows available

No videos available

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