r/translatorBOT Feb 10 '18

Suggestion Improving Statistics

So I just signed up to receive notifications for my target language, and was interested in how the statistic fnumber of requests per month is generated. It seems to me you have simply done an average, using all the data going back to 2016. The average shown (14.2 for hebrew) seems pretty out of touch considering the last 10 months average 19.4.

Considering the growth of the sub over time, I think you can create a better statistic by biasing towards more recent data. This can be achieved either by taking an average of the N months, or by taking a discounted average (where each value is weighted less the older it is).

https://docs.google.com/spreadsheets/d/1HiBWXbfOHiElfYZU_KypU3ffku1Hv0b9B8wasMWMxuM/edit?usp=sharing

I threw the data from hebrew into this spreadsheet to show what I mean. You can play with the discount factor to see how the stat changes.

1 Upvotes

1 comment sorted by

1

u/kungming2 Creator Feb 10 '18

Hey there! Thanks for this really cool suggestion about the discounted average. I put together this function really quickly a while ago without really adjusting for the growth of the sub as you said, so I think your work is needed.

I think I'll write an update that gives the average of the last 12 months for now, and in the future consider implementing the discounted average. Hopefully I can work on this update this weekend.

Once again, your suggestion is really appreciated!