Skip main navigation

Get 30% off one whole year of Unlimited learning. Subscribe for just £249.99 £174.99. T&Cs apply

Mode

.

Lesson 1: Mode, Mean, Median

In this lesson, we’ll look at the three m‘s: mode, mean, and median. They each measure the “center” of a data set in a slightly different way, and the usefulness of each of these summary statistics depends on the type of data we’re dealing with.

Lab: Mean, Median, Mode

The mean, median, and mode each use different logic to measure the “center” of a data set. The usefulness of each measure depends on the type of data and the level of skew. In this lab, we’ll use Excel to estimate the mean, median, and mode of the coffee data we used in the last module, and we’ll see which measure of center gives us the most useful information about this particular data set.

The lab instructions can be downloaded as a PDF file here.

The data set for this lab can be viewed here. From the link, copy and paste all the data into a new worksheet in Excel Online.

(Note: This lab uses the same data set you used in the labs for the previous module.)

This article is from the free online

Essential Mathematics for Data Analysis in Microsoft Excel

Created by
FutureLearn - Learning For Life