How to Make Normal Probability Plot in Excel

You will learn how to do mathematical calculations and how to insert a probability chart (to be exact, it is a normal distribution probability plot).

Probably, it is the Excel tutorial that solves your issue.

A normal probability plot, also known as a Q-Q plot, is a graphical tool used to assess whether a set of data is approximately normally distributed. In Excel, you can create a normal probability plot using the following steps:

Data preparation

First, you need data that looks like this:

data set of probability

Select the Home tab.

ribbon home

Click on a value in the data, and Sort & filter to choose Sort from smallest to largest.

sort smallest to largest

Start another column, with one in between, and label it “i”.

label iteration list

Start another column, and label it formula.

formula column

Click on D2, and type =(C2-0,375)/(6+0,25).

type formula

Double-click on the small square in the right bottom corner of the cell.

double click

Label Column B as the Expected Z.

last column expected

NORM.S.INV formula

Click on B2, and type =NORM.S.INV(D2).

norm.s.inv function

Double-click on the small square shown in the result from the previous step.

double click formula

Inserting a normal distribution plot

Highlight A2-B8, click on insert, scatter chart, and choose the desired chart to plot the normal distribution chart.

insert prob chart

The Probability Chart is ready:

Probability chart example

Note: You may need to make adjustments to the standard normal values based on the mean and standard deviation of your data. You can do this by using the formula =(A2-MEAN(A:A))/STDEV(A:A), where A2 is the first data point in the sorted data set, and MEAN and STDEV are the functions in Excel that calculate the mean and standard deviation, respectively.

See also  How to Make a Chart for Large Data Set

You can download a free Probability chart template here