How to replicate SleepCycle?

Hey all. I like SleepCycle’s sleep notes function and I’m wondering how to create that in a spreadsheet tracking pain levels (I’m using Google Sheets).

Every night before I go to bed, I select a handful of “factors” from the sleep notes list. For instance, if it’s a cold night, I select “Cold Night”. If I worked out that day, I select “Worked Out”.

This is a way of getting data about the correlation between presence/absence of these factors and overall sleep quality.

Here are some examples of how the data is interpreted (sorry - Google Drive won’t rotate them):

So, basically I want a spreadsheet that correlates whether I did certain things in a day to percent increase or decrease in pain levels. I want to be able to display a graph of overall pain levels and various factors effect on those levels.

I know how to create the sheets, but I don’t know how to do the math. Any ideas on what the math is behind the sleep notes function on SleepCycle and how to replicate it in a spreadsheet?

Thanks in advance!

Sounds like you want to run a linear regression on the data. I can’t find a way to do with native Google Sheets functions, but you can with Excel:

If you have the time or inclination, I recommend R for statistical analysis, but it takes programming knowledge.

The Measured Me blog has a step by step tutorial that shows how to compare two conditions in Excel.

If you import your SleepCycle data into Zenobase, you can do similar comparisons as shown in this screencast (with different data).