Skip main navigation



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

Reach your personal and professional goals

Unlock access to hundreds of expert online courses and degrees from top universities and educators to gain accredited qualifications and professional CV-building certificates.

Join over 18 million learners to launch, switch or build upon your career, all at your own pace, across a wide range of topic areas.

Start Learning now