R Through Excel

A Spreadsheet Interface for Statistics, Data Analysis, and Graphics

  • Richard M. Heiberger
  • Erich Neuwirth
Part of the Use R book series (USE R)

Table of contents

  1. Front Matter
    Pages i-xxii
  2. Richard M. Heiberger, Erich Neuwirth
    Pages 1-11
  3. Richard M. Heiberger, Erich Neuwirth
    Pages 13-36
  4. Richard M. Heiberger, Erich Neuwirth
    Pages 37-60
  5. Richard M. Heiberger, Erich Neuwirth
    Pages 61-80
  6. Richard M. Heiberger, Erich Neuwirth
    Pages 81-103
  7. Richard M. Heiberger, Erich Neuwirth
    Pages 105-163
  8. Richard M. Heiberger, Erich Neuwirth
    Pages 165-191
  9. Richard M. Heiberger, Erich Neuwirth
    Pages 193-212
  10. Richard M. Heiberger, Erich Neuwirth
    Pages 213-233
  11. Richard M. Heiberger, Erich Neuwirth
    Pages 235-267
  12. Richard M. Heiberger, Erich Neuwirth
    Pages 269-284
  13. Richard M. Heiberger, Erich Neuwirth
    Pages 285-307
  14. Richard M. Heiberger, Erich Neuwirth
    Pages 309-322
  15. Back Matter
    Pages 1-18

About this book

Introduction

R, a free and open source program, is one of the most powerful and the fastest-growing statistics program. Microsoft Excel is the most widely used spreadsheet program, but many statisticians consider its statistical tools too limited.

In this book, the authors build on RExcel, a free add-in for Excel that can be downloaded from the R distribution network. RExcel seamlessly integrates the entire set of R's statistical and graphical methods into Excel, allowing students to focus on statistical methods and concepts and minimizing the distraction of learning a new programming language.

Data can be transferred between R and Excel "the Excel way" by selecting worksheet ranges and using Excel menus. R's basic statistical functions and selected advanced methods are available from an Excel menu. Results of the computations and statistical graphics can be returned back into Excel worksheet ranges. RExcel allows the use of Excel scroll bars and check boxes to create and animate R graphics as an interactive analysis tool.

The book is designed as a computational supplement to introductory statistics texts and the authors provide RExcel examples covering the topics of the introductory course.

Richard M. Heiberger is Professor of Statistics at Temple University. He participated in the design of the S-Plus and R linear model and analysis of variance functions while on research leave at Bell Labs. He is the author of and contributor to various R packages. He is an Elected Fellow of the American Statistical Association (ASA) and the Chair Elect of the ASA Section on Statistical Computing.

Erich Neuwirth is Professor of Computer Science at the University of Vienna and was formerly Professor of Statistics. He is the author of RExcel, and author of and contributor to various R packages. He is coauthor of Mathematical Modeling with Excel, winner of the European Academic Software Award 1996 (for a project combining mathematics and music), and Associate Editor for Computational Statistics and Journal of Statistical Software.

Keywords

ANOVA Analysis Excel Open Source STATISTICA data analysis linear regression programming programming language spreadsheet spreadsheet program statistics

Authors and affiliations

  • Richard M. Heiberger
    • 1
  • Erich Neuwirth
    • 2
  1. 1.Dept. StatisticsTemple UniversityPhiladelphiaU.S.A.
  2. 2.Fakultät für InformatikUniversität WienWienAustria

Bibliographic information

  • DOI https://doi.org/10.1007/978-1-4419-0052-4
  • Copyright Information Springer Science+Business Media, LLC 2009
  • Publisher Name Springer, New York, NY
  • eBook Packages Mathematics and Statistics
  • Print ISBN 978-1-4419-0051-7
  • Online ISBN 978-1-4419-0052-4
  • About this book