Spreadsheet Analysis of SpO2: Median of +/- one minute looks helpful
Not yet the "all singing" metric I seek, but a step in the right direction - definitely helpful in removing the clutter (would this be a helpful OSCAR feature?)...
While analysing my oximeter SpO2 data,
which is at "one sample every 4 seconds" resolution,
when exported as CSV from oximeter app O2 Insight,
and subsequently imported to a spreadsheet (LibreOffice Calc)...
I found that plotting a graph of the Median (not Average) over each (sliding) period of 2 minutes gave a much clearer picture of the main trends, e.g. the SpO2 troughs, and retained the original integer value-type, convenient for filtering
In practice I took the median 1 minute before to 1 minute after each timestamp, so as to avoid time/phase-shifting.
While analysing my oximeter SpO2 data,
which is at "one sample every 4 seconds" resolution,
when exported as CSV from oximeter app O2 Insight,
and subsequently imported to a spreadsheet (LibreOffice Calc)...
I found that plotting a graph of the Median (not Average) over each (sliding) period of 2 minutes gave a much clearer picture of the main trends, e.g. the SpO2 troughs, and retained the original integer value-type, convenient for filtering
In practice I took the median 1 minute before to 1 minute after each timestamp, so as to avoid time/phase-shifting.