Data and AI Training

Home | Prices | Contact Us | Courses: 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