![]() |
#1
|
|||
|
|||
![]()
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! |
Tags |
average if, outliers, time calculation |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
christian.calimlim22 | Excel | 3 | 04-04-2017 11:25 PM |
![]() |
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 |
![]() |
pkrishna | Excel | 5 | 09-30-2011 06:24 AM |