Computational Statistics

, Volume 22, Issue 1, pp 91–108

Excel :: COM :: \(\mathsf{R}\)

Original Paper

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.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. ActiveState Tool Corporation (2000) Active Perl, 5.6.0.618 edn, ActiveState Tool Corporation. http://www.ActiveState.com/ActivePerl/Google Scholar
  2. Baier T (2005) rcom: R COM Client Interface and internal COM Server. R package version 1.2.1.Google Scholar
  3. Baier T, Neuwirth E (2005) R (D)COM Server V2.00. http://www.cran.r-project.org/other/DCOMGoogle Scholar
  4. 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/Google Scholar
  5. Cluts N (2001) Microsoft activex controls overview, in ‘MSDN Library’, Vol. Backgrounders, Microsoft Corporation. http://www.msdn.microsoft.com/Google Scholar
  6. DuBois P (2000) MySQL. New RidersGoogle Scholar
  7. Eaton JW (2005) Octave: interactive language for numerical computations. University of Wisconsin, Department of Chemical Engineering. http://www.octave.org/doc/index.htmlGoogle Scholar
  8. Flanagan D (2001) JavaScript: the definitive guide, 4th edn. O’Reilly Media, Inc. ISBN 0596000480Google Scholar
  9. 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/Google Scholar
  10. Free Software Foundation (1991) GNU GENERAL PUBLIC LICENSE. Version 2Google Scholar
  11. Free Software Foundation (1999) GNU LESSER GENERAL PUBLIC LICENSE. Version 2.1Google Scholar
  12. Hornik K (2005) The R FAQ. ISBN 3-900051-08-9. http://www.CRAN.R-project.org/doc/FAQ/Google Scholar
  13. Insightful Corporation (2005) S-PLUS 7’. http://www.insightful.com/products/splus/Google Scholar
  14. James D, DebRoy S (2005) RMySQLGoogle Scholar
  15. 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/bugsGoogle Scholar
  16. 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/bugsGoogle Scholar
  17. 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/RSXMLGoogle Scholar
  18. Lapsley M, Ripley BD (2005) RODBC: ODBC database access. R package version 1.1-4Google Scholar
  19. Martelli A (2003) Python in a Nutshell. O’Reilly Media, Inc. ISBN 0596001886Google Scholar
  20. McCullough BD, Wilson B (2002). On the accuracy of statistical procedures in Microsoft Excel 2000 and Excel XP. Comput Stat Data Anal 40:713–721MATHCrossRefMathSciNetGoogle Scholar
  21. 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 1874416672Google Scholar
  22. Microsoft Corporation (2001a) Common language runtime. In: ‘MSDN Library’, vol. .NET Framework SDK, Microsoft Corporation. http://www.msdn.microsoft.com/Google Scholar
  23. 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/Google Scholar
  24. Microsoft Corporation (2001c) Visual basic. In: ‘MSDN Library’, vol. Visual Studio 6.0 Documentation, Microsoft Corporation. http://msdn.microsoft.com/Google Scholar
  25. Microsoft Corporation & Digital Equipment Corporation (1995) The component object model specification, Technical Report 0.9, Microsoft Corporation (Draft)Google Scholar
  26. Mono Project (2006) The Mono Project. http://www.mono-project.com/Google Scholar
  27. 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=6799Google Scholar
  28. 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=1Google Scholar
  29. Object Management Group I (2002) Common object request broker architecture: Core specification, Technical report, Object Management Group, Inc. 3.0Google Scholar
  30. OpenOffice.org (2006) OpenOffice. http://www.openoffice.org/Google Scholar
  31. 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-10Google Scholar
  32. R Development Core Team (2005a) An introduction to R, R Foundation for statistical computing, Vienna ISBN 3-900051-12-7Google Scholar
  33. 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.orgGoogle Scholar
  34. R Development Core Team (2005c) R Data Import/Export, R foundation for statistical computing, Vienna, ISBN 3-900051-10-0Google Scholar
  35. R Development Core Team (2005d) R installation and administration, R foundation for statistical computing. Vienna, ISBN 3-900051-09-7Google Scholar
  36. R Development Core Team (2005e) R language definition, R foundation for statistical computing. Vienna, ISBN 3-900051-13-5Google Scholar
  37. R Development Core Team (2005f) Writing R extensions, R foundation for statistical computing. Vienna, ISBN 3-900051-11-9Google Scholar
  38. Stallman RM (2005) Using and porting GCC, 2.95 edn. Free Software Foundation. http://gcc.gnu.org/Google Scholar
  39. Wall L, Christiansen T, Schwartz R (1996) Programming perl. O’Reilly & Associates. ISBN 1-56592-149-6Google Scholar

Copyright information

© Springer-Verlag 2007

Authors and Affiliations

  1. 1.Department of StatisticsVienna University of TechnologyViennaAustria
  2. 2.Department of Scientific ComputingUniversity of ViennaViennaAustria

Personalised recommendations