Short Courses in Applied Statistics

Course outline

This course gives practical experience in the use of Microsoft^® Excel^® for data summary, presentation and for other basic statistical work. It concentrates on areas where Excel really can excel, such as array functions. We look at data entry and management, pivot tables, and graphics. We also review Excel's facilities for statistical analysis, advising on their use and limitations, and we show how add-ins can be used to enhance Excel's capabilities.

Who should attend?

Participants are assumed to have some experience in Excel. This course is intended for anyone who currently uses or is thinking of using Excel for handling data and for their statistical work. It is also for statisticians, if they need to advise and support others on the efficient use of Excel.

How you will benefit

This course is designed to turn your general Excel capabilities into skills in the use of Excel for data processing and basic statistical applications. The course will make use of our Excel add-in called SSC-Stat, which provides some statistical features that are not available in standard Excel. A copy of this add-in will be given to all participants.

Course content

Data entry and validation
Efficient data management, named ranges and VLOOKUP
Pivot tables for cross tabulations
Good statistical graphics
Conditional operations and array functions
Data summary and analysis; pros and cons of the Analysis Toolpak
The use of SSC-Stat, an Excel add-in for efficient statistical work

Discounts

An Academic discount is available for this course.
Consecutive courses, i.e. Taking Microsoft^® Excel^® 2007 Further: Macros for Data Management and Statistics plus this course: £825 in total.