Abstract
\(\mathsf{R}\) is a powerful system for statistical computing. Its great flexibility makes it the perfect tool for a wide range of applications. Unfortunately this flexibility also leads to a level of complexity which is hard to handle for the casual user. On the other hand tools like Microsoft Excel are very easy to handle but are not well-suited for more complex applications. This article describes how to make use of the flexibility of \(\mathsf{R}\) while still providing a familiar and easy to use GUI in Microsoft Excel. We will provide a description of the design and show the various ways of installation and user interaction with \(\mathsf{R}\) using Excel.
This is a preview of subscription content, log in via an institution to check access.
Similar content being viewed by others
References
ActiveState Tool Corporation (2000) Active Perl, 5.6.0.618 edn, ActiveState Tool Corporation. http://www.ActiveState.com/ActivePerl/
Baier T (2005) rcom: R COM Client Interface and internal COM Server. R package version 1.2.1.
Baier T, Neuwirth E (2005) R (D)COM Server V2.00. http://www.cran.r-project.org/other/DCOM
Chambers JM (1998) Programming with Data, Springer, New York. ISBN 0-387-98503-4 http://www.cm.bell-labs.com/cm/ms/departments/sia/Sbook/
Cluts N (2001) Microsoft activex controls overview, in ‘MSDN Library’, Vol. Backgrounders, Microsoft Corporation. http://www.msdn.microsoft.com/
DuBois P (2000) MySQL. New Riders
Eaton JW (2005) Octave: interactive language for numerical computations. University of Wisconsin, Department of Chemical Engineering. http://www.octave.org/doc/index.html
Flanagan D (2001) JavaScript: the definitive guide, 4th edn. O’Reilly Media, Inc. ISBN 0596000480
Fox J with contributions from Michael Ash, Grosjean P, Maechler M, Putler D, Wolf P (2005) Rcmdr: R Commander. R package version 1.1-1 http://www.r-project.org, http://www.socserv.socsci. mcmaster.ca/jfox/Misc/Rcmdr/
Free Software Foundation (1991) GNU GENERAL PUBLIC LICENSE. Version 2
Free Software Foundation (1999) GNU LESSER GENERAL PUBLIC LICENSE. Version 2.1
Hornik K (2005) The R FAQ. ISBN 3-900051-08-9. http://www.CRAN.R-project.org/doc/FAQ/
Insightful Corporation (2005) S-PLUS 7’. http://www.insightful.com/products/splus/
James D, DebRoy S (2005) RMySQL
Lang DT (2005a) RDCOMClient: R-DCOM client. R package version 0.91-0. http://www.omegahat.org/RDCOMClient, http://www.omegahat.org, http://www.omegahat.org/bugs
Lang DT (2005b) RDCOMServer: R-DCOM object server. R package version 0.6-0. http://www.omegahat.org/RDCOMServer, http://www.omegahat.org, http://www.omegahat.org/bugs
Lang DT (2005c) XML: Tools for parsing and generating XML within R and S-Plus. R package version 0.99-1. http://www.omegahat.org/RSXML
Lapsley M, Ripley BD (2005) RODBC: ODBC database access. R package version 1.1-4
Martelli A (2003) Python in a Nutshell. O’Reilly Media, Inc. ISBN 0596001886
McCullough BD, Wilson B (2002). On the accuracy of statistical procedures in Microsoft Excel 2000 and Excel XP. Comput Stat Data Anal 40:713–721
McNab E, Swart RE, Hinks P, Horn D, Jansen A, Jewell D, Wako W, Winning C (1996) The Revolutionary Guide to Delphi 2. Peer Information Inc. ISBN 1874416672
Microsoft Corporation (2001a) Common language runtime. In: ‘MSDN Library’, vol. .NET Framework SDK, Microsoft Corporation. http://www.msdn.microsoft.com/
Microsoft Corporation (2001b) Microsoft office 2000/visual basic programmer’s guide. In: ‘MSDN Library’, vol. Office 2000 Documentation, Microsoft Corporation. http://www.msdn. microsoft.com/
Microsoft Corporation (2001c) Visual basic. In: ‘MSDN Library’, vol. Visual Studio 6.0 Documentation, Microsoft Corporation. http://msdn.microsoft.com/
Microsoft Corporation & Digital Equipment Corporation (1995) The component object model specification, Technical Report 0.9, Microsoft Corporation (Draft)
Mono Project (2006) The Mono Project. http://www.mono-project.com/
Nardi BA (1993) A Small Matter of Programming. MIT Press, Boston. ISBN 0-262-14053-5 http://mitpress.mit.edu/catalog/item/default.asp?ttype=2&tid=6799
Neuwirth E, Arganbright D (2003) Mathematical Modeling with Microsoft Excel, Thomson-Brooks/Cole. ISBN 0-534-42085-0. http://www.brookscole.com/cgi-wadsworth/ course_products_wp.pl ?fid=M2b&product_isbn_issn=0534420850&discipline_number=1
Object Management Group I (2002) Common object request broker architecture: Core specification, Technical report, Object Management Group, Inc. 3.0
OpenOffice.org (2006) OpenOffice. http://www.openoffice.org/
R-core members, DebRoy S, Bivand R, others: see COPYRIGHTS file in the sources (2005) foreign: Read Data Stored by Minitab, S, SAS, SPSS, Stata, Systat, dBase. R package version 0.8-10
R Development Core Team (2005a) An introduction to R, R Foundation for statistical computing, Vienna ISBN 3-900051-12-7
R Development Core Team (2005b) R: a language and environment for statistical computing, R Foundation for Statistical Computing. Vienna. ISBN 3-900051-07-0 http://www.R-project.org
R Development Core Team (2005c) R Data Import/Export, R foundation for statistical computing, Vienna, ISBN 3-900051-10-0
R Development Core Team (2005d) R installation and administration, R foundation for statistical computing. Vienna, ISBN 3-900051-09-7
R Development Core Team (2005e) R language definition, R foundation for statistical computing. Vienna, ISBN 3-900051-13-5
R Development Core Team (2005f) Writing R extensions, R foundation for statistical computing. Vienna, ISBN 3-900051-11-9
Stallman RM (2005) Using and porting GCC, 2.95 edn. Free Software Foundation. http://gcc.gnu.org/
Wall L, Christiansen T, Schwartz R (1996) Programming perl. O’Reilly & Associates. ISBN 1-56592-149-6
Author information
Authors and Affiliations
Corresponding author
Rights and permissions
About this article
Cite this article
Baier, T., Neuwirth, E. Excel :: COM :: \(\mathsf{R}\) . Computational Statistics 22, 91–108 (2007). https://doi.org/10.1007/s00180-007-0023-6
Accepted:
Published:
Issue Date:
DOI: https://doi.org/10.1007/s00180-007-0023-6