How to Find mean, median, & mode (averages)
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.
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.