R Through Excel : a spreadsheet interface for statistics, data and graphics /
Richard M. Heiberger, Erich Neuwirth
- London: Springer
- xxv,342p. : ill. col.; 24cm
- Use R! .
Table of contents 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 13 2.3 R Console 22 2.4 R Commander window 32 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 37 3.3 un named columns of data 40 3.4 Numeric columns and factor columns 49 3.5 Multiple Numeric columns and factor columns 52 3.6 Transferring data from R to Excel 57 3.7 other input formats, including ASCII text files 60
4 Normal and t Distributions 61 4.1 Accessing R Functions with the Rcmdr menus 61 4.2 Accessing R functions from within Excel cells 66 4.3 Graphical displays of the standard normal distribution 69 4.4 Significance level, Rejection region, and type I Error 71 4.5 Type II Error and power 74 4.6 Displaying Graphs 79
5 Normal and t Workbook 81 5.1 standard normal and t distributions 81 5.2 Relation between a and z 86 5.3 Normal test, Type II Error, and power 87 5.4 Significance, rejection region, and power-continued 91 5.5 How does the normal and t Workbook work?95 5.5.1 input fields 95 5.5.2 display parameters 96 5.5.3 Numerical output 96 5.6 confidence intervals 97 5.6.1 Algebra 97 5.6.2 workbook 98 5.7 Scaling to keep constant Area 99 5.8 normal approximation to the binomial 102
t-Tests 105 6.1 data-canned vegetables 106 6.1.1 plot the data 109 6.1.1.1 histogram 109 6.1.1.2 dot plot 111 6.1.1.3 boxplot 113 6.1.2 calculate the t-test 115 6.1.3 plot the t- Test 117 6.2 data-heights 121 6.2.1 plots 124 6.2.1.1 scatterplots 124 6.2.1.2 dotplots 126 6.2.1.3 boxplots 127 6.2.1.4 bar graph for frequencies 128 6.2.2 summary statistics129 6.2.2 subsetting the data for males130 6.2.3. one sample t- test for males 136 6.2.5 two sample t-test comparing males and females139 6.3 matched pairs t-test 144 6.4 confidence interval plot 152 6.4.1 confidence intervals with the normal and t worksheet 152 6.4.2 confidence intervals with the plot (normal|t) hypotheses or confidence menus 154 6.5 hypothesis plot and confidence interval plot from summary information 155 6.5.1 Hypothesis plots with the plot hypotheses and confidence interval menu and workbook 155 6.5.2 hypothesis plot 156 6.5.3 confidence interval plot 158 6.6 Alternate styles for the calculation of confidence intervals160 6.6.1 recommended style 160 6.6.2 Not recommended style 163
7 One-way ANOVA 165 7.1 data 165 7.2 plots 165 7.2.1 dotplot 168 7.2.2 boxplot 168 7.3 ANOVA specification 170 7.4 ANOVA table and F-test 172 7.5 Table of means 174 7.6 Multiple comparisons 178 7.7 Mean-mean multiple comparisons plot 182 7.8 linear contracts 187
8 Simple Linear Regression 193 8.1 least- squares regression with RExcel/Rcmdr 194 8.2 Scatterplot 197 8.3 linear regression analysis 200 8.4 residuals analysis 204 8.5 confidence bands and prediction bands 209
9 What is the least squares? 213 9.1 minimizing the sum of squares 213 9.2 Hat diagonals and leverage 223 9.3 residuals and leverage 229 9.4 reset the workbook to the values in the text 233
10 Multiple Regression Two X-Variables 235 10.1 The multiple regression model 235 10.2 Example236 10.3 Specify and fit several linear models 243 10.4 Graphical comparison of models 247 10.4.1 plot residuals-fitted 250 10.4.2 rescale plots for ease of comparison 252 10.4.3 Lattice plots with coordinated scales 254 10.4.4 stacking with the right-click menu 255 10.4.5 menu and dialog box for lattice plot261 10.5 ANOVA table 263 10.6 Confidence intervals and predication intervals 265
11 Polynomial Regression 269 11.1 regression on a quadratic function of X 269 11.2 linear fit 274 11.3 quadratic fit 278 11.4 plot of squared residuals 283
12 Multiple Regression -Three or More X-Variables 285 12.1 shoes sizes of Austrain students 286 12.2 plots 293 12.3 regression analysis 300 12.4 basic diagnostic plots 304 12.5 confidence intervals 305
13 Contingency Tables and the Chi-square Test 309 13.1 gender and smoking 310 13.1.1 two-way table chi-square test310 13.1.2 two- sample proportions test 312 13.2 German and math grades 318
A Installation of RExcel 323 A.1 Basic installation procedures 323 A.2 Supported Excel versions 324 A.3 download and installation of R and RExcel for MS windows 324 A.3.1 preparation 325 A.3.2 An Ancient previous version of RExcel must be uninstalled 325 A.3.3 installation 326 A.4 Installing RExcel for MS windows when R is Already installed 327 A.5 upgrade an Existing R installation 328 A.6 R and Rcmdr without Excel - windows, Macintosh linux 329 A.6.1 install the Rcmdr, HH, and Rcmdrplugin. HH packages 329 A..6.2 use the R commander directly 329 A.6.3 data input 329 A.7 R and open office 330 A.8 License for statconnDCOM 330 A.9 Digital certificate 330
B Nuisances Installation Startup or Execution 333 B.1 installation 333 B. 2 startup 334 B.3 Execution 334 Reference 339 Index 341