Hi.
I'm looking for a way to compute the average while excluding outliers. This average is based on 5 attribute values for each record.
To expand, i am QCing pole counts within permits. Each permit is a record. There are a bit over 10k records. I have 5 attributes, with pole counts, each coming from a different source.
Example:
permit a, pole counts = 1, 4, 5, 28, 6
permit b, pole counts = 2, 10, 14, 80, 12
Manually, for permit a, i'd exclude 1 and 28 and my avg would be 5. For permit b, i'd exclude 2 and 80 and my avg would be 12.
The final goal for this exercise is to pick the value closest to the average computed without outliers.
Pls help. Thank you.
