Reviewing my sleep with statistics

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.


Author: charuzu

I live in Sydney and interests include music, piano playing, technology, cooking, English language, public speaking, Toastmasters, Asian culture (especially Japan and Korea), cinema, personal development, productivity and making friends with people from around the world.

One thought on “Reviewing my sleep with statistics”

  1. This is very interesting, and kudos to you for keeping track of sleep… I was once asked to keep a sleep log and that didn’t work for long 😛

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s