R Through Excel A Spreadsheet Interface for Statistics, Data Analysi
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 au
- PDF / 22,131,648 Bytes
- 356 Pages / 439.37 x 666.142 pts Page_size
- 155 Downloads / 509 Views
For other titles published in this series, go to http://www.springer.com/series/6991
Richard M. Heiberger · Erich Neuwirth
R Through Excel A Spreadsheet Interface for Statistics, Data Analysis, and Graphics
123
Richard M. Heiberger Department of Statistics Temple University Philadelphia PA 19122 USA [email protected]
Series Editors Robert Gentleman Program in Computational Biology Division of Public Health Sciences Fred Hutchinson Cancer Research Center 1100 Fairview Avenue N. M2-B876 Seattle, Washington 98109 USA
Erich Neuwirth University of Vienna Fakult¨at f¨ur Informatik Dr.-Karl-Lueger-Ring 1 A - 1010 Vienna Austria [email protected]
Kurt Hornik Wirtschaftsuniversit¨at Wien, Vienna Austria
Giovanni Parmigiani Johns Hopkins University Baltimore, MD USA
ISBN 978-1-4419-0051-7 e-ISBN 978-1-4419-0052-4 DOI 10.1007/978-1-4419-0052-4 Springer Dordrecht Heidelberg London New York Library of Congress Control Number: 2009929743 c Springer Science+Business Media, LLC 2009 All rights reserved. This work may not be translated or copied in whole or in part without the written permission of the publisher (Springer Science+Business Media, LLC, 233 Spring Street, New York, NY 10013, USA), except for brief excerpts in connection with reviews or scholarly analysis. Use in connection with any form of information storage and retrieval, electronic adaptation, computer software, or by similar or dissimilar methodology now known or hereafter developed is forbidden. The use in this publication of trade names, trademarks, service marks, and similar terms, even if they are not identified as such, is not to be taken as an expression of opinion as to whether or not they are subject to proprietary rights. Printed on acid-free paper Springer is part of Springer Science+Business Media (www.springer.com)
Let’s not kid ourselves: The most widely used piece of software for statistics is Excel. Brian D. Ripley “Statistical Methods Need Software: A View of Statistical Computing.” Opening lecture Royal Statistical Society 2002, Plymouth (September 2002).
Preface
Abstract MS Excel, the most widely available spreadsheet on MS Windows machines, is often used for data collection, manipulation, and storage. Elementary and medium-complexity mathematical and statistical functions are included with Excel. More advanced and highly reliable statistical analysis in Excel requires an add-in package. R is one of the best statistics programs available. It is an extensible system of software facilities for data manipulation, statistical analysis, and graphical display. With RExcel, the entire R environment (including more than a thousand contributed packages) can be treated as an extension of Excel. This book is a supplementary text to any introductory course in statistics. The book supports the instructor by giving students step-by-step screenshots showing access to state-of-the-art statistical computations in R directly from the menu bar in Excel. The book can also be used as a computational introduction by data analysts who already h