Wednesday, April 3, 2013

Plotting continous distributions (Beta, Gamma, Chi-square, t etc) and discrete distributions (eg. Binomial) in Excel using REXCEL

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

In previous posts we discussed how to plot different distributions by creating bins and formulas where Y is function of X. But in RExcel it is just easy as click.

Go to continous distributions and then select the distribition you want to plot from the list, and then select submenu plot the distribution. You might need to provide parameter for that distribition, that is it ! click and you will see a curve in plot window.

Similarly other distributions:

In the similarway we can plot discrete distributions are listed under distributions -> discrete distributions. Select distribution you like to plot and select plot the distribution sub-menu.

In the above example we have 200 samples in Binomial distribution.
Look the shape of the distribution, is not it like normal curve. How about when we have 5000 sample.

No comments:

Post a Comment