Since December last year, I have been recording the time I go to bed and the time I wake up.

I use the Taplog application on my Android phone to capture this data, then transfer to a database on my computer.

I have been capturing the information to determine how much sleep I need, as part of a bigger “Measured Life” project.

I made some graphs using Microsoft Excel 2007 to get an overview of wake up and sleep times as well as the number of hours sleep.

What did I observe?

The Graphs

Click on the image below to view full size.

The blue line. My wake up time has an average of 6.00am with a standard deviation of 36 minutes. I usually get up at 6:00 on weekdays but earlier on Tuesday morning for a Toastmasters meeting. I don’t normally use an alarm clock on the weekend, but I do tend to sleep for around 8 hours as a catch up rest. I am usually out of bed by 7.30.

The red line. My sleep time has an average of 11.04pm with standard deviation of 32 minutes. I realise that my idea l sleep time is 7.5 hours requiring going to bed by 10.30, but I usually stay up after 11pm. When this happens I am tired the next night so I have an earlier night. My goal is to establish an early sleep routine.

The green line. My average daily sleep is 6 hours 56 minutes (close enough to 7 hours) with standard deviation of 48 minutes.  The amount of sleep varies and I need to get more sleep for clearer thinking and better health.

I made another version of the graph in a vertical format.

What’s next?

I want to track the quality of sleep, so I will record a rating for the previous night’s  sleep.  I was thinking that the best time to assess this would be mid morning.     Another possibility is to capture a rating of how tired I feel at several times during the day.

I find the graphics very restricted in Excel, so I am learning to use the open source R statistics package. More information is available on the web site for R statistics . I am learning from the book R in Action by Robert Kabacoff and published my Manning.

Yes, I am a statistics nerd!

Previous articles of mine about sleep and the measured life.