Archive for September 2nd, 2011

Average and Standard Deviation without outliers in Excel

September 2nd, 2011 admin No comments

Sometimes you need the average and standard deviation of a dataset without a certain amount of outliers.

For example you want the average or standard deviation without the top 2.5% datapoints



If you want the average without the top 10 and bottom 10 datapoints this would be your solution


happy averaging or standard deviating

Categories: Excel, Formulas Tags: ,