RExcel
RExcel | |
---|---|
Basic data
|
|
Maintainer | Erich Neuwirth |
developer | Erich Neuwirth |
Current version | RExcel 3.2.9 (January 1, 2013) |
programming language | R , Microsoft Excel |
rcom.univie.ac.at |
RExcel is an add-in for Microsoft Excel , with the help of which the statistical software R can be used within Excel.
installation
There are several variants for installing RExcel. Probably the most comfortable way is to use the RAndFriends Installer, which also installs the current version of R and configures the RCOM server.
Functions
RExcel is an add-in for Microsoft Excel. After the installation, the menu bar for RExcel with the most important functions can be found in Excel.
- Start R: starts R
- Run Code: R code can be executed in R directly from Excel
- Get R Value: Data (parameters, matrix, data frame) can be imported from R into Excel
- Put R Value: Set variables in R with data from Excel
- Set R working dir: change R's working directory
- Set R Server: Settings for the R server, e.g. B. whether it should run in the foreground or in the background
- Demo worksheets: Examples of the functions of RExcel with explanations
literature
- Thomas Baier, Erich Neuwirth, Michele De Meo: Creating and Deploying an Application with (R) Excel and R . In: R Journal 3 (2), 2011, pp. 5-11, doi : 10.32614 / RJ-2011-011 .
- Erich Neuwirth, Deane Arganbright: The Active Modeler: Mathematical Modeling with Microsoft Excel . Thomson, Brooks / Cole, Belmont 2004, ISBN 0-534-42085-0 .
- Erich Neuwirth, Richard M. Heiberger: R Through Excel: A Spreadsheet Interface for Statistics, Data Analysis, and Graphics . Springer, New York City 2009, ISBN 978-1-4419-0051-7 , doi : 10.1007 / 978-1-4419-0052-4 .
- Rainer Muche, Stefanie Lanzinger, Michael Rau: Medical statistics with R and Excel . Springer, Berlin & Heidelberg 2011, ISBN 978-3-642-19483-2 , doi : 10.1007 / 978-3-642-19484-9 .