Statistics How To

Normal Distribution Excel 2007: Graphing in Easy Steps

Excel for statistics topic list > Standard Normal Distribution Excel 2007

Watch the video or read the steps below:

Standard Normal Distribution Excel 2007

Standard normal distribution. Image credit: University of Virginia.

A standard normal is a normal distribution that has a mean, μ, of zero and a standard deviation, σ, of one.
The total area under a standard normal distribution curve is 100%, which means you can use it to find probabilities using a standard normal table, also called the z-table.

Graphing the Standard Normal Distribution Excel 2007

Random variables are sometimes in a type of distribution called a standard normal distribution. You might be familiar with the bell curve from school; grades in classes tend to follow the shape of a bell curve. Most students fall into the center of the curve; those are the C grades. Grades of F and A are smaller amounts of students at the tails of the bell. Graphing a standard normal distribution by hand can be time consuming and tedious. Tools that can help you with creating a bell curve include graphing calculators. However, Microsoft Excel is installed on nearly every PC. Check your program list: if you have Microsoft Office installed (including Microsoft Word 2007), chances are you also have Excel. Here’s how to graph a normal distribution in Excel in less than a minute. Press the play button to start.

Graphing the Standard Normal Distribution Excel 2007

The following presentation shows you how to graph the standard normal distribution in ten steps. Press on the green arrows to move forward, or back.

Tip: If you’re going to be using Excel for statistics, load the data analysis toolpak. Although you can perform a lot of statistical function with Excel, the Toolpak add-in gives you access to a lot more functions. For example, the Toolpak will help you find z-scores and t-scores without needing to remember which function is which.

Update: earlier versions of Excel (prior to 2013) have been known to be a bit buggy, so if you can, upgrade to Excel 2013. Known bugs include problems with f-scores. However, if you’re going to be doing basic stats, you’ll probably be fine.

------------------------------------------------------------------------------

If you prefer an online interactive environment to learn R and statistics, this free R Tutorial by Datacamp is a great way to get started. If you're are somewhat comfortable with R and are interested in going deeper into Statistics, try this Statistics with R track.

Comments are now closed for this post. Need help or want to post a correction? Please post a comment on our Facebook page and I'll do my best to help!
Normal Distribution Excel 2007: Graphing in Easy Steps was last modified: October 12th, 2017 by Stephanie

3 thoughts on “Normal Distribution Excel 2007: Graphing in Easy Steps

  1. Andre

    How can I apply my normal distribution graph with this distribution set (.1,1.5,63.8,30.7,3.4,.4) mean=16.6 stn dev=25.9
    and cummulative=94.5 (adding 63.8&30.7) in excel?

  2. morteza

    How can I apply my normal distribution graph with this distribution set
    mean =300
    sigma=50
    minimum =65
    maximum = 2400
    number=1000