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
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: