# Filtered Data for Median - strange?

I am looking at a legacy process for work. We look at corporate budget data. The data is composed of annual budgets for different major categories for different corporate regions. The upper management wants to see medians, and I noticed whoever started this report decided to trim whatever amount below 5k and then time the median of all over budgets. (I think his thought process was that rarely people would have a budget less than 5k , so the data collection/reporting must have been incomplete or incorrect). I have never seen people asymmetrically trim the dataset for medians since I think calculation of median depend heavily on symmetry. I did a quick comparison of trends based on medians without his trimming process and with his trimming process, and there are (i think) significant difference.....what do you guys think? Is this type of trimming for median calculation "appropriate"?

Thank you!

• Could you explain what it means to "time the median over all budgets"? – whuber Oct 26 '15 at 20:12

If it's budget-related, trimming values below a certain threshold sounds like a financial "indifference" heuristic, kind of like rounding every number up to $100,$1,000, $10,000 or$100,000, etc., depending on the company and their accounting practices. The "appropriateness" is totally a function of convenience in eliminating nuisance numbers, company conventions and culture-specific rules of thumb. In other words, there is no statistical, much less theoretical, motivation for doing this.