Save 50% on Print Books, eBooks & Journals in Medicine! Browse now >>

Use R!

R Through Excel

A Spreadsheet Interface for Statistics, Data Analysis, and Graphics

Authors: Heiberger, Richard M., Neuwirth, Erich

  • RExcel seamlessly integrates the entire set of R's statistical and graphical methods into Excel
  • R's statistical procedures are available from an Excel menu
  • Excel scroll bars and check boxes can create and animate R graphics
  • RExcel examples cover the topics of the introductory course
  • RExcel examples illustrate use by professional statisticians
  • Data can be transferred between R and Excel by selecting worksheet ranges
  • All R functions can be executed directly from within Excel worksheet formulas (including automatic recalculation when data change)
see more benefits

Buy this book

eBook $49.99
price for USA
  • ISBN 978-1-4419-0052-4
  • Digitally watermarked, DRM-free
  • Included format: PDF
  • ebooks can be used on all reading devices
  • Immediate eBook download after purchase
Softcover $64.95
price for USA
  • ISBN 978-1-4419-0051-7
  • Free shipping for individuals worldwide
  • This title is currently reprinting. You can pre-order your copy now.
About this Textbook

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.

Reviews

From the reviews:

“The book R Through Excel …offers a good entry for those just beginning with R through the familiar Microsoft Excel. …Will help those using Microsoft Excel on computers in MS Windows environments become more familiar with two programs designed to work with R. …All of the functions and many of the topics discussed… can be applied for independent R installations on Linux, Unix, or Apple computers. R is an intimidating but powerful program that assumes an intimate knowledge of data formats and terminology not familiar to many language testers. R Through Excel is a highly recommended first step into that program.” (Shiken: JALT Testing& Evaluation SIG Newsletter )

“Students, researchers, and others who wish to use R … . This book is essentially a manual for the RExcel software. … Most commonly a page consists of one or more screenshots showing how to use RExcel. The whole book is reproduced in color, on glossy paper. … Readers are guided through the menu system … to see how to carry out common statistical procedures. … For anyone wishing to learn RExcel this book would be a useful purchase.” (David J. Scott, International Statistical Review, Vol. 78 (2), 2010)

“R Through Excel offers a concise introduction to statistical analysis for those with little prior experience in statistical software. The text provides a nontechnical introduction to the R programming language and the presentation is helpful for those who are averse to syntax commands. … an excellent manual to have on the shelf for anyone that is interested in integrating R and Excel. … For those in academia who teach introductory statistics and want to use R, this text provides a gentle manner for doing so.” (Philip Okoth, The American Statistician, Vol. 65 (4), November, 2011)

“I was very impressed by the layout of the book. Each of the main chapters is clear and uncluttered, with extensive use of colour screenshots to illustrate what the reader should see when using RExcel. … Overall, I think this is an excellent resource for someone wishing to learn how to use this software, particularly if they prefer to do so with the comforting old-fashioned feel of a book.” (David Fletcher, Australian & New Zealand Journal of Statistics, Vol. 53 (4), 2011)


Table of contents (13 chapters)

  • Getting Started

    Heiberger, Richard M. (et al.)

    Pages 1-11

  • Using RExcel and R Commander

    Heiberger, Richard M. (et al.)

    Pages 13-36

  • Getting Data into R

    Heiberger, Richard M. (et al.)

    Pages 37-60

  • Normal and t Distributions

    Heiberger, Richard M. (et al.)

    Pages 61-80

  • Normal and t Workbook

    Heiberger, Richard M. (et al.)

    Pages 81-103

Buy this book

eBook $49.99
price for USA
  • ISBN 978-1-4419-0052-4
  • Digitally watermarked, DRM-free
  • Included format: PDF
  • ebooks can be used on all reading devices
  • Immediate eBook download after purchase
Softcover $64.95
price for USA
  • ISBN 978-1-4419-0051-7
  • Free shipping for individuals worldwide
  • This title is currently reprinting. You can pre-order your copy now.
Loading...

Recommended for you

Loading...

Bibliographic Information

Bibliographic Information
Book Title
R Through Excel
Book Subtitle
A Spreadsheet Interface for Statistics, Data Analysis, and Graphics
Authors
Series Title
Use R!
Copyright
2009
Publisher
Springer-Verlag New York
Copyright Holder
Springer-Verlag New York
eBook ISBN
978-1-4419-0052-4
DOI
10.1007/978-1-4419-0052-4
Softcover ISBN
978-1-4419-0051-7
Series ISSN
2197-5736
Edition Number
1
Number of Pages
XXIV, 344
Number of Illustrations and Tables
300 illustrations in colour
Topics