R Through Excel: A Spreadsheet Interface for Statistics, Data Analysis, and Graphics 2009 Edition Contributor(s): Heiberger, Richard M. (Author), Neuwirth, Erich (Author) |
|||
ISBN: 1441900519 ISBN-13: 9781441900517 Publisher: Springer
Binding Type: Paperback - See All Available Formats & Editions Published: August 2009 Annotation: a [ R is one of the best and most powerful statistics programs currently available a [ Excel is the most prevalent software used for data storage, analysis, and interpretation a [ RExcel integrates a menu system, based on Rcmdr, that puts complete access to the full power of R onto the Excel menu bar The primary focus of the book is on the use of menu systems from the Excel menu bar into the capabilities provided by R. The presentation is designed as a computational supplement to introductory statistics texts. The authors provide RExcel examples for most topics in the introductory course. Data can be transferred from Excel to R and back. The clickable RExcel menu supplements the powerful R command language. Results from the analyses in R can be returned to the spreadsheet. Ordinary formulas in spreadsheet cells can use functions written in R. Discussions of the development, implementation, and applications of this technology are available at http: //rcom.univie.ac.at/. |
Additional Information |
BISAC Categories: - Computers | Desktop Applications - Spreadsheets - Computers | Mathematical & Statistical Software - Computers | Computer Graphics |
Dewey: 519.502 |
LCCN: 2009929743 |
Series: Use R! |
Physical Information: 0.6" H x 6.32" W x 9.1" L (1.42 lbs) 344 pages |
Features: Bibliography, Illustrated, Index, Table of Contents |
Descriptions, Reviews, Etc. |
Publisher Description: 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. |
Customer ReviewsSubmit your own review |
To tell a friend about this book, you must Sign In First! |