Edited Sep 1, 2015
NOTE: [PERFORMS TABLE SCAN]
Unweighted Median Algorithm
The unweighted median is the middle value in a set of sorted values if there are an odd number of values. If there are an
even number of values, the unweighted median is the average of the middle two values.
Weighted Median Algorithm (beta)THERE IS A PROBLEM WITH WEIGHTED MEDIAN. DON'T USE IT.
Note: This algorithm computes a slightly different value than that of SPSS's weighted median algorithm. But it appears to match the weighted
median algorithm of WinCross. As of now we cannot seem to get the algorithm to precisely match the algorithm described in SPSS's documentation and wonder
if there either exists a typo in the SPSS documentation or perhaps SPSS only supports a certain amount of decimal precision when cumulating the
weights. The exact algorithm Report Builder uses for weighted median is shown below. Additional testing and research is in progress. Please
talk to use if you have questions or suggestions about this.
is a set of sorted values where
Calculate the sum of the weights and the midpoint of that sum:
Calculate the cumulative weight per entry:
Find the closest indexes a
such that the values cwa
are as close to midwt as possible.
Calculate distances from the midpoint weight for interpolation:
The weighted median equals: