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!!
Bookmarks