Simple Analysis of .mvnx File in Excel

The attached .xlsx file has a few simple formulae which were used to analyze the Z component of the shoulder angle of an imported .mvnx file.

Reps over Threshold - This will give you the frequency a certain threshold is exceeded

=SUMPRODUCT(--(FREQUENCY(IF(A1:A1092>=70,ROW(A1:A1092)),IF(A1:A20< 70,ROW(A1:A1092)))>0))

Standard Deviation - a quantity calculated to indicate the extent of deviation for a group as a whole


Median - denoting or relating to a value or quantity lying at the midpoint of a frequency distribution of observed values or quantities, such that there is an equal probability of falling above or below it.


Minimum Value - gives the smallest value in the set of numbers


Maximum Value -  gives the largest value in the set of numbers


% of time over threshold - gives the percentage of frames over a certain threshold


Download the file here:

Was this article helpful?
0 out of 0 found this helpful
Do you have a question? Please post your question in our Community Forum