25 YEARS of compiled yearbook statistics

by 88JM 62 Replies latest jw friends

  • 88JM
    88JM

    Hello again folks - as promised in my last thread here, I've been working on turning yearbook statistics into Excel spreadsheets.

    Coincidentally, today is my 25th birthday (spare a thought for a fader).

    I've now updated the spreadsheet with Yearbook data all the way back to 1988 (the year I was born), therefore it now contains 25 years of statistics.

    There were a lot of countries changing around and for some it was possible to create a continuation of data. Some are a simple change of name like South-West Africa to Namibia. Others, for example - in 1993 with Czechoslovakia splitting into two countries (Czech Republic and Slovakia) I have added an extra row that provides a continuation of the data, combining Czech Republic and Slovakia back together as if they were still one country. For other instances, this was not possible, especially around the U.S.S.R. and Yugoslavia - things got very complicated trying to "reconstruct" these, so I was not able to provide the same continuation of data. (If anyone else wants to have a go, feel free)

    As before, there are two files for download, the second being the more useful one to most of you.

    Yearbook Stats 1988 - 2012:

    MIRROR #1: http://depositfiles.com/files/zesphdl8z

    MIRROR #2: http://www.fileflyer.com/view/9xNJDBW

    MIRROR #3: http://www.fileswap.com/dl/9pP2uaHd8B/

    MIRROR #4: http://www.sendspace.com/file/2xz25a

    As before, the second .xls file has each statistic field in a separate tab with each year in a column, and is far more useful for year-by-year graphs etc. This time, I've also added a few additional sheets on the end, giving examples of the sorts of calculations that are possible with the data (e.g. Bible Studies per Publisher).

    Yearbook Stats by Field 1988- 2012:

    MIRROR #1: http://depositfiles.com/files/gnl9qtv7v

    MIRROR #2: http://www.fileflyer.com/view/9xNJDBW

    MIRROR #3: http://www.fileswap.com/dl/TdsKroPNKU/

    MIRROR #4: http://www.sendspace.com/file/y5j4hp

    I hope you find them useful. As before, if you do spot any errors, feel free to comment or PM me and I will update the files.

  • UnConfused
    UnConfused

    Thanks, I was just going through totals. The overall increase in '88 to '2012 has dropped from 6% to 2%

  • never a jw
    never a jw

    Thank you for all that work. I hope to see comments soon. I tried dowloading one file but never appeared in my folder of downloads. At this point I quit. I always fear those companies providing free services. Appreciate if someone can advice as to the safety of downloading files from these companies.

  • 88JM
    88JM

    I will add more alternative mirrors if that helps. Atlantis uses pretty much the same services to distribute his files, and I'm not aware of any problems reported there.

  • carla
    carla

    Thank you and Happy Birthday!

  • Marvin Shilmer
    Marvin Shilmer

    -

    88JM,

    Check your private messages.

    Marvin Shilmer

  • 88JM
    88JM

    Whoops - thanks Marvin - I knew I would forget to do something. Thanks for the reminder.

  • Mum
    Mum

    Happy Birthday!

  • slimboyfat
    slimboyfat

    That look like excellent work. I have always wanted to create a web page with Watchtower statistics displayed in charts and graphs. Is that something you might consider doing? Or would you mind if I used your data to help me do it?

  • slimboyfat
    slimboyfat

    It's just slightly a shame the data does not go back to pre-1975 because I have always been fascinated by the dip and recovery visible around the 1975 prophetic failure.

Share this

Google+
Pinterest
Reddit