MEDIAN (MD)


The median is generally, a better measure in valuation analysis as it is the CENTRAL value in a data group. The central value is found as follows:

MD = (n+1)/2

Summerton and Williamville have 19 sales each:

MD = (19+1)/2 = 10

Therefore, the median sale is that sale at the 10th place.

In Libre Office Calc (a free spreadsheet) : MEDIAN(cell range)