Normal quantile plot in Excel

[mattc]

Hi,

How do I get a normal quantile plot in Excel? Thanks.

[vicki]

Here's how to create a normal quantile plot in Excel:

Put the data into the first column. Sort the data in ascending order.

Rank the data in the second column as Rank.

The third column shows the rank proportion of each data value. Use this equation for the first data value =(b2 - 0.5) / count(b$2:b$N) where N is the row number of the last cell. Finish the column by copy and pasting the first data expression to the remaining rows.

The fourth column as Rank-based z-scores. Use the normsinv function in Excel.

Copy the first column to the fifth column. Plot the fourth column vs the fifth column. Now you have the normal quantile plot.