D
Dags17
I have a table with a bunch of figures and want to exclude the more extreme
figures from calculations...
figures from calculations...
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
Mike
The criteria for deciding what is extreme is key to answering your question.
However, 1 way:-
=AVERAGE(IF((A1:A10>=2)*(A1:A10<=8),A1:A10))
The above looks at the range A1 - A10 and averages the numbers in the range
that are >=2 and <=8. It's an array entered with CTRL + Shift + enter.
The 'average' bit could simply be changed to whatever calculation you are
trying to do.
Mike
However, 1 way:-
=AVERAGE(IF((A1:A10>=2)*(A1:A10<=8),A1:A10))
The above looks at the range A1 - A10 and averages the numbers in the range
that are >=2 and <=8. It's an array entered with CTRL + Shift + enter.
The 'average' bit could simply be changed to whatever calculation you are
trying to do.
Mike
D
Dave F
Well, the answer to that question depends on what your criteria is. So,
what's your criteria?
Dave
what's your criteria?
Dave
G
Gary''s Student
Calculate the mean and standard deviation of your data. Then exclude points
more than 3 sigma ( or any sigma of your choice) away from the mean.
Be very careful about excluding outliers. If they are real data points,
they may indicate your variance is actually larger than you expected.
more than 3 sigma ( or any sigma of your choice) away from the mean.
Be very careful about excluding outliers. If they are real data points,
they may indicate your variance is actually larger than you expected.
R
Roger Govier
Hi
Take a look at the TRIMMEAN function.
Take a look at the TRIMMEAN function.