Hi I am doing some data analysis of drop jump heights calculated via force plate data.
I need to create a formula which selects the middle 3 values out of 5 values (5 dropjump heights) and then averages them.
For example in this data set: 23.45 25.67 25.28 24.92 28.5
The closest 3 would be: 25.67 25.28 24.92
Which I would then average.
Many thanks for any help and suggestions!!
You can use TRIMMEAN formula to average without "outliers". If you have data in A1:A5 this formula will average the middle 3
=TRIMMEAN(A1:A5,0.4)
...or this formula will give the same result
=AVERAGE(LARGE(A1:A5,{2,3,4}))
Audere est facere
Thanks very much, what does the 0.4 represent? The amount to which it is trimmed?
Yes, if you use 0.4 or 40% then it will discard 40% of the values equally from top and bottom, so with 5 values 40% represents just the top and bottom values
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks