Calculate Average within a standard deviation (exclude outliers)?

[tyemm]

Can I do this in one step?
find the standard deviation of a group of scores, and then find the average of all scores within (2) standard deviations of the raw mean score?
Right now I'm using this cumbersome method to exclude numbers from a range that fall out of two stds:
=IF(E2-(STDEV($E$2:$E$75)*2)<0,E2,"")
Thanks,
Tom

 

[AnotherHiggins]

This is a bit unwieldy, but it should work for you:

[COLOR=blue white]=SUMIF(rngData, "<" & STDEV(rngData) * 2, rngData) / COUNTIF(rngData, "<" & STDEV(rngData) * 2)[/color]

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.