Best Microsoft Excel Bloggers

Friday, May 12, 2017

Determining Median and Mode

Determining the Median and Mode

Sometimes determining the average is not sufficient.
For example, if
 you are analyzing departmental salaries you might want to know the median or mode of the salary levels.

=Median(data range)  internally sorts the data and  then displays the middle value. If there is an even number of values, then the two values in the middle are averaged. =Median(B2:B10)

=Mode(data range) will display the value that appears most often. =MODE(B2.B10)

This from an excerpt from my Excel CPE Course, Must Know Excel Tools and Tips for CPAs.  

No comments:

Post a Comment

Ms. Excel- Resident Excel Geek