Hi, I have this issue where i have a list of numbers example
429,528,598,643,719,802,864,31743 and I only need to remove the 31743 which is a odd number, and all other numbers are in the required range. I tried TRIMMEAN, but that removes the high and low. which is not right. The right average should be 655 but when you use the TRIMMEAN i get 692.
| 429 | 428.8865 | | |
| 528 | 31743 | | |
| 598 | | | |
| 643 | | | |
| 719 | | | |
| 802 | | | |
| 864 | | | |
| 31743 | | | |
| 692.3978 | using TRIMMEAN | |
| 655 | Actual average 429 to 864 |
How can i just exclude the high value and not the value on the lower side.
