#1
|
|||
|
|||
Average Processing Time Removing Outliers
I was hoping someone would be able to help, most of the time I can find a solution to my Excel queries by a quick Google, but no luck this time.
I have a series of data such as: Item 1 -- 03:42but a lot more lines (about 30k), and a lot more 'Item' types (about 160). The corresponding value is the amount of time it takes to action said item. With each line being a different time that same item type has been actioned. I am looking to get an average time for say specifically Item 1, but removing any outliers. I currently have: PHP Code:
Obviously this method does not remove outliers however. I've looked at TRIMMEAN, however as commented in other places, this tends to rather arbitrary culling of data PHP Code:
PHP Code:
Much appreciated if you can! |
#2
|
|||
|
|||
You need a helper column with formula where an outlier returns 1, otherwise 0.
|
#3
|
|||
|
|||
Can you elaborate?
I'm not sure how that helps determine what data are outliers? Thanks |
#4
|
|||
|
|||
I didn't have a clue what are criterions for entry being outlier for you, so I simply made them up. And I didn't create additional data for example, so it is not very presentable. Anyway I think you can get the idea.
|
Tags |
average if, outliers, time calculation |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Average Processing Time | christian.calimlim22 | Excel | 3 | 04-04-2017 11:25 PM |
how to calculate average time | aymanharake | Excel | 6 | 02-17-2017 04:22 PM |
Calculating Average Time across days | lizakay | Excel | 3 | 11-25-2015 05:16 PM |
Average minus outliers? | markg2 | Excel | 2 | 01-07-2012 05:46 PM |
Processing Time Intervals | pkrishna | Excel | 5 | 09-30-2011 06:24 AM |