Joint half day meeting between the ASSUME and the RSS Statistical
Computing Section
Wednesday 17th March 2004 at 2:00-5:30 pm
Errol Street
Tea will be served at 3:45pm.
This joint half day session with ASSUME is split into two parts. The first
session discusses statistical 'add-ins' and the importing of R and NAG
routines into Excel to allow more complex and powerful statistical
calculations. After tea the concept of building array calculations in
Excel is discussed.
"Statistics on the desktop: Integration of Excel and R"
Erich Neuwirth (University of Vienna )
Synopsis: Microsoft Excel is probably the most widely used tool for
statistics. On the other hand, is has not been designed as a statistical
tool, therefore it does not offer all the advanced statistical methods
professional statisticians need. We will show how R, a powerful open
source statistics program can be integrated into Excel and how this
integrated environment allows to combine the drag and drop interface and
the spreadsheet concepts with the powerful statistical system offering
facilities to develop very advanced statistical procedures. We will also
discuss how different user groups can benefit from this combination in
different ways. Some examples will show how this software environment can
be used to rapidly develop powerful interactive statistics applications.
"Importing NAG Routines into Excel"
David Sayers (NAg Ltd., Oxford, UK)
Synopsis: This talk will illustrate the ease with which routines written
in Fortran or C may be incorporated into Excel without the need to
translate the source into VBA. Throughout the presentation copious
examples will be given, starting first with a peek at the insides of the
NAG Statistical Add-Ins, followed by a series of examples linking other
NAG routines to Excel. It is assumed throughout that users may have
routines of their own that they would like to use within the Excel
environment and this talk indicates how this might be achieved.
Principally the Add-In route is illustrated, but an example of a COM
interface is also given. Rather than concentrate on details, an overview
is given but the author will be pleased to receive particular questions
either during the meeting or separately offline.
Francois Sermier (Independent Consultant, Paris )
Synopsis: To Follow
Enquiries
Phil Bowtell
[log in to unmask]
|