Statistics Forum - Statistics Help

Go Back   Statistics Forum - Statistics Help > Statistics Help > Statistics Homework

Thread Tools Display Modes
Old 07-07-2009, 12:31 PM   #1
Posts: n/a
Normal quantile plot in Excel


How do I get a normal quantile plot in Excel? Thanks.
  Reply With Quote
Old 07-07-2009, 12:35 PM   #2
Posts: n/a
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.
  Reply With Quote

Thread Tools
Display Modes

All times are GMT -5. The time now is 07:10 PM.

Sponsored Links
Talk Stats - Stat123 - Standard Normal Table - Chi Square Table - Statistics Blog

Powered by vBulletin® Version 3.8.3
Copyright ©2000 - 2015, Jelsoft Enterprises Ltd.
Copyright 2008-2013,