Overview
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.
Full Product Details
Author: Richard M. Heiberger ,
Erich Neuwirth
Publisher: Springer-Verlag New York Inc.
Imprint: Springer-Verlag New York Inc.
Edition: 2009 ed.
Dimensions:
Width: 15.50cm
, Height: 1.50cm
, Length: 23.50cm
Weight: 0.663kg
ISBN: 9781441900517
ISBN 10: 1441900519
Pages: 344
Publication Date: 05 August 2009
Audience:
College/higher education
,
Postgraduate, Research & Scholarly
Format: Paperback
Publisher's Status: Active
Availability: In Print
This item will be ordered in for you from one of our suppliers. Upon receipt, we will promptly dispatch it out to you. For in store availability, please contact us.
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 )
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)
