Update cookies preferences

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

3.62/5 (16 ratings by Goodreads)
  • Format: PDF+DRM
  • Series: Use R!
  • Pub. Date: 23-Jan-2010
  • Publisher: Springer-Verlag New York Inc.
  • Language: eng
  • ISBN-13: 9781441900524
  • Format - PDF+DRM
  • Price: 74,09 €*
  • * the price is final i.e. no additional discount will apply
  • Add to basket
  • Add to Wishlist
  • This ebook is for personal use only. E-Books are non-refundable.
  • Format: PDF+DRM
  • Series: Use R!
  • Pub. Date: 23-Jan-2010
  • Publisher: Springer-Verlag New York Inc.
  • Language: eng
  • ISBN-13: 9781441900524

DRM restrictions

  • Copying (copy/paste):

    not allowed

  • Printing:

    not allowed

  • Usage:

    Digital Rights Management (DRM)
    The publisher has supplied this book in encrypted form, which means that you need to install free software in order to unlock and read it.  To read this e-book you have to create Adobe ID More info here. Ebook can be read and downloaded up to 6 devices (single user with the same Adobe ID).

    Required software
    To read this ebook on a mobile device (phone or tablet) you'll need to install this free app: PocketBook Reader (iOS / Android)

    To download and read this eBook on a PC or Mac you need Adobe Digital Editions (This is a free app specially developed for eBooks. It's not the same as Adobe Reader, which you probably already have on your computer.)

    You can't read this ebook with Amazon Kindle

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. Rs 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.

Reviews

From the reviews:

The book R Through Excel offers a good entry for those just beginning with R through the familiar Microsoft Excel. Will help those using Microsoft Excel on computers in MS Windows environments become more familiar with two programs designed to work with R. All of the functions and many of the topics discussed can be applied for independent R installations on Linux, Unix, or Apple computers. R is an intimidating but powerful program that assumes an intimate knowledge of data formats and terminology not familiar to many language testers. R Through Excel is a highly recommended first step into that program. (Shiken: JALT Testing& Evaluation SIG Newsletter )

Students, researchers, and others who wish to use R . This book is essentially a manual for the RExcel software. Most commonly a page consists of one or more screenshots showing how to use RExcel. The whole book is reproduced in color, on glossy paper. Readers are guided through the menu system to see how to carry out common statistical procedures. For anyone wishing to learn RExcel this book would be a useful purchase. (David J. Scott, International Statistical Review, Vol. 78 (2), 2010)

R Through Excel offers a concise introduction to statistical analysis for those with little prior experience in statistical software. The text provides a nontechnical introduction to the R programming language and the presentation is helpful for those who are averse to syntax commands. an excellent manual to have on the shelf for anyone that is interested in integrating R and Excel. For those in academia who teach introductory statistics and want to use R, this text provides a gentle manner for doing so. (Philip Okoth, The American Statistician, Vol. 65 (4), November, 2011)

I was very impressed by the layout of the book. Each of the main chapters is clear and uncluttered, with extensive use of colour screenshotsto illustrate what the reader should see when using RExcel. Overall, I think this is an excellent resource for someone wishing to learn how to use this software, particularly if they prefer to do so with the comforting old-fashioned feel of a book. (David Fletcher, Australian & New Zealand Journal of Statistics, Vol. 53 (4), 2011)

Preface vii
Notes to Readers xiii
Getting Started
1(12)
Starting RExcel with the RExcel Icon
1(2)
Starting RExcel from a Running Excel Window
3(4)
Starting RExcel from a Running Excel 2007 Window
3(2)
Starting RExcel from a Running Excel 2003 Window
5(2)
Starting R Commander Without Excel
7(3)
Window Arrangement
10(1)
Graphics History
10(1)
Quitting RExcel
11(2)
Using RExcel and R Commander
13(24)
Appearance
13(9)
The Dataset and Model Menus
22(10)
R Console
32(2)
R Commander Window
34(1)
R Help Files
35(1)
Messages from R, Rcmdr, or Excel
35(2)
Getting Data into R
37(24)
Example Datasets
37(3)
Named Columns of Data
40(6)
Unnamed Columns of Data
46(3)
Numeric Columns and Factor Columns
49(3)
Multiple Numeric Columns, One per Factor Level
52(5)
Transferring Data from R to Excel
57(3)
Other Input Formats, Including ASCII Text Files
60(1)
Normal and t Distributions
61(20)
Accessing R Functions with the Rcmdr Menus
61(5)
Accessing R Functions from Within Excel Cells
66(3)
Graphical Displays of the Standard Normal Distribution
69(2)
Significance Level, Rejection Region, and Type I Error
71(3)
Type II Error and Power
74(5)
Displaying Graphs
79(2)
Normal and t Workbook
81(24)
Standard Normal and t Distributions
81(5)
Relation Between α and z
86(1)
Normal Tests, Type II Error, and Power
87(4)
Significance, Rejection Region, and Power---Continued
91(4)
How Does the Normal and t Workbook Work?
95(2)
Input Fields
95(1)
Display Parameters
96(1)
Numerical Output
96(1)
Confidence Intervals
97(2)
Algebra
97(1)
Workbook
98(1)
Scaling to Keep Constant Area
99(3)
Normal Approximation to the Binomial
102(3)
t-Tests
105(60)
Data---Canned Vegetables
106(15)
Plot the Dat
109(1)
Histogram
109(2)
Dotplot
111(2)
Boxplot
113(2)
Calculate the t-Test
115(2)
Plot the t-Test
117(4)
Data---Heights
121(23)
Plots
124(1)
Scatterplots
124(2)
Dotplots
126(1)
Boxplots
127(1)
Bar Graph for Frequencies
128(1)
Summary Statistics
129(1)
Subsetting the Data for Males
130(6)
One-Sample t-Test for Males
136(3)
Two-Sample t-Test Comparing Males and Females
139(5)
Matched Pairs t-Test
144(8)
Confidence Interval Plot
152(3)
Confidence Intervals with the normal and t Worksheet
152(2)
Confidence Intervals with the Plot [ normal|t] hypotheses or Confidence Intervals Menus
154(1)
Hypothesis Plot and Confidence Interval Plot from Summary Information
155(5)
Hypothesis Plots with the Plot hypotheses and Confidence Intervals Menu and Workbook
155(1)
Hypothesis Plot
156(2)
Confidence Interval Plot
158(2)
Alternate Styles for the Calculation of Confidence Intervals
160(5)
Recommended Style
160(3)
Not Recommended Style
163(2)
One-Way Anova
165(28)
Data
165(3)
Plots
168(4)
Dotplot
168(2)
Boxplot
170(2)
Anova Specification
172(2)
Anova Table and F-Test
174(4)
Table of Means
178(1)
Multiple Comparisons
179(3)
Mean--Mean Multiple Comparisons Plot
182(5)
Linear Contrasts
187(6)
Simple Linear Regression
193(20)
Least-Squares Regression with RExcel/Rcmdr
194(3)
Scatterplot
197(3)
Linear Regression Analysis
200(4)
Residuals Analysis
204(5)
Confidence Bands and Prediction Bands
209(4)
What Is Least Squares?
213(22)
Minimizing the Sum of Squares
213(10)
Hat Diagonals and Leverage
223(6)
Residuals and Leverage
229(4)
Reset the Workbook to the Values in the Text
233(2)
Multiple Regression---Two X-Variables
235(34)
The Multiple Regression Model
235(1)
Example
236(7)
Specify and Fit Several Linear Models
243(4)
Graphical Comparison of Models
247(16)
Plot Residuals ~ Fitted
250(2)
Rescale Plots for Ease of Comparison
252(2)
Lattice Plots with Coordinated Scales
254(1)
Stacking with the Right-Click Menu
255(6)
Menu and Dialog Box for Lattice Plot
261(2)
Anova Table
263(2)
Confidence Intervals and Prediction Intervals
265(4)
Polynomial Regression
269(16)
Regression on a Quadratic Function of X
269(5)
Linear Fit
274(4)
Quadratic Fit
278(5)
Plot of Squared Residuals
283(2)
Multiple Regression---Three or More X-Variables
285(24)
Shoe Sizes of Austrian Students
286(7)
Plots
293(7)
Regression Analysis
300(4)
Basic Diagnostic Plots
304(1)
Confidence Intervals
305(4)
Contingency Tables and the Chi-Square Test
309(14)
Gender and Smoking
310(8)
Two-Way Table Chi-Square Test
310(2)
Two-Sample Proportions Test
312(6)
German and Math Grades
318(5)
A Installation of RExcel
323(10)
Basic Installation Procedures
323(1)
Supported Excel Versions
324(1)
Download and Installation of R and RExcel for MS Windows
324(3)
Preparation
325(1)
An Ancient Previous Version of RExcel Must Be Uninstalled
325(1)
Installation
326(1)
Installing RExcel for MS Windows When R Is Already Installed
327(1)
Upgrade an Existing R Installation
328(1)
R and Rcmdr Without Excel---Windows, Macintosh, Linux
329(1)
Install the Rcmdr, HH, and RcmdrPlugin.HH packages
329(1)
Use the R Commander Directly
329(1)
Data Input
329(1)
R and Open Office
330(1)
License for statconnDCOM
330(1)
Digital Certificate
330(3)
B Nuisances---Installation, Startup, or Execution
333(8)
Installation
333(1)
Startup
334(1)
Execution
334(7)
References 341(1)
Index 341