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.
For example, if
=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.
This from an excerpt from my Excel CPE Course, Must Know Excel Tools and Tips for CPAs.
No comments:
Post a Comment