
07072009, 12:31 PM  #1 
Guest
Posts: n/a

Normal quantile plot in Excel
Hi,
How do I get a normal quantile plot in Excel? Thanks. 
07072009, 12:35 PM  #2 
Guest
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 Rankbased zscores. 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. 
Thread Tools  
Display Modes  
