An Introduction to Statistics with Excel

Introduction to Statistics

Analysing Discrete vs Continuous Data

Bar charts and Histograms

Mean, median and mode

Weighted averages

Probabilities

Distributions of Data

• Normal distributions

• Standard Deviation

• Variance

• Skew 

• Kurtosis

• Other types of distribution (e.g. Binomial, Poisson)

Understanding Quartiles

• Boxplots 

• Box and whiskers plot

Confidence intervals

Sampling and the Central Limit Theorem

Standardising Data

Analysing Trends

Correlation is not causation!

Working with Time Series data, and making sensible comparisons