142 Biodex Medical Systems, Inc. © 2017
3. To determine the Sway Index for each data point within the spreadsheet, enter the following
formula in cell C of every row starting with the first data point in row 43 and ending with
the last data point in row 849:
=((A43-$A$851/807)*(A43-$A$851/807))+((B43-$B$851/807)*(B43-$B$851/807))
Figure C.8. CSV File Format Calculation – Calculate Sway Index for Every Data Point.
4. To find the Sway Index value, enter the following formula taking the sum of all the data
points and placing it into cell C:
=SQRT(SUM(C43:C849)/807)/1000.
Using this formula, the resultant Sway Index value is equal to: 2.295.
Figure C.9. CSV File Format Calculation – Calculate the Sum of all Sway Indices
Where: 807 = the number of samples for this example.
1000 = the scale factor.
To Next Page
Loading...
