Easy Excel and R
The EasyER add in (Windows only) allows all kinds of statistical and data analysis methods including graphics to be accessed in Excel directly from the worksheet. Functions can be defined that allow any Excel user to access results and charts generated from R code without having to leave the worksheet. Users with knowledge of R can build their own functions so can easily enable Excel users with custom analysis and charts.
News and articles
Version 1.2 of EasyER has now been released. The main change is the addition of a chart builder interface for interactively creating charts. The chart builder plugs into the popular ggplot2 package allowing ggplot2 charts in Excel. Some bugs have also been fixed to help when having multiple function panes open, installing R packages and Read more about EasyER Version 1.2[…]
In the last EasyER update (Version 1.1) the ability to use date time values was added. This makes it easier to deal with time series in Excel, allowing analysis and forecasting methods to be used. Time Series in Excel Excel doesn’t do time series and applying standard statistical methods to time series with strong seasonal Read more about EasyER, Time Series in Excel[…]
There are many applications and tools for working with Excel and R. R code can be run from Excel and R can be used to output result to Excel sheets. Typically all these tools require some knowledge of using the command line or code. Data and results need to be converted to one format or Read more about Excel and R[…]