Home

How to Find mean, median, & mode (averages)

May 7, 2010 05:39 PM

A screenshot of an Excel spreadsheet displaying apartment rents and calculations for mean, median, and mode.

If you use Microsoft Excel on a regular basis, odds are you work with numbers. Put those numbers to work. Statistical analysis allows you to find patterns, trends and probabilities within your data. In this MS Excel tutorial from everyone's favorite Excel guru, YouTube's ExcelsFun, the 34th installment in his "Excel Statistics" series of free video lessons, you'll learn how to use MEAN, MEDIAN, MODE. These measures give us a typical value, a measure of central tendency one value that can represent all the data points.

See:

1) SUM, COUNT, AVERAGE functions for mean

2) MEDIAN function and sorting to find median

3) MODE function (has problems) and a frequency table with a pivot table to find mode.

You already know how to use your phone. With Gadget Hacks' newsletter, we'll show you how to master it. Each week, we explore features, hidden tools, and advanced settings that give you more control over iOS and Android than most users even know exists.