Microsoft Excel for Statistics? What you can and cannot do 27-28 April 1998
For further information and registration details please contact:
Kellie Watkins
Statistical Services Centre
The University of Reading
Harry Pitt Building
Whiteknights Road
PO Box 240
Reading, RG6 6FN
Tel: 0118 931 8689
Fax: 0118 975 3169
email: [log in to unmask]
Excel has both strengths and weaknesses for statistical applications and the
course aims to highlight these.
In addition to Excel's worksheet functions which include facilities for
probability and statistical calculations, there are also some procedures for
statistical data analysis available as "add ins". The most useful of these
functions and procedures will be explored in the course.
Other important aspects of statistical data anlysis are data management,
data summary and exploration, tabulations and statistical graphs. The
extent to which Excel can be used for these aspects, as well as its
limitations, are also covered.
Course content:
* Data management concepts and techniques
* Summary statistics and data exploration
* Tabulation
* Statistical graphics
* Statistical tools provided with Excel, including descriptive
statistics, hypothesis tests, correlation and regression,
analysis of variance
* Third party statistical software designed for use with Excel
* Using Excel with statistics packages
-------------------------------------------------------------------------------
Kellie Watkins Tel: +44 (0)118 931 8689
Centre Secretary Fax: +44 (0)118 975 3169
Statistical Services Centre
Harry Pitt Building email: [log in to unmask]
The University of Reading
Earley Gate
P.O. Box 240
Reading
RG6 6FN
-------------------------------------------------------------------------------
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
|