Thread replies: 3
Thread images: 1
2016-01-16 10:15:11 Post No. 7787544
Post No. 7787544
I come to you today as a beggar. I need help reconciling some data in my head and I just can't seem to explain it to myself in a way that makes sense.
I'll see if greentexting can keep this succinct:
>Need weekly average of "units per hour"
>Create simple formula to calculate each day as though it was given 4 units of quarter-hour time (1 hour)
>Then average each day over a week, expecting an accurate average for the week
It was pointed out to me today, though, that the formula doesn't give accurate results when the times and "units" vary wildly from one day to the next. In my head though, I can't sort out the logic.
The formula supposes that each day receives one hour of time (4 units). Averaging each day evenly should then return the same result as the week's total units divided by the week's total time, but it doesn't. It's not even close in some cases.
I just can't wrap my head around how these numbers don't reconcile. I know I'm doing something wrong. I know the second result is accurate and the first is not; but in my head, they had ought to both be the same and I cannot figure out why they're different.
>This is for tracking some of my goals at work. It's unpaid, for my personal use only. I just like to have my numbers where I can keep an eye on them.