JSM Preliminary Online Program
This is the preliminary program for the 2009 Joint Statistical Meetings in Washington, DC.

The views expressed here are those of the individual authors
and not necessarily those of the ASA or its board, officers, or staff.

Back to main JSM 2009 Program page

Activity Number: 88
Type: Invited
Date/Time: Monday, August 3, 2009 : 8:30 AM to 10:20 AM
Sponsor: General Methodology
Abstract - #302876
Title: RExcel in Introductory and Advanced Statistics Courses
Author(s): Richard M. Heiberger*+
Companies: Temple University
Address: Speakman Hall, Philadelphia, PA, 19122-6083,
Keywords: R ; Excel ; spreadsheet ; teaching ; software
Abstract:

I use RExcel with Rcmdr as the primary software tool in introductory courses. I use the RExcel interface to R as a supplementary tool in advanced courses. Our worksheets, using Excel for problem specification and R for graphics, illustrate the concepts of hypothesis testing, construction and interpretation of confidence intervals, and least squares fitting. We use Excel scrollbars, checkboxes, and change of data values for dynamic control of R graphical displays. Any R function or graph can by controlled from an Excel worksheet. The Rcmdr package provides a clickable menu into R. RExcel places the Rcmdr menu on the Excel menu bar. By placing any R function inside the spreadsheet paradigm of automatic recalculation, we have placed the full power of R, one of the best programs for statistical analysis and graphical display of data, into a familiar user environment.

  • The address information is for the authors that have a + after their name.
  • Authors who are presenting talks have a * after their name.

Back to the full JSM 2009 program


JSM 2009 For information, contact jsm@amstat.org or phone (888) 231-3473. If you have questions about the Continuing Education program, please contact the Education Department.
Revised September, 2008