How to Make Normal Distribution in Excel?

Enter your data in a column

Calculate the mean with `=AVERAGE(range)`

Calculate the standard deviation with `=STDEV.S(range)`

Create a list of x-values for the distribution

Use `=NORM.DIST(x, mean, standard_dev, FALSE)` to get the normal distribution values

Fill the formula down for all x-values

Create a chart using the x-values and distribution values

Insert a Scatter chart with smooth lines or a Line chart

Format the chart as needed

Suggested for You

Trending Today