How to Draw a Normal Distribution in Excel

••• ijeab/iStock/GettyImages

A normal distribution is a distribution of a continuous variable. Continuous variables include height, weight and income, and anything that is measured on a continuous scale. The normal distribution is the "bell-shaped" curve; many variables are distributed approximately normally, including many physical traits such as height or weight, and also variables such as IQ. You can create a graph of a normal distribution in Excel.

    Enter column headings. In cell A1, put "multiplier"; in B1, put "X"; in C1, put "Mean"; in D1, put "Standard Deviation"; and in E1, put "Normal."

    Decide on the mean and standard deviation you want for your distribution. For example, IQ has a mean of 100 and a standard deviation of 15.

    Enter the mean and standard deviation. Put the mean in cell C2 and the standard deviation in cell D2. Copy these to cells C3 and D3.

    Enter multiplier. In cell A2 put -4, in cell A3 put =a2+.1.

    Enter the normal distribution. In cell E2 put =norm.dist(b2, c2, d2, FALSE). Copy this to cell E3.

    Copy the third row to rows 4 through 82.

    Highlight columns B and E.

    Make a chart. Click "Insert," "Scatter," "Scatter with smooth lines." This will create a normal distribution graph.

Related Articles

How to Solve by Simpson's Rule With Excel
How to Calculate Correlation Coefficient Between Two...
How to Calculate the Correlation Between Two Variables
How to Build a Model of a Human Cell
How to Create Matrices on a TI-89
How to Graph a Distribution for a T-Test
How to Find Zeros of Functions in Excel
How to Calculate Function From Ordered Pairs
How to Decrease Digits in Excel
How to Type a Mixed Fraction in a TI-83 Plus
What Happens to a Cell If It Does Not Copy DNA Chromosomes...
How to Make a Cell Model Styrofoam Ball
How to Create a Normal Distribution Graph in Excel
How to Convert mm Hg to in Hg
What Happens When Mitosis Goes Wrong and in Which Phase...
How to Make an Animal Cell Diagram
How to Do a Bell Curve on a TI
How to Solve Linear Programming in Excel
How to Use the TI-84 to Find the Area Under the Normal...
Components of Homeostasis

Dont Go!

We Have More Great Sciencing Articles!