Data Training Courses

Home | Power BI | Excel | Python | SQL | Generative AI | Visualising Data | Analysing Data

Descriptive Statistics

Mean, Median and Mode

Mean, Median and Mode are all measures of central tendency.

Question: What are the mean, median and mode of the data below?

stats mean median mode excel question

Answer: What are the mean, median and mode of the data below?

stats mean median mode excel answer

Standard Deviation

The standard deviation (SD) is a measure of how spread out the numbers are.

In a normal (bell shaped) curve

stats sd image

stats sd formula

The Standard Deviation formula

A cautionary tale – Anscombe’s Quartet

stats anscombe

Source: Wikipedia