I am interested in calculating basic stats (mean, median, std dev) on the
middle 80% of a distribution, to eliminate the extreme lows and highs. I
have been doing this manually by counting the number of samples and removing
the bottom 10% and top 10% of the distribution, and then using the average,
median, and stdeva functions on the middle 80%. Is there an automated way to
do this in Excel?