11 years of compiled yearbook statistics: spreadsheet downloads

by 88JM 25 Replies latest jw friends

  • wezz
    wezz

    Is it just me, or are the numbers identical for 2002 and 2004(yearbook stats by field 2002-2012)?

  • besty
    besty

    looks like a good research resource - maybe email them to the admins of the various ex-jw websites with a covering article and get them circulated that way as well

  • TheOldHippie
    TheOldHippie

    Comoros

    Check with the number of countries where there are restriction; a Moslem country with not-too-gentle attitude towards other faiths

    Montenegro -

    Comes from former Yugoslavia, but from 2003 to 2006 it was part of the union of Serbia and Montenegro.

    South Sudan -

    Comes from Sudan – obviously.

    Tajikistan -

    Check with the number of countries where there are restriction; a Moslem country with not-too-gentle attitude towards other faiths

    Timor-Leste

    Comes either from Timor or from Indonesia, check if the said figures go down coeespondingly.

    Yugoslavia, F. R.

    Divided into Bosnia and Hercegovina, Croatia, Macedonia, Montenegro, Serbia, Slovenia, Kosovo

    - removed in 2002
    - introduced in 2012
    removed in 2007
    introduced in 2012
    introduced in 2007
    - removed in 2004

  • 88JM
    88JM

    Thanks TheOldHippie - I forgot the number of "other lands" changes - that might be the answer to many of these.

    besty - thanks for the advice - will perhaps look at that when I've added more years and it's been through a few "error checking" cycles.

    Cheers also wezz - files in the first post have been corrected and updated:

    Yearbook Stats 2002 - 2012:

    http://depositfiles.com/files/t4xhx9n5l

    MIRROR: http://www.fileflyer.com/view/J2XhWAb

    Yearbook Stats by Field 2002 - 2012:

    http://depositfiles.com/files/aj02x7lej

    MIRROR: http://www.fileflyer.com/view/J2XhWAb

    Also, just to clarify, does everyone understand the reasons for this? The main reason as I see it, is that it allows you to very quickly create graphs to compare complex data and multiple fields. For instance, with a few clicks in Excel, you can now create graphs like the one below. (also you start to notice weird things like the peak for Chile in 2012 was lower than the average?!?!)

  • jwfacts
    jwfacts

    Great work. I hope you don't mind if I load the file onto jwfacts.com

  • 88JM
    88JM

    By all means Paul - your site was certainly in mind while I was putting this together.

    I will also try and keep the raw scans as I go, which might be added to your historical data page:

    http://www.jwfacts.com/watchtower/statistics-historical-data.php

    Stay tuned in the coming weeks for more - I'm working my way back through the yearbooks.

  • slimboyfat
    slimboyfat

    This used to be a good site for JW statistics, but has apparently been abandoned.

    http://www.jwic.info/stat.htm

    I have always found statistics really interesting too and intended to build some sort of website presenting them but I never got round to it!

  • jwfacts
    jwfacts

    That is good. Let me know when it is done so I can work out a logical way to present the information for download.

  • jwfacts
    jwfacts

    SBF, that was the first site I found when looking for Watchtower stats years ago.

    The tough part is updating all the graphs every year, especially as each chart needs to have the data source updated, the chart saved as a replacement image, the image reloaded and then resized and added again to the page.

    If anyone can work out a way to reduce the amount of work, I am all ears. I have tried using google docs, which is free and allows live interactive graphs. However, I cannot work out how to control the charts very well, such as specifying y and x axis from large tables.

  • wha happened?
    wha happened?

    Funny, in the USA, there was an increase of 10k+ pubs from 2011 to 2012. Yet, there were 32k baptized. So where did 22k go? I know that pubs are counted from the day they start turning in time, but you just can't account for this yearly differance

Share this

Google+
Pinterest
Reddit