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



Richard M. Heiberger, Erich Neuwirth "R Through Excel: A Spreadsheet Interface for Statistics, Data Analysis, and Graphics"
Springer | English | 2009-08-05 | ISBN: 1441900519 | 343 pages | PDF | 17 MB


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.

conversion.

Contents
Preface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . vii
Notes to Readers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiii
1 Getting Started . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
1.1 Starting RExcel with the RExcel Icon . . . . . . . . . . . . . . . . . . . . . . . . . . 1
1.2 Starting RExcel from a Running Excel Window . . . . . . . . . . . . . . . . . 3
1.2.1 Starting RExcel from a Running Excel 2007 Window . . . . . . 3
1.2.2 Starting RExcel from a Running Excel 2003 Window . . . . . . 5
1.3 Starting R Commander Without Excel . . . . . . . . . . . . . . . . . . . . . . . . . 7
1.4 Window Arrangement . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10
1.5 Graphics History . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10
1.6 Quitting RExcel . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11
2 Using RExcel and R Commander . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13
2.1 Appearance . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13
2.2 The Dataset and Model Menus . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22
2.3 R Console. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32
2.4 R Commander Window . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34
2.5 R Help Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35
2.6 Messages from R, Rcmdr, or Excel . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35
3 Getting Data into R . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37
3.1 Example Datasets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37
3.2 Named Columns of Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40
3.3 Unnamed Columns of Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46
3.4 Numeric Columns and Factor Columns . . . . . . . . . . . . . . . . . . . . . . . . 49
3.5 Multiple Numeric Columns, One per Factor Level . . . . . . . . . . . . . . . 52
3.6 Transferring Data from R to Excel . . . . . . . . . . . . . . . . . . . . . . . . . . . . 57
3.7 Other Input Formats, Including ASCII Text Files . . . . . . . . . . . . . . . . 60

..........