Google Spreadsheet Post #1440
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Dec-15, 2013
question by Josiah Sprague (http://productforums.google.com/forum/?zx=2prcm5ppprxr#!mydiscussions/docs/wBleMdlhsWM)
Formula for calculating a running average of streak length
I'm using Jerry Seinfeld's chain method to track habits that I want to change. I want to track my chains in a Spreadsheet and have a running average of my chain length. I want to be able to say something like, "On average, over the last six months, the length of my 'winning streaks' has gone up/down".
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Dec-15, 2013
question by Josiah Sprague (http://productforums.google.com/forum/?zx=2prcm5ppprxr#!mydiscussions/docs/wBleMdlhsWM)
Formula for calculating a running average of streak length
I'm using Jerry Seinfeld's chain method to track habits that I want to change. I want to track my chains in a Spreadsheet and have a running average of my chain length. I want to be able to say something like, "On average, over the last six months, the length of my 'winning streaks' has gone up/down".
I have a vague idea of how to set this up, but I am not quite there. I've got one column for date, another column for the current streak length on each day, and I'm trying to come up with a third column that will generate a running average of my streak lengths over a certain time period (say 6 months). Eventually I would like to graph this information too, so that I can see how my average streak length is changing on a daily basis. I'm at a loss for which formula to use, or perhaps I need to tweak my model a little bit to get the information I am looking for.
Any help would be greatly appreciated!
-----------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment