A Self-Tracking Challenge (draft)
This challenge requires some working knowledge of spreadsheets, and self-tracking. It’s also a work-in-progress and is very much open to feedback.
In a spreadsheet of some kind (Google Spreadsheet, Excel, Numbers, etc) rate every day subjectively on a scale between 1 and 3.
1 = exceptionally bad day
3 = exceptionally good day
2 = all other days
Then, come up with a “fitness function” based on objective data (nothing subjective like mood) that is mathematically correlated with the subjective rating over time. Say, over a month or two of data.
In other words, find out what, if any, things that are externally measurable have an effect on your subjective experience of life. Using math.
Use =CORREL(subjective column, objective column) in most spreadsheets to get a number between -1 and 1 that states whether or not the two sets of numbers are correlated. -1 means they are inversely...
Continue reading →