RExcel

October 13, 2009
By

(This article was first published on Gregor Gorjanc (gg), and kindly contributed to R-bloggers)

I am not a fan of MS Windows software. However, the reality is that majority of people use it and it is often easier for me to live with this than to convert the sorounding souls. Additionally I am find ing out lately that majority of my favourite open-source programs work on all major platforms: MS Windows, Mac, and UNIX/Linux. Then there is no problem for me to work on any of these systems. MS Excel tool is similarly very widely used by mases, but not really powerfull when it comes to data analysis. However, we must admit that it is jolly usefull for handling medium sized data and that majority of people perform analyses with Excel. For those that can not live without Excel and have some working knowledge of R I suggest to take a look at the RExcel and its demo video (28 min!). It seems to be very nicely integrated - Excel keeps tracks of all the dependencies, while R takes care of the computations. Of course you can do the same stuff in R, by reruning the script for each change, but the interactivity offered by the Excel has its own merit. Regarding the quality of graphics it is obvious that Excel plots can not match with R. But if you need some interactivity (imagine you would like to study the effect of a particular parameter on distribution density), then Excel plots are good enough.

To leave a comment for the author, please follow the link and comment on his blog: Gregor Gorjanc (gg).

R-bloggers.com offers daily e-mail updates about R news and tutorials on topics such as: visualization (ggplot2, Boxplots, maps, animation), programming (RStudio, Sweave, LaTeX, SQL, Eclipse, git, hadoop, Web Scraping) statistics (regression, PCA, time series, trading) and more...



If you got this far, why not subscribe for updates from the site? Choose your flavor: e-mail, twitter, RSS, or facebook...

Comments are closed.