Follow

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

=STDEV.P(A:A)

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.

=MEDIAN(A:A)

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

=MIN(A:A)

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

=MAX(A:A)

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

=COUNTIF(Sheet1!AD:AD,">90")/1090*100

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