R through Excel: a spreadsheet interface for statistics, data analysis, and graphics

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. Connects R dataframes and Excel data lists Handles missing data Allows the creation of standalone RExcel application which hides R almost completely from the user INDICE: Getting started.- Using RExcel and R Commander.- Getting data intoR.- 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: Installationof RExcel.

• ISBN: 978-1-4419-0051-7
• Editorial: Springer
• Encuadernacion: Rústica
• Páginas: 338
• Fecha Publicación: 01/08/2009
• Nº Volúmenes: 1
• Idioma: Inglés