How do you handle averages skewed by outliers?
We are attempting to calculate the average days to close for our sales opportunities. The idea is to be able to drill down to the lead source in order to determine whether or not certain lead sources take fewer days to close. The issue that we are running into is that some of the averages are skewed with some opportunities taking 500 - 600 days to close.
Has anyone come up with a way to calculate an average days to close that factors in these types of anomolies and produces an average that's not skewed?