Author Topic: Daily History: Average.Total  (Read 1566 times)

Lucubrate

  • Guest
Daily History: Average.Total
« on: March 16, 2006, 02:24:22 PM »
Just curious...
I notice the Average.Total cell in the Daily History table indicates a total of the daily averages. Did you consider filling this cell with an Average of the Totals instead? If so, why choose one over the other? I haven't put a lot of thought into it, but my first thought would be that an average of the totals is more interesting than a total of the averages.

BTW, thanks for the site, it is a nice resource!

Offline Kakao

  • Administrator
  • Regular
  • *****
  • Posts: 201
    • Facebook
Daily History: Average.Total
« Reply #1 on: March 17, 2006, 12:47:15 AM »
Although the script sums the daily averages, as you also did, it also means what you want, the average of the totals.  :shock:

I will try to explain. If you sum the week totals and divide by the number of weeks you will not have the average of the totals since the first and last weeks are not complete, or better, they are only complete on the last Sunday update.

But if you sum the daily points average you will have full weeks since the not existing days are not summed and so the sum of the averages is a much better average of the totals than if i summed the totals and divided by the number of weeks.

Confused? I was the first time i tried to solve it and i was thinking about an algorithm a bit more complex until i realized it was already solved.

Sorry if i can't be clearer. Thanks for pointing that out.
Every criticism or suggestion from the user is a gift. Even if i disagree or don't answer. Obviously if there is real intellectual work on producing it the better.