Books  Data Analysis & Modelling  Data Analysis & Statistics 

R Through Excel: A Spreadsheet Interface for Statistics, Data Analysis, and Graphics

Handbook / Manual

Series: Use R!

By: Erich Neuwirth (Author), Richard M Heiberger (Author)

368 pages, 300 colour illustrations

Springer-Verlag

Paperback | Aug 2009 | #201658 | ISBN-13: 9781441900517
Availability: Usually dispatched within 1-2 weeks Details
NHBS Price: £49.99 $63/€59 approx

About this book

In R Through Excel, 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.

"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


Contents

- Getting started
- Using RExcel and R Commander
- Getting data into R
- Normal and t Distributions
- Normal and t workbook
- t-tests
- One-way ANOVA
- Simple linear regression
- What is least squares?- Multiple regression-Two X-variables
- Polynomial regression
- Multiple regression-Three or more X-variables
- Contingency tables and the Chi-Square test
- Appendix: Installation of RExcel


Write a review

There are currently no reviews for this product. Be the first to review this product!


Biography

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 forComputational Statistics and Journal of Statistical Software.

Bestsellers in this subject

Camera Trapping for Wildlife Research

NHBS Price: £34.99 $44/€41 approx

Choosing and Using Statistics

NHBS Price: £28.50 $36/€34 approx

Statistics for Ornithologists

NHBS Price: £11.90 $15/€14 approx

The R Book

NHBS Price: £65.50 $83/€78 approx

Statistics for Ecologists Using R and Excel

NHBS Price: £29.99 $38/€36 approx