I have very limited math skills so please forgive me for the question - if I am way off or otherwise.
I have an database of hundreds of thousands of records...most fall within 30-60 days - but a few have zero, in very rare cases less. On the reverse end of the spectrum I have cases where the day falls into the hundreds and in some cases thousands.
I need to calculate (given absolute min and max and average) some median value. Basically the average but sans extremes.
Is this what standard deviation does? Am I best just lopping off extremes on both ends and recalculating averages?