Hi
I have a time column [H]:MM I am calculating the following using the adjacent formulas
How can I make MAX, MEDIAN and MIN ignore 5% outliers just like it does with MEAN (Trimmean) ?Please Login or Register to view this content.
Thanks
Hi
I have a time column [H]:MM I am calculating the following using the adjacent formulas
How can I make MAX, MEDIAN and MIN ignore 5% outliers just like it does with MEAN (Trimmean) ?Please Login or Register to view this content.
Thanks
Example of how TRIMMEAN() calculates an outlier:
TRIMMEAN rounds excluded data points down to the nearest multiple of 2.
For example, with 50 data points, 10% equals 5 values. In this case, TRIMMEAN will round 5 down to 4, then exclude two values from the top, of the data set, and two values from the bottom of the data set.
I guess what I am saying is, if I can get Max/Median/Min to remove a % I give it from the top and bottom values that will also do the job.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks