Array Calculation: Remove outliers
Hello ,
I am not sure which is better way to handle outlier results out of array average calculations. I have a bunch of fractions that get computed like this:
(A-B)/C
Now roughly 95% of the percentage results are ok and expected but some results (red font) are bigger than expected for some weird data.
A B C Results
93 93 95 0 74.55636
94 50000 96 -519.85417 74.55636
70000 96 97 720.659794 74.55636
What is a good way to get rid of these outliers and compute the average of the rest if the percentages?
One way is to get standard deviation for all the row fractions and giving a condition if :
Or each row - Keep on averaging the fraction if STD DEv is within the expected standard deviation value
How do I do this? Or any other real weighted percentage really…
EE-calculationwithoutOutliers.xlsx
I am not sure which is better way to handle outlier results out of array average calculations. I have a bunch of fractions that get computed like this:
(A-B)/C
Now roughly 95% of the percentage results are ok and expected but some results (red font) are bigger than expected for some weird data.
A B C Results
93 93 95 0 74.55636
94 50000 96 -519.85417 74.55636
70000 96 97 720.659794 74.55636
What is a good way to get rid of these outliers and compute the average of the rest if the percentages?
One way is to get standard deviation for all the row fractions and giving a condition if :
Or each row - Keep on averaging the fraction if STD DEv is within the expected standard deviation value
How do I do this? Or any other real weighted percentage really…
EE-calculationwithoutOutliers.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER