Wednesday, April 3, 2013

Plot Quantile comparision plot in Excel using RExcel

See the related posts on RExcel (for basic, Excel 2003 and Excel 2007) for basic information.

Sometime we are need to plot a single Qunatile coparision plots. RExcel implemented with Excel can do it easily. Please refer to previous posts about RExcle installation to data loading. Here we are trying to plot a single variable say V2.

(1) Start RExcel and load data. Now under graphics menu select Quantile-Comparision (QQ) plot, Now you have to select the variable you want to plot. You also need to choose type of distribution you want to compare to, default is normal distribution.

Click OK. Now you can see cool QQ comparision plot. If you click identify observation with mouse, then you can identify the observation (may be deviated) with your click (See A9 and A10, I clicked).

No comments:

Post a Comment