LibriVox Average Age Survey

Everything except LibriVox (yes, this is where knitting gets discussed. Now includes non-LV Volunteers Wanted projects)
Petra
Posts: 350
Joined: July 14th, 2008, 1:33 pm
Location: Sweden

Post by Petra » May 20th, 2012, 1:49 am

Hello everyone!

A few days ago, a topic in the Suggestions forum brought up the question of the demographics of the LibriVox volunteer pool. I jumped at the chance to create some spreadsheet magic, and worked out the LibriVox Average Age Spreadsheet, to which someone kindly added boxes that show the minimum, maximum and median ages of the entered dates as well.

I would love it if anyone who wants to goes in and adds their age. I've tried to make the process as simple and safe as possible, but please do not feel pressured to enter yourself in the spreadsheet if you feel the slightest bit uncomfortable with it. We are NOT collecting actual birthday dates and we are NOT collecting the names of those who want their age to be counted.


There is a brief explanation of how the calculations work at the top of the document, but I shall explain it more thoroughly here:
- First go to column C (pink) and enter the first of January of the year you were born in the form 1/1/YYYY. This is for anonymity and safety reasons.
- Then go to column D (green) and select the box immediately above the line you just entered your own birth year in. Click on the little square in the lower right hand corner and drag it down. This copies a formula that calculates your approximate age. Please DO NOT change any numbers because they are different to your current age! This spreadsheet will update automatically every year which means that until it's your birthday, the age shown WILL be wrong. We don't care about this because we only want a general idea.
- You do not need to do anything more than these two steps. Column B automatically takes the age from the "number cruncher" in column D.
- The sum of the numbers in column B is calculated in the "Total age" box at the top. This is then divided by the number of entries, which is calculated from column C. This average is shown in the big yellow box at the top.
- Some awesome volunteer has added functions that find the minimum, maximum and median ages entered. This information can be found next to the yellow box at the top.


I will be maintaining this spreadsheet for a while at least, making sure that everything is entered correctly and works reasonably smoothly. (And of course eagerly checking the average age!)


Questions and comments are welcome in this thread. Again, please note that we are not forcing anybody to take part in this, and that we are not wanting to know each volunteer's age in particular. It's meant as a fun thing for those of us who are interested in statistics. :D

annise
LibriVox Admin Team
Posts: 31609
Joined: April 3rd, 2008, 3:55 am
Location: Melbourne,Australia

Post by annise » May 20th, 2012, 3:36 am

I stickied it so it would stay near the top - if you want it de stickied just say

kayray
LibriVox Admin Team
Posts: 11848
Joined: September 26th, 2005, 9:10 am
Location: Union City, California
Contact:

Post by kayray » May 20th, 2012, 11:03 am

Very cool :)
Kara
http://kayray.org/
--------
"Mary wished to say something very sensible into her Zoom H2 Handy Recorder, but knew not how." -- Jane Austen (& Kara)

jollyrogered
Posts: 701
Joined: March 25th, 2007, 10:39 pm
Location: Nebraska

Post by jollyrogered » May 21st, 2012, 10:46 am

Just entered.

This reminds me, didnt we use to have a map where we pinned ourselves? Is that still floating around?
duck... duck... ZOMBIE!

aradlaw
LibriVox Admin Team
Posts: 13726
Joined: July 14th, 2008, 4:54 pm
Location: Nottawasaga Bay, Ontario
Contact:

Post by aradlaw » May 21st, 2012, 11:17 am

Neat concept Petra, but I can't seem to follow simple instructions. :roll:
David Lawrence

* Weekly & Fortnightly Poetry - Check out the Short Works forum for the latest projects!

Petra
Posts: 350
Joined: July 14th, 2008, 1:33 pm
Location: Sweden

Post by Petra » May 21st, 2012, 11:38 am

Thanks. :) And that's okay - I'm checking in regularly to see if everything's working, and it's easy for me to fix stuff (since I know how the system works, having designed it and all ;) ).

Cori
LibriVox Admin Team
Posts: 12150
Joined: November 22nd, 2005, 10:22 am
Location: Britain
Contact:

Post by Cori » May 21st, 2012, 11:51 am

jollyrogered wrote:This reminds me, didnt we use to have a map where we pinned ourselves? Is that still floating around?
We did, but it stopped working a year or two back. Before that it worked badly for some years, but then the entire service was withdrawn by whoever provided it, IIRC. And, as Anne noted elsewhere, it was mostly newcomers who added themselves, often as their only activity here, so it wasn't super-representative of regulars. :D
There's honestly no such thing as a stupid question -- but I'm afraid I can't rule out giving a stupid answer : : To Posterity and Beyond!

J_N
Posts: 2529
Joined: July 14th, 2010, 12:32 pm
Location: Austria (no kangaroos ;))
Contact:

Post by J_N » May 25th, 2012, 11:07 am

interesting... added mine :)

on a side note: the youngest librivoxers are probably the children reading for Heidi in the Drama section (somewhere below 10 years)... I think it's great that this project spans so many generations :9:
Julia - Introverts, unite! Seperately... in your own homes.

Spend your free time the way you like, not the way you think you're supposed to. ― Susan Cain

Author death +70 yrs? Legamus!

Kikisaulite
LibriVox Admin Team
Posts: 5520
Joined: December 18th, 2006, 9:48 am
Location: Riga, Latvia.

Post by Kikisaulite » May 27th, 2012, 4:56 am

Interesting! Added mine and it made the average age drop half a year. :lol:
Keep your mind here and now, where it belongs.

knotyouraveragejo
LibriVox Admin Team
Posts: 15245
Joined: November 18th, 2006, 4:37 pm
Location: Pennsylvania

Post by knotyouraveragejo » May 27th, 2012, 9:39 am

Somehow I don't think we have two people who are 113.... :lol:
Jo
My Librivox Solos
Books are the carriers of civilization. Without books, history is silent, literature dumb, science crippled, thought and speculation at a standstill. - Barbara Tuchman

Petra
Posts: 350
Joined: July 14th, 2008, 1:33 pm
Location: Sweden

Post by Petra » May 27th, 2012, 11:21 am

knotyouraveragejo wrote:Somehow I don't think we have two people who are 113.... :lol:
That is why we need to list a specific date, and not just a year (e.g. 1/1/1999 instead of just 1999). I haven't figured out why, but with the formula as it is, it does something weird if only the year is entered. I bet it's logical (yay maths) but it's beyond me. ;)

J_N
Posts: 2529
Joined: July 14th, 2010, 12:32 pm
Location: Austria (no kangaroos ;))
Contact:

Post by J_N » May 27th, 2012, 11:44 am

if no date is entered at all "Excel" (or whatever it's called in google) assumes the year to be 1900 (no idea why) which results in 113

Edit: no... wait... that should result in 112... hm... now I am confused... :hmm:

Edit2: ok... that's what excel does (assume 1900) which results in 112... so apparently google assumes 1899... :)
Julia - Introverts, unite! Seperately... in your own homes.

Spend your free time the way you like, not the way you think you're supposed to. ― Susan Cain

Author death +70 yrs? Legamus!

catchpenny
Posts: 1026
Joined: October 28th, 2007, 10:20 pm
Location: The here and now

Post by catchpenny » June 4th, 2012, 9:42 pm

I think I broke it.
Anyone can read accurately. [i]I[/i] read with great expression.

Petra
Posts: 350
Joined: July 14th, 2008, 1:33 pm
Location: Sweden

Post by Petra » June 4th, 2012, 11:48 pm

Yes. ;) Luckily it's not expensive china or anything, so it's easily fixable. I've got it up and running again already. And thank you for telling me! It might have been a while until I noticed otherwise.

catrose
Posts: 3004
Joined: April 13th, 2012, 2:29 pm
Location: Narnia! No wait...That's not PD...
Contact:

Post by catrose » June 30th, 2012, 1:31 pm

Just incase anyone think's I've done this wrong, lines 80 and 81 do have the same year of birth/age. I can't tell you who the other one is (confidentiality) , but if you look at my profile, you can tell that I'm the first one :)
Cat
charlotteduckett.com

A Level exams from 4th May to 30th June. I am around, just not as often. If I forget or miss anything, drop me a PM and I'll be on it like a wasp on honey!

Post Reply