The views expressed here are those of the individual authors and not necessarily those of the JSM sponsors, their officers, or their staff.
Abstract Details
Activity Number:
|
312
|
Type:
|
Contributed
|
Date/Time:
|
Tuesday, August 2, 2011 : 8:30 AM to 10:20 AM
|
Sponsor:
|
Section for Statistical Programmers and Analysts
|
Abstract - #301010 |
Title:
|
RExcel for Pharmaceutical Applications
|
Author(s):
|
Richard Heiberger*+
|
Companies:
|
Temple University
|
Address:
|
Department of Statistics, Philadelphia, PA, 19122-6083,
|
Keywords:
|
spreadsheet ;
R ;
dialog box ;
simulation of clinical trials ;
GUI ;
Rcmdr
|
Abstract:
|
R provides powerful graphic and statistics tools. R also has a high startup cost.
Excel provides a familiar interface with control mechanisms (menus, sliders, checkboxes, option buttons, double-clicking) with which users are comfortable.
The RExcel interface provides a spreadsheet front end to the superior graphics and statistical analyses available in R. RExcel provides menu access to many R functions directly from Excel by placing the Rcmdr menu on the Excel menu bar. RExcel permits placing any R function inside the spreadsheet paradigm of automatic recalculation. Together, these RExcel tools 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.
We give examples of an Excel frontend and an R backend for designing complex processes and analyses, with the data and control coming from the spreadsheet 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 2011 program
|
2011 JSM Online Program Home
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.