Group activity data analysis

There has been some recent work analyzing the growth on drupal.org, and I think we should do something similar for groups.drupal.org.

I would be interested in charts/histograms showing the distribution of:

1. Groups by number of subscribers
2. Groups by posts/week in the past three months
3. Users by number of subscriptions (without identifying information)
4. Users by number of posts (without identifying information)
5. Users by number of posts (without identifying information)
6. Total posts over time
7. Total posts per week over time
8. Total groups over time
9. New groups per week over time
10. Median subscriptions per user over time

Did I forget anything or should some of these be removed/tweaked? I am willing to generate the charts if someone can run the queries, and I can figure out the exact sql queries if needed.