Basic Business Statistics Using EXCEL

Objectives

This two day course gives a comprehensive introduction to basic statistical methods for analysts and is customised to your particular requirements. Emphasis is placed on the interpretation of the statistical summaries obtained and their application in the working context. The course uses EXCEL to carry out the statistical analyses.

Typical Content (can be modified to suit your particular requirements)

• Data investigation
• Variability and distributions, measured variables, counts and attribute data
• Estimation of means - standard errors, confidence intervals
• Significance tests - how to interpret them
• Comparisons of means
• Response rates, precision measures
• Sampling - how big a sample do I need?
• Correlation
• Regression - fitting simple models to data
• Cross tabulations, chi-squared test of association

Entry Level

The course assumes no prior statistical knowledge

Style

The course contains a mixture of formal training sessions and practical workshops where participants can analyse data from structured exercises using EXCEL. We prefer to run the course using customised data from the participants' own environment but off the shelf data sets can be used.