h2g2 The Hitchhiker's Guide to the Galaxy: Earth Edition

Hmmm, maybe I need my eyes testing...

I'll fix it in tomorrow's update. If anyone want to help data collection by emailing me timestamped copies of the 'Who's Online' window between midnight and 6am GMT I'd be grateful as site policy dictates that my internet connection is offline then (). My email address is on my userpage.

s/Te\ y/The\ y

Ah, yes it begins to make sense now, as much as rows of numbers ever make sense. Thank you.

I've just posted an updated graph and updated results. Having upgraded by database system to Postgresql 7.1 from 6.5, I rewrote the queries to use the built in standard deviation function and so I've reworked the output slightly, hope its readable.

http://www.bbc.co.uk/h2g2/guide/A672554

Forgot to document what the new stuff means:
The top table is now sorted by stdev to try and help show how the nhm group has the lowest.

The bottom table not only displays the p and r values instead of the more complicated friends and active columns. r and p are simply the averages columns from the first two tables. The total active researchers is calculated as r / p. The average number of hours is from (active * 24 * 7) / total) where active is the total number of active researchers.

Here's a new statistic. Since I've now collected data for a few days, I did a query on the total number of distinct userids seen (that were not new this week), and found that 1074 distinct users. Plus looking at the latest graph, there has been quite a sharp drop off in users in the past few days. (Data will be posted later)

Dang holidays must be interfering with your research.

I've just updated the stats, including the graph, which shows the big Christmas drop off in users.

I think I've got enough data now, so I'm going to get the stats together this weekend. I hope there's still some people interested?

I am, as long as you provide a translation into plain English.

I don't think statistics can be described in plain English. They are mutually exclusive.
And I'm still interested.

Put it all together and send it to Shazz for the post I think

Yes, it would make a good Post article. And it's free advertising for the Natural History Museum.

Great Idea! A Post article. Perhaps I could also write an edited guide article about the stats. behind this?

Hasn't Mark already done that?

I don't know, I just pop over and ask.

I saw you asked and thought that you might like to read F432?thread=164103

I'm posting there right now, I think that Mark already know about this, but I not really sure Jim does.

I never did get round to writing that article did I?

Unfortunately I don't really have copies of the original data anymore (or the database views I used), so in reviving this I'm going to write some new software which is more efficient in space and time, and is built around my new 'Hoobot' architecture.

Stay tuned, and I might just write an article.

spelugx -- voting this his most ignore article

Hoobot! I love it! A semiological twist on a semiological twist.