hello all,
I am looking for a way to achieve an average while removing outlining values.
I attached a sample of some data that im working with...
What i am hoping is that i can take an average of Hrs worked per Assy in Column I where The value in Columb B and D match but exclude any lines that are more than XX% different from the other entries. *the % to be used is still TBD*
I initially tried to add a helper column that checked the hours worked against a calculated average and i was going to have it just display "yes" or "no" if the hours work was greater than 10% different than the average but the problem with that is the major outliers were still weighing the average and thus botching the results.
Im sure i did a poor job of explaining this but if you can follow along at all please let me know if you have ideas or questions.
Bookmarks