Statistics Forum - Statistics Help
 

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


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



Hi,

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

Thread Tools
Display Modes



All times are GMT -5. The time now is 04:13 PM.


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

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