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.

The next big software update for iPhone is coming sometime in April and will include a Food section in Apple News+, an easy-to-miss new Ambient Music app, Priority Notifications thanks to Apple Intelligence, and updates to apps like Mail, Photos, Podcasts, and Safari. See what else is coming to your iPhone with the iOS 18.4 update.