From the course: Excel 2016: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Finding the middle value with MEDIAN and most common value with MODE

Finding the middle value with MEDIAN and most common value with MODE

From the course: Excel 2016: Advanced Formulas and Functions

Start my 1-month free trial

Finding the middle value with MEDIAN and most common value with MODE

“

- Excel has any number of statistical functions. If you're looking for them on the Formulas tab, you might be surprised at first you don't see a category called Statistical. It's under More Functions. There we are, and quite a few of them. One function you'll see from time to time is median. It's often compared with average. What's the average salary here? Average, we'll simply click column G and enter, we've got a result. How about the median, the middle value? What median actually does is it considers the data you're looking at, in this case, all the data in column G. And by the way, it ignores cell G1. It only looks at the cells that have numbers and then sorts them and pulls out the number from the middle. If there's an even number of entries, it'll take the middle two and average them to come up with the median. And from time to time, it's worth comparing median and average. Average sometimes is distorted by an extremely high or an extremely low entry. Median sometimes is the…

Contents