Home

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

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.

Apple's iOS 26 and iPadOS 26 updates are packed with new features, and you can try them before almost everyone else. First, check Gadget Hacks' list of supported iPhone and iPad models, then follow the step-by-step guide to install the iOS/iPadOS 26 beta — no paid developer account required.