Applied Statistical Data Analysis

This is a one-day course for people who use statistics to support decision making in their daily work. This course is helpful for those who are new to Statistics or who have only a theoretical knowledge of the subject. The programme is highly interactive and includes comprehensive practical examples and exercises.

Learning Objectives

Upon completion of this course, you will understand:
The uses and limitations of Statistical Techniques in decision making
A range of Statistical Technique
How and when to apply each Statistical Technique
How to interpret results of Statistical analysis.

Topic

Excel Function

Analysing Data Sets

 

Mean (Geometric, Harmonic)

AVERAGE
TRIMMEAN

Median

MEDIAN

Mode

MODE

Range

 

Variability

 

Sample Size vs Variability vs Confidence

 

Frequency Distributions

FREQUENCY

Statistical inference

 

Samples and populations

 

Sampling bias and error

 

 

 

Data Distributions

 

The Normal Distribution      

NORMDIST

 

NORMINV

Population Variance

VARP

Sample Variance

VAR

Population Std Dev

STDEVP

Sample Std Dev

STDEV

Confidence

CONFIDENCE

T Distribution                        

TINV

Hypothesis testing,

 

 

ZTEST

Type I and II errors

 

Paired t-tests

TDIST

F tests

 

Correlation

 

Properties of r and r2

 

Regression

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Data Terminology
Accuracy, Precision ,Error
Bias, Reproducibility, Uncertainty                                                           Worked Example

Pre-Requisites
Participants must have access to a laptop computer. Course data will be provided in Excel format for use to support the Training programme.