Excel for statistics topic list > Standard Normal Distribution Excel 2007

Watch the video or read the steps below:

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

*Facebook page*and I'll do my best to help!

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?

How can I apply my normal distribution graph with this distribution set

mean =300

sigma=50

minimum =65

maximum = 2400

number=1000

Great tools and insightful explanation. Worked perfectly well. Many thanks.