User:Renklauf/Archive 1

Thursday, January 19th

Beginning analyses on edit count metrics from "Huggle 3" Tests. The first approach will be to use hypothesis testing among control and test templates.

Google Doc for template testing

The first template instances that I'm investigating are the z60/z61 pair -- hmmm, there is no data for z60. check postings

Postings and Edit Counts

RECIPIENT, TIME OF TEMPLATE, REVISION ID, POSTER ID, POSTER NAME, TEMPLATE 199.230.37.246 20111018193131 456234600 136926 Velella {{z61}} 69.62.29.111 20111018201225 456240750 136926 Velella {{z61}} Jakester717 20111019003906 456276438 15124901 Cncplayer {{z61}} 82.203.3.11 20111019134426 456349865 3121940 Al.locke {{z61}} 70.19.65.13 20111019214006 456422133 10808929 Tbhotch {{z61}} 187.104.226.244 20111019215024 456423586 10808929 Tbhotch {{z61}} 189.152.174.13 20111019215653 456424559 3683078 Falcon8765 {{z61}} 84.185.100.194 20111020064508 456477079 12865411 Orange Suede Sofa {{z61}} 49.249.80.231 20111020065209 456477620 12865411 Orange Suede Sofa {{z61}} 67.255.0.179 20111021011020 456608813 352579 Wknight94 {{z61}} 203.116.31.108 20111021063712 456639937 8786164 Shadowjams {{z61}} 180.191.91.82 20111021063821 456640032 8786164 Shadowjams {{z61}} 203.99.214.79 20111021190802 456719690 136926 Velella {{z61}} 205.154.237.154 20111021190846 456719795 136926 Velella {{z61}} 71.61.7.99 20111021203320 456731668 136926 Velella {{z61}} 70.67.172.14 20111021214252 456740545 3683078 Falcon8765 {{z61}} 202.36.179.68 20111022064649 456791356 11987994 My76Strat {{z61}} 122.52.217.188 20111022162658 456846953 10397226 ItsZippy {{z61}} Azhartokyo 20111022170935 456852606 12846626 Puffin {{z61}} 94.97.89.71 20111022193616 456872389 749357 ArglebargleIV {{z61}} 72.193.120.15 20111022200238 456875870 136926 Velella {{z61}} 72.25.19.10 20111022203834 456880886 136926 Velella {{z61}} 70.71.111.148 20111022203919 456881002 136926 Velella {{z61}} 137.44.1.174 20111023011208 456914636 947350 TwistOfCain {{z61}} 108.76.112.151 20111023011428 456914845 947350 TwistOfCain {{z61}} 49.244.134.233 20111023141452 456983450 12846626 Puffin {{z61}} 81.102.144.18 20111023141719 456983773 12846626 Puffin {{z61}} 69.209.67.233 20111023194040 457029048 10397226 ItsZippy {{z61}} 71.244.58.175 20111023223551 457055612 136926 Velella {{z61}} 71.95.145.0 20111023223700 457055769 136926 Velella {{z61}} 202.177.218.51 20111024060112 457102731 6336020 Skarebo {{z61}} 203.189.188.161 20111024071820 457108446 11667930 Sp33dyphil {{z61}} 94.18.35.11 20111024072205 457108700 11667930 Sp33dyphil {{z61}} 117.242.56.104 20111024112550 457130980 3834462 Logan {{z61}} 89.211.148.181 20111024144050 457152939 3790390 Monty845 {{z61}} 216.73.70.5 20111024144557 457153667 3790390 Monty845 {{z61}} 2.138.160.187 20111024155424 457163720 10397226 ItsZippy {{z61}} 108.46.174.124 20111024203446 457207107 12944735 Jcaraballo {{z61}} 108.58.40.242 20111024203759 457207673 12944735 Jcaraballo {{z61}} 164.76.106.219 20111024204212 457208313 12944735 Jcaraballo {{z61}} 90.192.89.162 20111024210928 457212638 2552569 It Is Me Here {{z61}} 65.86.196.222 20111025160135 457335594 14375804 Calabe1992 {{z61}} 86.40.50.115 20111025163408 457339995 14995935 AwamerT {{z61}} 75.104.128.37 20111025193745 457367502 136926 Velella {{z61}} 24.127.57.90 20111025193758 457367536 136926 Velella {{z61}} 90.211.66.95 20111026130448 457479809 14194543 Oddbodz {{z61}} 41.238.214.57 20111026132512 457482580 14375804 Calabe1992 {{z61}} 213.200.92.214 20111026193834 457537858 100426 Smalljim {{z61}} Jaddmills 20111026195122 457540160 352579 Wknight94 {{z61}} 59.191.203.40 20111027073151 457619851 6680277 Thomas888b {{z61}} 62.251.84.242 20111027073433 457620103 6680277 Thomas888b {{z61}} 27.56.41.76 20111027115605 457642877 14194543 Oddbodz {{z61}} 194.60.75.2 20111027120506 457643736 14194543 Oddbodz {{z61}} 71.77.43.140 20111027173156 457687974 215875 Crazynas {{z61}} 117.203.240.128 20111027181555 457694599 262666 DVdm {{z61}} 96.54.66.43 20111027200719 457711540 14375804 Calabe1992 {{z61}} 178.106.61.201 20111027225016 457733785 1453997 Kubigula {{z61}} IAmTheWalrus89460 20111028062203 457777432 11667930 Sp33dyphil {{z61}} 157.233.16.122 20111028211527 457879833 5499713 Excirial {{z61}} 76.92.165.89 20111028223046 457889548 136926 Velella {{z61}} 122.59.170.33 20111029010638 457905198 9128566 Ace of Spades {{z61}} 75.87.238.75 20111029063425 457934386 5839083 Mikaey {{z61}} 188.134.34.18 20111029072023 457937772 5839083 Mikaey {{z61}} 124.170.118.177 20111029072432 457938037 5839083 Mikaey {{z61}} 202.172.246.17 20111029072728 457938217 5839083 Mikaey {{z61}} 113.210.97.178 20111029090012 457944859 100426 Smalljim {{z61}} 61.17.230.9 20111029091604 457946174 100426 Smalljim {{z61}} 81.153.111.201 20111029092926 457947255 100426 Smalljim {{z61}} 77.194.87.84 20111029114736 457959240 14836860 Cyberpower678 {{z61}} 115.242.67.145 20111029162720 457988874 1453997 Kubigula {{z61}} 78.150.238.246 20111031002058 458216514 11557355 RA0808 {{z61}} 69.149.80.193 20111031031138 458237425 3080493 Jeff G. {{z61}} 194.81.239.148 20111031143720 458301882 2389084 Trusilver {{z61}} 142.110.19.237 20111031182021 458334472 3790390 Monty845 {{z61}} 173.70.20.245 20111031194204 458346459 11557355 RA0808 {{z61}} 50.93.52.64 20111031223338 458371001 136926 Velella {{z61}} 69.47.43.217 20111031223744 458371503 136926 Velella {{z61}} 99.255.242.254 20111031225403 458373560 215875 Crazynas {{z61}} 98.160.206.108 20111101021454 458395899 2389084 Trusilver {{z61}} 24.29.210.59 20111101022552 458397106 2389084 Trusilver {{z61}} 124.169.154.182 20111101031552 458401806 14995935 AwamerT {{z61}} 50.10.0.178 20111101033610 458403703 6284 Ixfd64 {{z61}} 96.20.18.145 20111101034534 458404604 14995935 AwamerT {{z61}} 60.53.125.143 20111101061111 458417957 1195998 Funnyfarmofdoom {{z61}} 69.209.35.53 20111101063007 458419647 1195998 Funnyfarmofdoom {{z61}} 31.97.147.107 20111101202842 458519601 2389084 Trusilver {{z61}} 96.255.208.45 20111101203156 458520174 2389084 Trusilver {{z61}} 68.42.35.130 20111101211010 458526803 14001956 WikiPuppies {{z61}} 78.149.195.85 20111101211141 458527032 14001956 WikiPuppies {{z61}} 74.195.196.245 20111103003733 458732631 2359527 Tgeairn {{z61}} 61.8.5.238 20111103005830 458735205 2359527 Tgeairn {{z61}} 80.247.22.113 20111103172401 458837894 377389 Josh3580 {{z61}} 168.254.225.250 20111103175844 458843080 377389 Josh3580 {{z61}} 86.161.237.255 20111103192728 458856347 14194543 Oddbodz {{z61}} 69.47.111.74 20111104013504 458906228 2359527 Tgeairn {{z61}} Feugb 20111104081820 458940432 6898026 Cst17 {{z61}} 77.29.84.137 20111104100947 458949008 136926 Velella {{z61}} 99.250.144.220 20111104200309 459024127 136926 Velella {{z61}} 110.224.233.225 20111104200758 459024995 136926 Velella {{z61}} 207.55.63.3 20111104204228 459030503 14194543 Oddbodz {{z61}} 65.24.226.2 20111104224235 459049059 14001956 WikiPuppies {{z61}} 71.137.238.192 20111104231258 459053563 14194543 Oddbodz {{z61}} 98.245.83.23 20111105001528 459061478 2966869 Funandtrvl {{z61}} 67.235.6.122 20111105183738 459172903 136926 Velella {{z61}} 212.10.229.33 20111105190552 459177518 749357 ArglebargleIV {{z61}} 118.93.84.184 20111105201413 459187761 136926 Velella {{z61}} 86.166.246.8 20111105201430 459187815 136926 Velella {{z61}} 70.15.146.144 20111105215151 459201296 14194543 Oddbodz {{z61}} 71.110.143.87 20111106015431 459231964 7792240 TParis {{z61}} 96.29.168.111 20111106020104 459232759 7792240 TParis {{z61}} 96.252.206.96 20111106062602 459255988 8786164 Shadowjams {{z61}} 81.135.55.5 20111107000034 459374668 2359527 Tgeairn {{z61}} Socailzzz 20111107002928 459378529 2359527 Tgeairn {{z61}} 24.99.74.222 20111107003956 459379886 2359527 Tgeairn {{z61}} Ineedtoeditthisarticle 20111107004251 459380201 2359527 Tgeairn {{z61}} Britannic124 20111107021912 459392038 2359527 Tgeairn {{z61}} 68.198.4.141 20111107025856 459396736 2359527 Tgeairn {{z61}} 27.33.36.120 20111107050155 459409068 205121 Koavf {{z61}} 173.248.14.26 20111107172032 459483365 2359527 Tgeairn {{z61}} 24.67.98.191 20111107173026 459484890 4968133 GorillaWarfare {{z61}} 216.73.72.138 20111107173241 459485235 4968133 GorillaWarfare {{z61}} 67.233.123.232 20111108001851 459546424 2359527 Tgeairn {{z61}} 50.131.27.18 20111108002729 459547843 2359527 Tgeairn {{z61}} 68.118.71.97 20111108011922 459555407 14995935 AwamerT {{z61}} 81.153.64.159 20111108164558 459651277 6849511 Fluffernutter {{z61}} 59.97.0.29 20111108170720 459654364 6849511 Fluffernutter {{z61}} 204.57.107.246 20111108195922 459680386 136926 Velella {{z61}} 71.228.93.75 20111108215825 459699559 7480926 QueenCake {{z61}} 71.237.179.147 20111109214512 459865793 7480926 QueenCake {{z61}} 101.172.91.246 20111110072109 459934614 12716348 Mayur {{z61}} 188.169.236.176 20111110170753 459993070 14995935 AwamerT {{z61}} 178.152.88.53 20111110182726 460004123 14995935 AwamerT {{z61}} 74.133.64.236 20111111025236 460072495 11557355 RA0808 {{z61}} 24.72.176.240 20111111064427 460093801 12716348 Mayur {{z61}} 68.36.183.212 20111111192833 460173575 136926 Velella {{z61}} 84.248.10.90 20111111200039 460178356 3080493 Jeff G. {{z61}} 34.254.247.221 20111111225228 460201701 11557355 RA0808 {{z61}} 174.55.156.119 20111112013428 460221616 11667930 Sp33dyphil {{z61}} 74.80.15.1 20111112014206 460222472 11667930 Sp33dyphil {{z61}} 210.56.121.201 20111112043420 460240860 3834462 Logan {{z61}} 101.2.17.53 20111112081657 460259046 4961632 NickCT {{z61}} 14.98.44.93 20111112083348 460260311 4961632 NickCT {{z61}} 82.17.39.62 20111112163908 460306936 7480926 QueenCake {{z61}} 71.99.15.7 20111112173622 460314059 2359527 Tgeairn {{z61}} 90.211.152.114 20111112210902 460340937 12846626 Puffin {{z61}} 109.145.81.132 20111112210941 460341013 12846626 Puffin {{z61}} 74.96.73.153 20111112213810 460344551 2879160 Doctoroxenbriery {{z61}} 71.229.93.182 20111113030353 460382844 232053 Windchaser {{z61}} 24.62.194.0 20111113030429 460382917 232053 Windchaser {{z61}} 96.10.117.142 20111113030746 460383356 232053 Windchaser {{z61}} 122.162.17.167 20111113033040 460385751 232053 Windchaser {{z61}} 113.193.78.159 20111113034141 460386752 232053 Windchaser {{z61}} 68.59.68.221 20111113041318 460390058 232053 Windchaser {{z61}} 76.195.139.99 20111113051110 460395811 2359527 Tgeairn {{z61}} 121.221.74.196 20111113070039 460405373 2359527 Tgeairn {{z61}} 121.221.216.97 20111113070457 460405740 2359527 Tgeairn {{z61}} 86.21.160.84 20111113163514 460459332 262666 DVdm {{z61}} 86.156.136.104 20111113181159 460472891 10397226 ItsZippy {{z61}} 76.93.135.40 20111113193912 460485504 12846626 Puffin {{z61}} 99.225.242.33 20111113193924 460485523 12846626 Puffin {{z61}} 76.175.178.122 20111113193944 460485568 12846626 Puffin {{z61}} 209.6.243.76 20111113203543 460493313 749357 ArglebargleIV {{z61}} 76.249.27.205 20111114035320 460552899 3080493 Jeff G. {{z61}} 27.56.48.63 20111114051210 460561053 14375804 Calabe1992 {{z61}} 182.182.22.91 20111114152838 460619777 749357 ArglebargleIV {{z61}} 70.90.193.180 20111114190254 460650772 12846626 Puffin {{z61}} 76.24.133.217 20111114191458 460653074 12846626 Puffin {{z61}} 67.78.136.194 20111114192048 460654160 12846626 Puffin {{z61}} 59.161.139.118 20111114192300 460654512 12846626 Puffin {{z61}} 216.14.57.210 20111114192852 460655508 12846626 Puffin {{z61}} 59.92.23.233 20111114192923 460655605 12846626 Puffin {{z61}} 206.176.108.151 20111114204828 460668661 14001956 WikiPuppies {{z61}} 68.108.64.93 20111115003008 460699251 2359527 Tgeairn {{z61}} 75.73.36.186 20111115005117 460701818 2359527 Tgeairn {{z61}} 72.25.24.228 20111115011059 460704193 2359527 Tgeairn {{z61}} 76.4.250.194 20111115011307 460704465 2359527 Tgeairn {{z61}} 70.124.194.128 20111115014055 460707842 2359527 Tgeairn {{z61}} 24.171.129.214 20111115023242 460714070 2359527 Tgeairn {{z61}} 50.54.238.136 20111115033905 460721020 2359527 Tgeairn {{z61}} 184.3.195.3 20111115045453 460728902 2359527 Tgeairn {{z61}} 211.49.208.25 20111115104026 460758371 215875 Crazynas {{z61}} 115.108.105.158 20111115122416 460767453 3834462 Logan {{z61}} 125.21.153.160 20111115123059 460768116 136926 Velella {{z61}} 77.220.15.130 20111115124148 460769040 136926 Velella {{z61}} 64.83.202.227 20111115124407 460769268 136926 Velella {{z61}} 117.96.229.72 20111115144038 460782146 14001956 WikiPuppies {{z61}} 64.162.40.123 20111115180129 460810835 3121940 Al.locke {{z61}} 122.179.80.68 20111116063016 460907274 14375804 Calabe1992 {{z61}} 59.144.118.72 20111116065430 460909322 14375804 Calabe1992 {{z61}} 81.101.28.170 20111116132906 460942775 268609 Banaticus {{z61}} 201.239.62.83 20111116192215 460991321 12846626 Puffin {{z61}} 58.164.126.48 20111117065707 461075416 543390 JDCMAN {{z61}} 112.207.223.10 20111118104336 461258301 136926 Velella {{z61}} 117.239.133.130 20111118105031 461258858 136926 Velella {{z61}} 122.165.33.215 20111118115755 461264391 12716348 Mayur {{z61}} 207.235.167.118 20111118210757 461334223 14001956 WikiPuppies {{z61}} 68.5.29.190 20111118213524 461337896 14001956 WikiPuppies {{z61}} 24.106.214.146 20111118230438 461349491 2359527 Tgeairn {{z61}} METRICS - EDIT COUNT: recipient_name timestamp ns_0_revisions_before ns_0_revisions_after ns_0_revisions_deleted_before ns_0_revisions_deleted_after ns_3_revisions_before ns_3_revisions_after ns_3_revisions_deleted_before ns_3_revisions_deleted_after ns_30_revisions_before ns_30_revisions_after ns_30_revisions_deleted_before ns_30_revisions_deleted_after ns_60_revisions_before ns_60_revisions_after ns_60_revisions_deleted_before ns_60_revisions_deleted_after 199.230.37.246 20111018193131 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 69.62.29.111 20111018201225 118 9 1 0 0 0 0 0 0 0 0 0 0 0 0 0 Jakester717 20111019003906 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 82.203.3.11 20111019134426 106 31 0 0 3 1 0 0 0 0 0 0 0 0 0 0 70.19.65.13 20111019214006 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 187.104.226.244 20111019215024 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 189.152.174.13 20111019215653 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 84.185.100.194 20111020064508 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 49.249.80.231 20111020065209 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 67.255.0.179 20111021011020 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 203.116.31.108 20111021063712 5 9 0 0 0 0 0 0 0 0 0 0 0 0 0 0 180.191.91.82 20111021063821 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 203.99.214.79 20111021190802 195 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 205.154.237.154 20111021190846 18 7 0 0 0 0 0 0 0 0 0 0 0 0 0 0 71.61.7.99 20111021203320 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 70.67.172.14 20111021214252 15 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 202.36.179.68 20111022064649 89 12 0 0 1 0 0 0 0 0 0 0 0 0 0 0 122.52.217.188 20111022162658 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Azhartokyo 20111022170935 1 19 0 20 0 3 0 0 0 0 0 0 0 0 0 0 94.97.89.71 20111022193616 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 72.193.120.15 20111022200238 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 72.25.19.10 20111022203834 2 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 70.71.111.148 20111022203919 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 137.44.1.174 20111023011208 357 40 1 0 0 0 0 0 0 0 0 0 0 0 0 0 108.76.112.151 20111023011428 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 49.244.134.233 20111023141452 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 81.102.144.18 20111023141719 2 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 69.209.67.233 20111023194040 3 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 71.244.58.175 20111023223551 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 71.95.145.0 20111023223700 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 202.177.218.51 20111024060112 35 32 1 0 0 0 0 0 0 0 0 0 0 0 0 0 203.189.188.161 20111024071820 1 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 94.18.35.11 20111024072205 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 117.242.56.104 20111024112550 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 89.211.148.181 20111024144050 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 216.73.70.5 20111024144557 13 12 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2.138.160.187 20111024155424 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 108.46.174.124 20111024203446 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 108.58.40.242 20111024203759 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 164.76.106.219 20111024204212 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 90.192.89.162 20111024210928 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 65.86.196.222 20111025160135 223 0 4 0 2 0 0 0 0 0 0 0 0 0 0 0 86.40.50.115 20111025163408 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 75.104.128.37 20111025193745 215 3 2 0 0 0 0 0 0 0 0 0 0 0 0 0 24.127.57.90 20111025193758 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 90.211.66.95 20111026130448 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 41.238.214.57 20111026132512 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 213.200.92.214 20111026193834 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Jaddmills 20111026195122 15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 59.191.203.40 20111027073151 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 62.251.84.242 20111027073433 15 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 27.56.41.76 20111027115605 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 194.60.75.2 20111027120506 110 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 71.77.43.140 20111027173156 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 117.203.240.128 20111027181555 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 96.54.66.43 20111027200719 5 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 178.106.61.201 20111027225016 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 IAmTheWalrus89460 20111028062203 44 18 0 0 3 3 0 0 0 0 0 0 0 0 0 0 157.233.16.122 20111028211527 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 76.92.165.89 20111028223046 8 53 0 0 0 6 0 0 0 0 0 0 0 0 0 0 122.59.170.33 20111029010638 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 75.87.238.75 20111029063425 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 188.134.34.18 20111029072023 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 124.170.118.177 20111029072432 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 202.172.246.17 20111029072728 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 113.210.97.178 20111029090012 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 61.17.230.9 20111029091604 23 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 81.153.111.201 20111029092926 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 77.194.87.84 20111029114736 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 115.242.67.145 20111029162720 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 78.150.238.246 20111031002058 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 69.149.80.193 20111031031138 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 194.81.239.148 20111031143720 11 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 142.110.19.237 20111031182021 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 173.70.20.245 20111031194204 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 50.93.52.64 20111031223338 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 69.47.43.217 20111031223744 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 99.255.242.254 20111031225403 2 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 98.160.206.108 20111101021454 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 24.29.210.59 20111101022552 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 124.169.154.182 20111101031552 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 50.10.0.178 20111101033610 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 96.20.18.145 20111101034534 98 7 0 0 0 0 0 0 0 0 0 0 0 0 0 0 60.53.125.143 20111101061111 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 69.209.35.53 20111101063007 1 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 31.97.147.107 20111101202842 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 96.255.208.45 20111101203156 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 68.42.35.130 20111101211010 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 78.149.195.85 20111101211141 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 74.195.196.245 20111103003733 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 61.8.5.238 20111103005830 62 6 2 0 2 0 0 0 0 0 0 0 0 0 0 0 80.247.22.113 20111103172401 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 168.254.225.250 20111103175844 30 2 0 0 2 0 0 0 0 0 0 0 0 0 0 0 86.161.237.255 20111103192728 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 69.47.111.74 20111104013504 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Feugb 20111104081820 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 77.29.84.137 20111104100947 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 99.250.144.220 20111104200309 340 5 10 7 0 0 0 0 0 0 0 0 0 0 0 0 110.224.233.225 20111104200758 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 207.55.63.3 20111104204228 40 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 65.24.226.2 20111104224235 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 71.137.238.192 20111104231258 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 98.245.83.23 20111105001528 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 67.235.6.122 20111105183738 46 49 0 0 0 0 0 0 0 0 0 0 0 0 0 0 212.10.229.33 20111105190552 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 118.93.84.184 20111105201413 3 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 86.166.246.8 20111105201430 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 70.15.146.144 20111105215151 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 71.110.143.87 20111106015431 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 96.29.168.111 20111106020104 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 96.252.206.96 20111106062602 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 81.135.55.5 20111107000034 10 3 0 0 4 3 0 0 0 0 0 0 0 0 0 0 Socailzzz 20111107002928 18 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 24.99.74.222 20111107003956 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Ineedtoeditthisarticle 20111107004251 2 5 0 1 0 15 0 0 0 0 0 0 0 0 0 0 Britannic124 20111107021912 248 30 1 4 0 5 0 0 0 0 0 0 0 0 0 0 68.198.4.141 20111107025856 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 27.33.36.120 20111107050155 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 173.248.14.26 20111107172032 6 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 24.67.98.191 20111107173026 2 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 216.73.72.138 20111107173241 117 0 0 0 6 0 0 0 0 0 0 0 0 0 0 0 67.233.123.232 20111108001851 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 50.131.27.18 20111108002729 1 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 68.118.71.97 20111108011922 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 81.153.64.159 20111108164558 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 59.97.0.29 20111108170720 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 204.57.107.246 20111108195922 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 71.228.93.75 20111108215825 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 71.237.179.147 20111109214512 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 101.172.91.246 20111110072109 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 188.169.236.176 20111110170753 48 27 0 0 0 0 0 0 0 0 0 0 0 0 0 0 178.152.88.53 20111110182726 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 74.133.64.236 20111111025236 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 24.72.176.240 20111111064427 33 51 0 0 10 1 0 0 0 0 0 0 0 0 0 0 68.36.183.212 20111111192833 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 84.248.10.90 20111111200039 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 34.254.247.221 20111111225228 91 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 174.55.156.119 20111112013428 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 74.80.15.1 20111112014206 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 210.56.121.201 20111112043420 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 101.2.17.53 20111112081657 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 14.98.44.93 20111112083348 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 82.17.39.62 20111112163908 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 71.99.15.7 20111112173622 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 90.211.152.114 20111112210902 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 109.145.81.132 20111112210941 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 74.96.73.153 20111112213810 6 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 71.229.93.182 20111113030353 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 24.62.194.0 20111113030429 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 96.10.117.142 20111113030746 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 122.162.17.167 20111113033040 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 113.193.78.159 20111113034141 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 68.59.68.221 20111113041318 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 76.195.139.99 20111113051110 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 121.221.74.196 20111113070039 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 121.221.216.97 20111113070457 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 86.21.160.84 20111113163514 13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 86.156.136.104 20111113181159 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 76.93.135.40 20111113193912 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 99.225.242.33 20111113193924 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 76.175.178.122 20111113193944 0 0 25 45 0 0 0 0 0 0 0 0 0 0 0 0 209.6.243.76 20111113203543 2 13 0 0 0 0 0 0 0 0 0 0 0 0 0 0 76.249.27.205 20111114035320 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 27.56.48.63 20111114051210 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 182.182.22.91 20111114152838 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 70.90.193.180 20111114190254 5 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 76.24.133.217 20111114191458 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 67.78.136.194 20111114192048 85 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 59.161.139.118 20111114192300 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 216.14.57.210 20111114192852 17 6 0 0 1 0 0 0 0 0 0 0 0 0 0 0 59.92.23.233 20111114192923 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 206.176.108.151 20111114204828 267 10 5 0 1 0 0 0 0 0 0 0 0 0 0 0 68.108.64.93 20111115003008 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 75.73.36.186 20111115005117 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 72.25.24.228 20111115011059 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 76.4.250.194 20111115011307 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 70.124.194.128 20111115014055 2 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 24.171.129.214 20111115023242 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 50.54.238.136 20111115033905 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 184.3.195.3 20111115045453 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 211.49.208.25 20111115104026 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 115.108.105.158 20111115122416 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 125.21.153.160 20111115123059 8 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 77.220.15.130 20111115124148 18 7 0 0 0 0 0 0 0 0 0 0 0 0 0 0 64.83.202.227 20111115124407 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 117.96.229.72 20111115144038 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 64.162.40.123 20111115180129 31 20 0 0 0 0 0 0 0 0 0 0 0 0 0 0 122.179.80.68 20111116063016 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 59.144.118.72 20111116065430 9 5 2 0 0 0 0 0 0 0 0 0 0 0 0 0 81.101.28.170 20111116132906 57 100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 201.239.62.83 20111116192215 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 58.164.126.48 20111117065707 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 112.207.223.10 20111118104336 4 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 117.239.133.130 20111118105031 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 122.165.33.215 20111118115755 6 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 207.235.167.118 20111118210757 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 68.5.29.190 20111118213524 24 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 24.106.214.146 20111118230438 67 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Monday, January 23rd

Investigate ways to retrieve user results from non-english wikipedia (e.g. PT) - WP API provides a public interface from which usernames can be scraped http://en.wikipedia.org/w/api.php?action=query&list=allusers

There seems to be some missing data over template z60 so I'm looking at the test consisting of z64 (http://en.wikipedia.org/wiki/Template:Uw-error1-default) / z65 (http://en.wikipedia.org/wiki/Template:Uw-error1-short) results and script below:

Postings and Edit Counts

z64 - METRICS - EDIT COUNT: recipient_name timestamp ns_0_revisions_before ns_0_revisions_after ns_0_revisions_deleted_before ns_0_revisions_deleted_after ns_3_revisions_before ns_3_revisions_after ns_3_revisions_deleted_before ns_3_revisions_deleted_after 216.56.27.98 20111018190724 120 2 0 0 0 0 0 0 72.54.30.98 20111018193408 2 0 0 0 0 0 0 0 173.183.157.75 20111019080308 1 0 0 0 0 0 0 0 92.40.90.217 20111019205807 2 0 0 0 0 0 0 0 70.235.80.47 20111019213939 1 0 0 0 0 0 0 0 137.216.165.156 20111020090743 1 0 0 0 0 0 0 0 121.222.132.17 20111020091029 3 0 0 0 0 0 0 0 24.149.125.220 20111021013723 3 2 0 0 0 0 0 0 173.55.193.181 20111021042331 3 1 0 0 0 0 0 0 76.16.180.93 20111022195308 1 0 0 0 0 0 0 0 149.5.33.173 20111022203715 9 0 0 0 0 0 0 0 86.178.68.203 20111024023319 2 0 0 0 0 0 0 0 24.56.78.174 20111024145151 7 3 0 0 0 0 0 0 24.36.170.51 20111024150305 1 0 0 0 0 0 0 0 199.172.169.97 20111024201135 26 13 0 0 2 0 0 0 66.168.79.204 20111025033439 1 0 0 0 0 0 0 0 128.243.253.125 20111025195557 27 9 0 0 0 0 0 0 86.46.83.193 20111026194343 6 0 0 0 0 0 0 0 50.55.79.168 20111028211923 1 0 0 0 0 0 0 0 68.209.22.17 20111028221930 2 4 0 0 0 0 0 0 223.177.180.12 20111029082004 1 0 0 0 0 0 0 0 121.222.118.127 20111029082118 1 0 0 0 0 0 0 0 74.195.192.12 20111030040133 1 0 0 0 0 0 0 0 65.96.171.235 20111101022027 2 0 0 0 0 0 0 0 203.82.80.20 20111101102510 7 1 0 0 0 0 0 0 24.85.142.84 20111101111531 18 10 0 0 0 0 0 0 71.201.57.51 20111103003948 1 0 0 0 0 0 0 0 130.184.253.20 20111103004346 14 6 0 0 0 0 0 0 82.95.74.50 20111103014817 3 13 0 0 0 0 0 0 Bone421 20111103020927 55 14 0 0 0 0 0 0 98.192.51.98 20111103045912 1 0 0 0 0 0 0 0 2.50.20.240 20111103051801 1 0 0 0 0 0 0 0 115.249.67.250 20111103093848 6 0 1 0 0 0 0 0 80.238.1.135 20111103133112 489 108 25 0 1 2 0 0 62.255.232.218 20111104012532 2 0 0 0 0 0 0 0 131.156.234.98 20111104065841 1 0 0 0 0 0 0 0 188.77.245.167 20111104221231 1 2 0 0 0 0 0 0 2.126.57.181 20111104221635 1 0 0 0 0 0 0 0 Internationalboy54 20111104231343 60 166 14 13 0 6 0 0 132.3.29.68 20111105184043 282 41 0 0 0 0 0 0 174.91.224.24 20111105192544 1 0 0 0 0 0 0 0 189.226.74.69 20111106010457 1 0 0 0 0 0 0 0 163.120.70.10 20111107033541 280 41 0 0 3 0 0 0 69.110.134.186 20111107040223 1 0 0 0 0 0 0 0 68.99.177.231 20111107043429 2 1 0 0 0 0 0 0 98.142.192.4 20111107172005 88 4 0 0 2 0 0 0 82.37.141.124 20111108104142 5 0 0 0 0 0 0 0 173.89.241.3 20111108161804 5 5 0 0 0 0 0 0 98.244.108.205 20111108195853 3 0 0 0 0 0 0 0 82.36.34.56 20111108212743 1 31 0 0 0 0 0 0 112.200.89.35 20111110045247 1 0 0 0 0 0 0 0 98.154.34.154 20111110072128 2 2 0 0 0 0 0 0 72.224.139.48 20111110225737 38 70 0 0 0 0 0 0 50.103.29.93 20111111041319 4 0 0 0 0 2 0 0 122.165.48.181 20111111053333 27 3 0 0 0 0 0 0 174.94.56.74 20111111061003 1 1 0 0 0 2 0 0 108.12.25.34 20111111140023 1 0 0 0 0 0 0 0 70.164.245.138 20111111162345 4 0 0 0 0 0 0 0 68.230.119.131 20111111214951 1 0 0 0 0 0 0 0 173.217.17.76 20111112043804 1 0 0 0 0 0 0 0 109.150.49.175 20111112154155 1 0 0 0 0 0 0 0 83.71.102.175 20111112162014 2 1 0 0 0 0 0 0 97.93.139.94 20111112202754 7 0 0 0 0 0 0 0 173.73.114.224 20111112223823 1 0 0 0 0 0 0 0 71.204.144.213 20111113071514 1 0 0 0 0 0 0 0 Ckeniston 20111113172813 4 14 0 0 0 0 0 0 98.142.192.66 20111114192216 68 3 0 0 1 0 0 0 109.255.218.102 20111114200657 1 2 0 0 0 0 0 0 216.236.251.130 20111114201729 194 37 0 0 0 0 0 0 24.52.79.55 20111114203722 1 0 0 0 0 0 0 0 119.152.22.134 20111114204100 1 2 0 0 0 0 0 0 62.163.190.128 20111115130027 2 0 0 0 0 0 0 0 216.199.195.220 20111115151417 1 0 0 0 0 0 0 0 68.153.118.224 20111115153737 299 3 1 0 2 0 0 0 66.78.233.142 20111116210243 1 0 0 0 0 0 0 0 97.9.99.186 20111117023602 1 1 0 0 0 0 0 0 173.70.160.82 20111118191301 3 0 0 0 0 0 0 0 68.56.173.14 20111118234614 4 0 0 0 0 0 0 0 z64 - METRICS - BLOCKS: recipient_name timestamp blocks_before blocks_after first_block_before last_block_before first_block_after last_block_after bans_before bans_after first_ban_before last_ban_before first_ban_after last_ban_after 216.56.27.98 20111018190724 4 1 20090519192713 20100215153749 20111019223023 20111019223023 0 0 \N \N \N \N 72.54.30.98 20111018193408 0 0 \N \N \N \N 0 0 \N \N \N \N 173.183.157.75 20111019080308 0 0 \N \N \N \N 0 0 \N \N \N \N 92.40.90.217 20111019205807 0 0 \N \N \N \N 0 0 \N \N \N \N 70.235.80.47 20111019213939 0 0 \N \N \N \N 0 0 \N \N \N \N 137.216.165.156 20111020090743 0 0 \N \N \N \N 0 0 \N \N \N \N 121.222.132.17 20111020091029 0 0 \N \N \N \N 0 0 \N \N \N \N 24.149.125.220 20111021013723 0 0 \N \N \N \N 0 0 \N \N \N \N 173.55.193.181 20111021042331 0 0 \N \N \N \N 0 0 \N \N \N \N 76.16.180.93 20111022195308 0 0 \N \N \N \N 0 0 \N \N \N \N 149.5.33.173 20111022203715 0 0 \N \N \N \N 0 0 \N \N \N \N 86.178.68.203 20111024023319 0 0 \N \N \N \N 0 0 \N \N \N \N 24.56.78.174 20111024145151 0 0 \N \N \N \N 0 0 \N \N \N \N 24.36.170.51 20111024150305 0 0 \N \N \N \N 0 0 \N \N \N \N 199.172.169.97 20111024201135 0 0 \N \N \N \N 0 0 \N \N \N \N 66.168.79.204 20111025033439 0 0 \N \N \N \N 0 0 \N \N \N \N 128.243.253.125 20111025195557 0 0 \N \N \N \N 0 0 \N \N \N \N 86.46.83.193 20111026194343 0 0 \N \N \N \N 0 0 \N \N \N \N 50.55.79.168 20111028211923 0 0 \N \N \N \N 0 0 \N \N \N \N 68.209.22.17 20111028221930 0 0 \N \N \N \N 0 0 \N \N \N \N 223.177.180.12 20111029082004 0 0 \N \N \N \N 0 0 \N \N \N \N 121.222.118.127 20111029082118 0 0 \N \N \N \N 0 0 \N \N \N \N 74.195.192.12 20111030040133 0 0 \N \N \N \N 0 0 \N \N \N \N 65.96.171.235 20111101022027 0 0 \N \N \N \N 0 0 \N \N \N \N 203.82.80.20 20111101102510 0 0 \N \N \N \N 0 0 \N \N \N \N 24.85.142.84 20111101111531 0 0 \N \N \N \N 0 0 \N \N \N \N 71.201.57.51 20111103003948 0 0 \N \N \N \N 0 0 \N \N \N \N 130.184.253.20 20111103004346 0 0 \N \N \N \N 0 0 \N \N \N \N 82.95.74.50 20111103014817 0 0 \N \N \N \N 0 0 \N \N \N \N Bone421 20111103020927 0 0 \N \N \N \N 0 0 \N \N \N \N 98.192.51.98 20111103045912 0 0 \N \N \N \N 0 0 \N \N \N \N 2.50.20.240 20111103051801 0 0 \N \N \N \N 0 0 \N \N \N \N 115.249.67.250 20111103093848 0 0 \N \N \N \N 0 0 \N \N \N \N 80.238.1.135 20111103133112 0 0 \N \N \N \N 0 0 \N \N \N \N 62.255.232.218 20111104012532 0 1 \N \N 20111104012748 20111104012748 0 0 \N \N \N \N 131.156.234.98 20111104065841 0 0 \N \N \N \N 0 0 \N \N \N \N 188.77.245.167 20111104221231 0 0 \N \N \N \N 0 0 \N \N \N \N 2.126.57.181 20111104221635 0 0 \N \N \N \N 0 0 \N \N \N \N Internationalboy54 20111104231343 0 1 \N \N 20111205122359 20111205122359 0 1 \N \N 20120102200147 20120102200147 132.3.29.68 20111105184043 1 2 20110629150109 20110629150109 20111208204714 20120107042000 0 0 \N \N \N \N 174.91.224.24 20111105192544 0 0 \N \N \N \N 0 0 \N \N \N \N 189.226.74.69 20111106010457 0 0 \N \N \N \N 0 0 \N \N \N \N 163.120.70.10 20111107033541 0 0 \N \N \N \N 0 0 \N \N \N \N 69.110.134.186 20111107040223 0 0 \N \N \N \N 0 0 \N \N \N \N 68.99.177.231 20111107043429 0 0 \N \N \N \N 0 0 \N \N \N \N 98.142.192.4 20111107172005 4 0 20091021162543 20101025161635 \N \N 0 0 \N \N \N \N 82.37.141.124 20111108104142 0 0 \N \N \N \N 0 0 \N \N \N \N 173.89.241.3 20111108161804 0 1 \N \N 20111108161833 20111108161833 0 0 \N \N \N \N 98.244.108.205 20111108195853 0 0 \N \N \N \N 0 0 \N \N \N \N 82.36.34.56 20111108212743 0 1 \N \N 20111206230809 20111206230809 0 0 \N \N \N \N 112.200.89.35 20111110045247 0 0 \N \N \N \N 0 0 \N \N \N \N 98.154.34.154 20111110072128 0 0 \N \N \N \N 0 0 \N \N \N \N 72.224.139.48 20111110225737 0 3 \N \N 20111111030922 20111211160823 0 0 \N \N \N \N 50.103.29.93 20111111041319 0 0 \N \N \N \N 0 0 \N \N \N \N 122.165.48.181 20111111053333 0 1 \N \N 20111115053454 20111115053454 0 0 \N \N \N \N 174.94.56.74 20111111061003 0 0 \N \N \N \N 0 0 \N \N \N \N 108.12.25.34 20111111140023 0 0 \N \N \N \N 0 0 \N \N \N \N 70.164.245.138 20111111162345 0 0 \N \N \N \N 0 0 \N \N \N \N 68.230.119.131 20111111214951 0 0 \N \N \N \N 0 0 \N \N \N \N 173.217.17.76 20111112043804 0 0 \N \N \N \N 0 0 \N \N \N \N 109.150.49.175 20111112154155 0 0 \N \N \N \N 0 0 \N \N \N \N 83.71.102.175 20111112162014 0 0 \N \N \N \N 0 0 \N \N \N \N 97.93.139.94 20111112202754 0 0 \N \N \N \N 0 0 \N \N \N \N 173.73.114.224 20111112223823 0 0 \N \N \N \N 0 0 \N \N \N \N 71.204.144.213 20111113071514 0 0 \N \N \N \N 0 0 \N \N \N \N Ckeniston 20111113172813 0 0 \N \N \N \N 0 0 \N \N \N \N 98.142.192.66 20111114192216 4 0 20090918190502 20110414133325 \N \N 0 0 \N \N \N \N 109.255.218.102 20111114200657 0 0 \N \N \N \N 0 0 \N \N \N \N 216.236.251.130 20111114201729 3 0 20081028184009 20090224043827 \N \N 0 0 \N \N \N \N 24.52.79.55 20111114203722 0 0 \N \N \N \N 0 0 \N \N \N \N 119.152.22.134 20111114204100 0 0 \N \N \N \N 0 0 \N \N \N \N 62.163.190.128 20111115130027 0 0 \N \N \N \N 0 0 \N \N \N \N 216.199.195.220 20111115151417 0 0 \N \N \N \N 0 0 \N \N \N \N 68.153.118.224 20111115153737 8 0 20070430225749 20101006152144 \N \N 0 0 \N \N \N \N 66.78.233.142 20111116210243 0 0 \N \N \N \N 0 0 \N \N \N \N 97.9.99.186 20111117023602 0 0 \N \N \N \N 0 0 \N \N \N \N 173.70.160.82 20111118191301 0 0 \N \N \N \N 0 0 \N \N \N \N 68.56.173.14 20111118234614 0 0 \N \N \N \N 0 0 \N \N \N \N z65 - METRICS - EDIT COUNT: recipient_name timestamp ns_0_revisions_before ns_0_revisions_after ns_0_revisions_deleted_before ns_0_revisions_deleted_after ns_3_revisions_before ns_3_revisions_after ns_3_revisions_deleted_before ns_3_revisions_deleted_after Skilla1st 20111019194932 19 664 0 0 0 0 0 0 178.84.40.31 20111019204949 2 0 0 0 0 0 0 0 75.181.102.49 20111019211224 10 2 0 0 0 0 0 0 136.173.162.144 20111020092853 432 60 10 1 0 0 0 0 24.190.8.109 20111021024905 1 0 0 0 0 0 0 0 174.106.99.86 20111021025050 2 1 0 0 0 0 0 0 173.34.249.160 20111021025128 4 0 0 0 0 0 0 0 67.53.18.234 20111021203218 1 2 0 0 0 0 0 0 173.74.234.240 20111021203307 1 1 0 0 0 0 0 0 70.51.54.188 20111023223805 3 0 0 0 0 0 0 0 186.151.63.167 20111024045440 4 0 0 0 0 0 0 0 24.199.24.234 20111024152646 1 1 0 0 0 0 0 0 174.97.186.237 20111024201930 2 1 0 0 0 0 0 0 180.131.236.45 20111024212641 3 0 0 0 0 0 0 0 173.181.29.120 20111025021632 2 0 0 0 0 0 0 0 203.122.215.65 20111025034140 14 13 0 6 0 3 0 0 64.207.252.254 20111025194035 212 4 1 0 0 0 0 0 68.191.57.153 20111026212158 1 0 0 0 0 0 0 0 192.193.164.10 20111028063110 50 14 0 0 0 0 0 0 129.24.179.21 20111029154158 1 0 0 0 0 0 0 0 94.145.22.32 20111029163846 4 0 0 0 0 0 0 0 24.89.131.186 20111030204058 377 24 0 0 0 0 0 0 76.111.248.160 20111030232056 1 0 0 0 0 0 0 0 Badgelady2000 20111031014814 7 2 0 0 0 1 0 0 193.156.161.253 20111031101552 38 11 0 0 0 0 0 0 24.104.66.106 20111031214926 1 0 0 0 0 0 0 0 71.13.236.155 20111101022108 5 0 0 0 0 0 0 0 124.210.39.221 20111101100646 10 0 0 0 0 0 0 0 109.66.206.208 20111103013114 1 0 0 0 0 0 0 0 119.154.71.40 20111103133433 1 0 0 0 0 0 0 0 184.239.254.68 20111103233110 1 0 0 0 0 0 0 0 137.154.73.31 20111104005034 841 0 2 0 9 0 1 0 71.224.8.189 20111104200928 1 1 0 0 0 0 0 0 180.245.251.117 20111105192852 1 0 0 0 0 0 0 0 108.193.131.18 20111107003629 11 19 0 0 0 0 0 0 38.109.25.246 20111107004448 82 9 0 0 0 0 0 0 68.199.136.219 20111107031030 1 0 0 0 0 0 0 0 71.48.230.49 20111108003059 3 0 0 0 0 0 0 0 58.28.205.148 20111108081501 2 0 0 0 0 0 0 0 99.147.56.150 20111109222006 1 0 0 0 0 0 0 0 70.123.132.179 20111110025049 6 4 0 0 0 1 0 0 24.130.115.61 20111110045315 1 0 0 0 0 0 0 0 124.170.24.93 20111110135524 2 2 0 0 0 0 0 0 68.2.189.71 20111111070616 1 1 0 0 0 0 0 0 71.193.40.157 20111111072806 1 0 0 0 0 0 0 0 113.23.42.69 20111111094202 5 3 0 0 0 0 0 0 209.124.166.20 20111111195814 794 14 9 0 0 0 0 0 65.37.11.107 20111112154218 7 3 0 0 0 0 0 0 71.178.0.91 20111113171934 1 0 0 0 0 0 0 0 81.190.252.135 20111113202902 2 0 0 0 0 0 0 0 76.124.233.114 20111113205643 2 0 0 0 0 0 0 0 86.160.48.57 20111114235724 1 0 0 0 0 0 0 0 50.10.46.180 20111115000152 1 0 0 0 0 0 0 0 69.14.31.122 20111115013928 2 1 0 0 0 0 0 0 50.104.214.119 20111115021720 44 32 0 0 0 0 0 0 184.163.229.46 20111115085002 1 0 0 0 0 0 0 0 216.186.51.175 20111115175158 181 30 0 0 0 0 0 0 86.17.81.236 20111115211558 1 0 0 0 0 0 0 0 109.145.108.30 20111115212446 1 0 0 0 0 0 0 0 198.237.119.70 20111115212714 7 0 0 0 0 0 0 0 75.17.206.44 20111116021017 1 0 0 0 0 0 0 0 69.54.60.34 20111116041644 154 5 0 0 0 0 1 0 98.87.50.231 20111116044735 2 0 0 0 0 0 0 0 155.212.229.9 20111116132606 6 27 0 0 0 0 0 0 169.244.21.235 20111116153424 213 18 1 0 4 0 0 0 91.186.225.154 20111118114137 1 0 0 0 0 0 0 0 72.95.217.34 20111118201801 402 4 15 0 1 3 0 0 z65 - METRICS - BLOCKS: recipient_name timestamp blocks_before blocks_after first_block_before last_block_before first_block_after last_block_after bans_before bans_after first_ban_before last_ban_before first_ban_after last_ban_after Skilla1st 20111019194932 0 0 \N \N \N \N 0 0 \N \N \N \N 178.84.40.31 20111019204949 0 0 \N \N \N \N 0 0 \N \N \N \N 75.181.102.49 20111019211224 0 0 \N \N \N \N 0 0 \N \N \N \N 136.173.162.144 20111020092853 0 0 \N \N \N \N 0 0 \N \N \N \N 24.190.8.109 20111021024905 0 0 \N \N \N \N 0 0 \N \N \N \N 174.106.99.86 20111021025050 0 0 \N \N \N \N 0 0 \N \N \N \N 173.34.249.160 20111021025128 0 0 \N \N \N \N 0 0 \N \N \N \N 67.53.18.234 20111021203218 0 0 \N \N \N \N 0 0 \N \N \N \N 173.74.234.240 20111021203307 0 0 \N \N \N \N 0 0 \N \N \N \N 70.51.54.188 20111023223805 0 0 \N \N \N \N 0 0 \N \N \N \N 186.151.63.167 20111024045440 0 0 \N \N \N \N 0 0 \N \N \N \N 24.199.24.234 20111024152646 0 0 \N \N \N \N 0 0 \N \N \N \N 174.97.186.237 20111024201930 0 0 \N \N \N \N 0 0 \N \N \N \N 180.131.236.45 20111024212641 0 0 \N \N \N \N 0 0 \N \N \N \N 173.181.29.120 20111025021632 0 0 \N \N \N \N 0 0 \N \N \N \N 203.122.215.65 20111025034140 0 1 \N \N 20111115043651 20111115043651 0 0 \N \N \N \N 64.207.252.254 20111025194035 6 1 20081106164842 20090909193737 20120111223554 20120111223554 0 0 \N \N \N \N 68.191.57.153 20111026212158 0 0 \N \N \N \N 0 0 \N \N \N \N 192.193.164.10 20111028063110 0 0 \N \N \N \N 0 0 \N \N \N \N 129.24.179.21 20111029154158 0 0 \N \N \N \N 0 0 \N \N \N \N 94.145.22.32 20111029163846 0 0 \N \N \N \N 0 0 \N \N \N \N 24.89.131.186 20111030204058 0 0 \N \N \N \N 0 0 \N \N \N \N 76.111.248.160 20111030232056 0 0 \N \N \N \N 0 0 \N \N \N \N Badgelady2000 20111031014814 0 0 \N \N \N \N 0 0 \N \N \N \N 193.156.161.253 20111031101552 2 1 20110825114244 20110927080905 20111103115840 20111103115840 0 0 \N \N \N \N 24.104.66.106 20111031214926 0 0 \N \N \N \N 0 0 \N \N \N \N 71.13.236.155 20111101022108 0 0 \N \N \N \N 0 0 \N \N \N \N 124.210.39.221 20111101100646 0 0 \N \N \N \N 0 0 \N \N \N \N 109.66.206.208 20111103013114 0 0 \N \N \N \N 0 0 \N \N \N \N 119.154.71.40 20111103133433 0 0 \N \N \N \N 0 0 \N \N \N \N 184.239.254.68 20111103233110 0 0 \N \N \N \N 0 0 \N \N \N \N 137.154.73.31 20111104005034 5 1 20100430100021 20110401080644 20111104030204 20111104030204 0 0 \N \N \N \N 71.224.8.189 20111104200928 0 0 \N \N \N \N 0 0 \N \N \N \N 180.245.251.117 20111105192852 0 0 \N \N \N \N 0 0 \N \N \N \N 108.193.131.18 20111107003629 0 1 \N \N 20120106005445 20120106005445 0 0 \N \N \N \N 38.109.25.246 20111107004448 0 0 \N \N \N \N 0 0 \N \N \N \N 68.199.136.219 20111107031030 0 0 \N \N \N \N 0 0 \N \N \N \N 71.48.230.49 20111108003059 0 0 \N \N \N \N 0 0 \N \N \N \N 58.28.205.148 20111108081501 0 0 \N \N \N \N 0 0 \N \N \N \N 99.147.56.150 20111109222006 0 0 \N \N \N \N 0 0 \N \N \N \N 70.123.132.179 20111110025049 0 0 \N \N \N \N 0 0 \N \N \N \N 24.130.115.61 20111110045315 0 0 \N \N \N \N 0 0 \N \N \N \N 124.170.24.93 20111110135524 0 0 \N \N \N \N 0 0 \N \N \N \N 68.2.189.71 20111111070616 0 0 \N \N \N \N 0 0 \N \N \N \N 71.193.40.157 20111111072806 0 0 \N \N \N \N 0 0 \N \N \N \N 113.23.42.69 20111111094202 0 0 \N \N \N \N 0 0 \N \N \N \N 209.124.166.20 20111111195814 1 0 20100518175354 20100518175354 \N \N 0 0 \N \N \N \N 65.37.11.107 20111112154218 0 0 \N \N \N \N 0 0 \N \N \N \N 71.178.0.91 20111113171934 0 0 \N \N \N \N 0 0 \N \N \N \N 81.190.252.135 20111113202902 0 0 \N \N \N \N 0 0 \N \N \N \N 76.124.233.114 20111113205643 0 0 \N \N \N \N 0 0 \N \N \N \N 86.160.48.57 20111114235724 0 0 \N \N \N \N 0 0 \N \N \N \N 50.10.46.180 20111115000152 0 0 \N \N \N \N 0 0 \N \N \N \N 69.14.31.122 20111115013928 0 0 \N \N \N \N 0 0 \N \N \N \N 50.104.214.119 20111115021720 0 3 \N \N 20111115023827 20111201053633 0 0 \N \N \N \N 184.163.229.46 20111115085002 0 0 \N \N \N \N 0 0 \N \N \N \N 216.186.51.175 20111115175158 0 2 \N \N 20111115181919 20111201100744 0 0 \N \N \N \N 86.17.81.236 20111115211558 0 0 \N \N \N \N 0 0 \N \N \N \N 109.145.108.30 20111115212446 0 0 \N \N \N \N 0 0 \N \N \N \N 198.237.119.70 20111115212714 0 0 \N \N \N \N 0 0 \N \N \N \N 75.17.206.44 20111116021017 0 0 \N \N \N \N 0 0 \N \N \N \N 69.54.60.34 20111116041644 1 0 20101108234806 20101108234806 \N \N 0 0 \N \N \N \N 98.87.50.231 20111116044735 0 0 \N \N \N \N 0 0 \N \N \N \N 155.212.229.9 20111116132606 0 1 \N \N 20120119184015 20120119184015 0 0 \N \N \N \N 169.244.21.235 20111116153424 7 0 20070207153958 20101022175207 \N \N 1 0 20070601214056 20070601214056 \N \N 91.186.225.154 20111118114137 0 0 \N \N \N \N 0 0 \N \N \N \N 72.95.217.34 20111118201801 7 0 20070822153014 20110822225304 \N \N 0 0 \N \N \N \N

t-test results for z64 / z65

> summary(z64_ns0) Min. 1st Qu. Median Mean 3rd Qu. Max. -30.0000 0.5952 1.0000 0.2177 1.0000 1.0000 > summary(z65_ns0) Min. 1st Qu. Median Mean 3rd Qu. Max. -33.9500 0.6410 1.0000 0.1832 1.0000 1.0000 Namespace 0 comparison between z64 / z65: Welch Two Sample t-test data: z64_ns0 and z65_ns0 t = 0.0522, df = 128.74, p-value = 0.9585 alternative hypothesis: true difference in means is not equal to 0 95 percent confidence interval: -1.273372 1.342355 sample estimates: mean of x mean of y 0.2177395 0.1832479

Tuesday, January 24th

Today I'm looking into producing a Chi-Squared test on R to provide additional analysis for our template testing.

We should also look at the effects the templates may have had beyond edit count. Below is a laundry list of some methodological testing that we should do:

• Look at variables beyond edit count (blocks, bans, warnings)
• Determine whether any additional variables are needed
• Linear modelling of metrics (in combination the results of test may be significant) - I may need to define what constitutes a positive outcome of the template to do modelling
• Doing analysis on all template results combined

t-test results for z66 / z67

> summary(z66_ns0) Min. 1st Qu. Median Mean 3rd Qu. Max. NA's -6.0000 0.5000 1.0000 0.5896 1.0000 1.0000 2.0000 > summary(z67_ns0) Min. 1st Qu. Median Mean 3rd Qu. Max. -11.2400 0.5000 0.9659 0.4635 1.0000 1.0000 Namespace 0 comparison between z66 / z67: Welch Two Sample t-test data: z66_ns0 and z67_ns0 t = 1.4845, df = 532.181, p-value = 0.1383 alternative hypothesis: true difference in means is not equal to 0 95 percent confidence interval: -0.0407634 0.2929571 sample estimates: mean of x mean of y 0.5895704 0.4634735

t-test results for z68 / z69

> summary(z68_ns0) Min. 1st Qu. Median Mean 3rd Qu. Max. NA's -9.0000 0.5000 1.0000 0.4955 1.0000 1.0000 1.0000 > summary(z69_ns0) Min. 1st Qu. Median Mean 3rd Qu. Max. -9.0000 0.3803 1.0000 0.3661 1.0000 1.0000 Namespace 0 comparison between z68 / z69: Welch Two Sample t-test data: z68_ns0 and z69_ns0 t = 0.6656, df = 188.955, p-value = 0.5065 alternative hypothesis: true difference in means is not equal to 0 95 percent confidence interval: -0.2540621 0.5128190 sample estimates: mean of x mean of y 0.4955174 0.3661389

t-test results for z70 / z71

> summary(z64_ns0) Min. 1st Qu. Median Mean 3rd Qu. Max. -18.5000 0.1250 0.9173 -0.2015 1.0000 1.0000 > summary(z65_ns0) Min. 1st Qu. Median Mean 3rd Qu. Max. -5.5220 0.6667 1.0000 0.5269 1.0000 1.0000 Namespace 0 comparison between z70 / z71: Welch Two Sample t-test data: z70_ns0 and z71_ns0 t = -1.0481, df = 34.476, p-value = 0.3019 alternative hypothesis: true difference in means is not equal to 0 95 percent confidence interval: -2.1399297 0.6831945 sample estimates: mean of x mean of y -0.2014740 0.5268936

Wednesday, January 25th

A lot of meetings today unfortunately. Otherwise I'm focusing on writing the R script to perform Chi-Squared goodness of fit tests (http://en.wikipedia.org/wiki/Pearson%27s_chi-squared_test#Test_for_fit_of_a_distribution) to contrast this with t-test results for change in edit count after the template event.

Retrieved es.wiki users and emails for editor groups.

January 26th/27th

Focusing on writing the R script to perform Chi-Squared goodness of fit tests (26th). Debugged the script [1][2] (27th). I'm aiming to execute these tests on the same templates and to contrast the results with the t-test analysis already performed.

Began execution of posting scripts [3] for remaining templates.

Monday, January 30th

Execute t-tests on the remaining Huggle 3 experiments. Also, combine all results to perform the test with more data which will hopefully lead to more definitive results.

t-test results for z74 / z75 - Measured decrease in edits after template posting

Below we see that the relative number of edits dropped more for the test template than the control. The result is not necessarily significant but is worth note. > summary(z_test) Min. 1st Qu. Median Mean 3rd Qu. Max. -3.0000 0.5000 0.9600 0.6142 1.0000 1.0000 > summary(z_control) Min. 1st Qu. Median Mean 3rd Qu. Max. -13.0000 0.6916 0.9583 0.3405 1.0000 1.0000 Welch Two Sample t-test data: z_test and z_control t = 1.0019, df = 86.484, p-value = 0.3192 alternative hypothesis: true difference in means is not equal to 0 95 percent confidence interval: -0.2693941 0.8169251 sample estimates: mean of x mean of y 0.6142338 0.3404683

t-test results for z76 / z77 - Measured decrease in edits after template posting

Below we see that the relative number of edits dropped more for the control template than the test. The result is not necessarily significant (P-value = .4552) but is worth note. > summary(z_test) Min. 1st Qu. Median Mean 3rd Qu. Max. -17.0000 0.5000 0.9857 0.4350 1.0000 1.0000 > summary(z_control) Min. 1st Qu. Median Mean 3rd Qu. Max. -18.0000 0.5000 1.0000 0.3397 1.0000 1.0000 Welch Two Sample t-test data: z_test and z_control t = 0.7473, df = 731.427, p-value = 0.4552 alternative hypothesis: true difference in means is not equal to 0 95 percent confidence interval: -0.1549452 0.3453839 sample estimates: mean of x mean of y 0.4349638 0.3397444

t-test results for z62 / z63 - Measured decrease in edits after template posting

Below we see that the relative number of edits dropped more for the control template than the test. However, the result is inconclusive. > summary(z_test) Min. 1st Qu. Median Mean 3rd Qu. Max. -5.0000 0.6667 1.0000 0.6566 1.0000 1.0000 > summary(z_control) Min. 1st Qu. Median Mean 3rd Qu. Max. -1.0000 0.9633 1.0000 0.7317 1.0000 1.0000 Welch Two Sample t-test data: z_test and z_control t = -0.2894, df = 8.358, p-value = 0.7793 alternative hypothesis: true difference in means is not equal to 0 95 percent confidence interval: -0.6686205 0.5185034 sample estimates: mean of x mean of y 0.6565928 0.7316514

Tuesday, January 31st

Execute t-tests on the remaining Huggle 3 experiments. Also, combine all results to perform the test with more data which will hopefully lead to more definitive results.

Huggle 3 t-test results for aggregate data - Measured decrease in edits after template posting

Below we see that the relative number of edits dropped more for the test template than the control. However, the result is inconclusive. > summary(z_test) Min. 1st Qu. Median Mean 3rd Qu. Max. -33.9500 0.5000 1.0000 0.4569 1.0000 1.0000 > summary(z_control) Min. 1st Qu. Median Mean 3rd Qu. Max. -30.0000 0.5000 1.0000 0.4391 1.0000 1.0000 Welch Two Sample t-test data: z_test and z_control t = 0.2425, df = 2191.729, p-value = 0.8084 alternative hypothesis: true difference in means is not equal to 0 95 percent confidence interval: -0.1263922 0.1620680 sample estimates: mean of x mean of y 0.4568973 0.4390593

Wednesday, February 1st

Finished aggregate analysis (see yesterday's entry for details.) The t-test analysis of the Huggle 3 experiment have resulted in inconclusive results with respect to edit activity. It seems that the test template did not make a significant difference based on the analysis so far. It will probably be worth attempting to involve additional variables in the analysis to account for potential bias or noise introduced by other factors.

Other work:

• Met with Karyn and Zack regarding long term goals of community analytics
• Worked with Steven and Maryana on PT wiki mailing lists

Thursday, February 2nd

Tasks for today:

• Resolve PT email list inconsistency
• Get editor notification working!
• PT Huggle experiment templates

Friday, February 3rd

I tweaked the implementation of the chi-squared testing in R and ran this test over the aggregate Huggle3 experiment data. The null hypothesis here is that the test distribution matches the control which entails a non-significant difference between the results of the test and control with respect to relative edit count changes. Since the p-value is pretty much zero this means that the null hypothesis cannot be rejected based on this test. This does not imply that other methods may be used to determine the relevance the template event may have had on good editor behaviour. The next step I am moving toward will be to include more variables in the analysis and to use linear modeling.

Huggle 3 chi-squared test results for aggregate data - Measured decrease in edits after template posting

Distribution of test template results of relative decrease (% e.g. .1 == 10%) in editor activity after template posting event: Min. 1st Qu. Median Mean 3rd Qu. Max. -33.9500 0.5000 1.0000 0.4569 1.0000 1.0000 Distribution of control template results of relative decrease (% e.g. .1 == 10%) in editor activity after template posting event: Min. 1st Qu. Median Mean 3rd Qu. Max. -30.0000 0.5000 1.0000 0.4391 1.0000 1.0000 Chi-squared test for given probabilities (test data modeled on control) X-squared = 2276582951, df = 9, p-value < 2.2e-16 Chi-squared test for given probabilities (control data modeled on test) X-squared = 6206664, df = 9, p-value < 2.2e-16

Monday, February 6th

Modified the postings script to read from files for the case of non-English wikis, the motivation being the Portuguese Huggle experiments (analysis below). Subsequently generated postings and metrics before performing analysis.

The results show that the measurement of relative rates of edit activity after the template event show no significant differences given this measure.

PT Huggle t-test results - Measured decrease in edits after template posting

Below we see that the relative number of edits dropped more for the control template than the test. However, the result is inconclusive. Distribution of test template results of relative decrease (% e.g. .1 == 10%) in editor activity after template posting event: Min. 1st Qu. Median Mean 3rd Qu. Max. -2.0000 1.0000 1.0000 0.8793 1.0000 1.0000 Distribution of control template results of relative decrease (% e.g. .1 == 10%) in editor activity after template posting event: Min. 1st Qu. Median Mean 3rd Qu. Max. 0.0000 0.9603 1.0000 0.8953 1.0000 1.0000 Welch Two Sample t-test data: z_test and z_control t = -0.2481, df = 110.768, p-value = 0.8046 alternative hypothesis: true difference in means is not equal to 0 95 percent confidence interval: -0.1443410 0.1122249 sample estimates: mean of x mean of y 0.8792902 0.8953483

PT Huggle t-test results - Measured decrease in edits after template posting
Data distributions are the same as above. X-squared = 99.8523, df = 5, p-value < 2.2e-16 Chi-squared test for given probabilities (control data modeled on test) X-squared = 69.406, df = 5, p-value = 1.362e-13

NOTES:

• Get web interface going (Zack's request)
• Meet with Steven and Maryana regarding analyses - getting notes on further breakdown of metrics...

We have measured so far

1. The relative decrease in article (NS0) edits, before and after the template.

New metrics to add

1. Edits anywhere (i.e. aggregate edits to all namespaces)
2. All edits, separated out by namespace RF > Metrics are already broken out in this manner - collecting all namespaces now
3. By time... RF > DONE. Modified generator
   1. Anytime edits after receiving test or control
   2. 0-3 days after
   3. 3-30 days after
   4. 30 days or more after
4. From each control and test group, how many editors were blocked?

Tuesday, February 7th

Revisiting "Huggle 3" Experimental analysis on:

• deleted edits after posting
• edits after posting broken out by time
• filtering out users based on edits before or after
• blocks before and after postings

Today I did a lot of searching in the new metric space to get a sense of where we can get the most conclusive results out of our short / long template testing. Given the number of variables regression modeling makes sense. Since we are trying to predict one of the two templates given the edit parameters a logistic regression here may make the most sense.

Wednesday, February 8th

• Developing new modeling analyses in R.
• Helped Megan with some updates of Fundraising Analytics code

Thursday, February 9th

• Development of script to parse editor lists - delivered new list of PT editors to Steven and Maryana
• Kicked off script to backload impressions from 2010 fundraiser for Zack
• Development of Logistic Regression (mostly data munging) functionality in R

• Meeting with Karyn regarding metric definitions and analysis. The main aim here was to have some preliminary discussion as to how we could better articulate what we want from our current set of experiments. I have the data broken down into the following metrics (in reference to the occurrence of the template posting event):

• edits_before_ns_X
• edits_after_0_3_days_ns_X (0 to 3 days after event)
• edits_after_3_30_days_ns_X (3 to 30 days after event)
• edits_after_gt_30_days_ns_X (more than 30 days after event)
• edits_deleted_before_ns_X
• edits_deleted_after_0_3_days_ns_X
• edits_deleted_after_3_30_days_ns_X
• edits_deleted_after_gt_30_days_ns_X
• blocks_before
• blocks_after

Karyn suggested trying to observe what happens users receive templates multiple times, which, if we can put together enough data could potentially yield some very interesting results.

• Community Analytics site instance now running - more to come

Friday, February 10th

• Backloading banner and landing page impressions - LP impressions too slow
• Discussed project integration with product team with Dario - "Relevant Page Links Study", discuss with Karyn

• Logistic modelling - found that there may be something happening (p-value = 0.115) with deleted edits 30 days after seeing the template (strongest separator of the data by template). I filtered the editors to include only those that made at least 100 edits in namespace 0 before the template posting event. The mean was higher for the test template. This may however be due to large outliers. The 0-3 day period after the event shows the reverse (control beats test) however, but the result isn't as significant (p-value = 0.424).

Logistic Modelling of several variables for the "Huggle 3" experiment

Logistic Regression in R: Call: glm(formula = template ~ ns_0_revisions_after_0_3 + ns_0_revisions_after_3_30 + ns_0_revisions_after_gt_30 + ns_0_revisions_deleted_after_0_3 + ns_0_revisions_deleted_after_3_30 + ns_0_revisions_deleted_after_gt_30 + blocks_before + blocks_after, family = binomial(link = "logit"), data = all_data) Deviance Residuals: Min 1Q Median 3Q Max -1.5030 -1.1789 0.8353 1.1571 1.4251 Coefficients: Estimate Std. Error z value Pr(>|z|) (Intercept) -0.003240 0.205036 -0.016 0.987 ns_0_revisions_after_0_3 -0.006076 0.007600 -0.799 0.424 ns_0_revisions_after_3_30 -0.004305 0.007651 -0.563 0.574 ns_0_revisions_after_gt_30 0.002270 0.003180 0.714 0.475 ns_0_revisions_deleted_after_0_3 0.071438 0.206948 0.345 0.730 ns_0_revisions_deleted_after_3_30 -0.100460 0.306029 -0.328 0.743 ns_0_revisions_deleted_after_gt_30 0.488763 0.310430 1.574 0.115 blocks_before 0.043109 0.047264 0.912 0.362 blocks_after 0.203919 0.302481 0.674 0.500 (Dispersion parameter for binomial family taken to be 1) Null deviance: 254.29 on 183 degrees of freedom Residual deviance: 246.51 on 175 degrees of freedom AIC: 264.51 Number of Fisher Scoring iterations: 5 Raw data: Test more than 30 days after: Min. 1st Qu. Median Mean 3rd Qu. Max. 0.0000 0.0000 0.0000 0.4388 0.0000 18.0000 [1] 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 [26] 0 1 0 0 0 0 0 4 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 [51] 0 0 7 0 0 0 4 8 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 [76] 0 0 0 0 0 0 18 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Control more than 30 days after: Min. 1st Qu. Median Mean 3rd Qu. Max. 0.00000 0.00000 0.00000 0.05814 0.00000 2.00000 [1] 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 [39] 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 [77] 0 0 0 0 0 0 0 0 0 0 Test edits 0-30 days after: Min. 1st Qu. Median Mean 3rd Qu. Max. 0.000 0.000 1.000 8.582 5.000 212.000 [1] 0 0 1 2 0 0 7 2 0 3 0 0 0 3 0 7 212 3 2 [20] 0 0 3 10 0 5 0 0 0 3 5 0 9 5 5 6 0 0 0 [39] 0 1 3 17 11 0 48 0 1 0 1 10 1 2 125 0 2 8 10 [58] 3 4 1 6 22 9 0 0 7 0 0 0 1 0 1 98 3 0 0 [77] 3 0 43 16 3 63 2 1 0 2 0 0 7 3 0 1 0 8 1 [96] 0 0 0 Control edits 0-30 days after: Min. 1st Qu. Median Mean 3rd Qu. Max. 0.00 0.00 2.00 11.98 7.00 300.00 [1] 0 2 0 4 6 53 1 0 1 2 2 3 15 2 1 2 12 66 0 [20] 19 0 2 0 7 1 1 9 7 0 4 0 0 26 34 0 0 1 15 [39] 1 300 0 3 38 5 8 0 0 3 0 3 0 2 1 12 4 5 1 [58] 38 3 36 27 2 12 0 22 7 0 2 0 49 0 3 2 0 0 2 [77] 0 0 2 0 1 50 3 7 78 0

Monday, February 13th

• Community "Teaminess" meeting - discussed team identity, potential merging with Howie's Product team
• Met with Sue regarding assumption the permanent position
• Met with Karyn, Steven, and Maryana regarding forming questions defining our Template experiments:

User Warning Template Questions

Huggle templates did a good job if: Edits increased or decreased less after receiving template AND did not lead to a higher incident of blocks after template received. Only look at people for whom this was their first message + the criteria above. Also look at FEWER deleted revisions in relation to all of the above. Is there anyone who edited MORE after receiving this template. What NS were those in (activity encouraged) Differences between IP and registered for all of the above tests? Huggle3, Huggle Short 2, we also tested templates specific to issues vs general vandalism -- we might want to parse out general vs specific. Look at repetition of receiving the same template multiple times -- for non shared IPs -- what is the behavior pattern after. ImageTaggingBot We want to know when the files were eventually deleted and tracking edits in the file namespace [6] that would indicate they did what was told CorenSearch were articles deleted or retained and did they keep editing and were they blocked or not. Ns4 28bot is effectively the same as Huggle. SharedIP test Logging registrations were the edits deleted or not were there more deleted revs. M & S talk through this Once we have results, we can 'sex up' the reports back to internal/community with graphs and extrapolations of the large scale effects - e.g. this template encouraged 3.5 more edits per person, which extrapolates to xyz overall edits. **These requests are excepting Twinkle test. Stu can work on 28bot..

• Investigated the following:

Question:

Edits increased or decreased less after receiving template AND did not lead to a higher incident of blocks after template received.

Data Munging / Filtering: 

Edits before >= 10, 
Edits deleted before >= 1,
Blocks after  = 0 
namespace = 0

Findings:
 
Revisions between 3 and 30 days were higher for the control by 6.8% (1.66 more edits for the control in that period)* - 92.17% confident
Deleted edits overall after the template posting decreased by 70.17% for the control and by 62.13% for the test - 90.68% confident

* there was a non-significant difference in edits before the template

Conclusion:

In this experiment that the control is performing better for namaspace 0.

Modelling Analysis - R Output

Call: glm(formula = template ~ ns_0_revisions_before + ns_0_revisions_deleted_before + ns_0_revisions_after_0_3 + ns_0_revisions_after_3_30 + ns_0_revisions_after_gt_30 + ns_0_revisions_deleted_after_0_3 + ns_0_revisions_deleted_after_3_30 + ns_0_revisions_deleted_after_gt_30 + edits_decrease + edits_del_decrease, family = binomial(link = "logit"), data = all_data) Deviance Residuals: Min 1Q Median 3Q Max -1.639 -1.222 0.855 1.060 1.499 Coefficients: Estimate Std. Error z value Pr(>|z|) (Intercept) 1.265e+00 6.586e-01 1.920 0.0548 . ns_0_revisions_before 7.417e-05 3.410e-04 0.217 0.8278 ns_0_revisions_deleted_before 1.060e-02 1.024e-02 1.035 0.3006 ns_0_revisions_after_0_3 1.273e-02 1.843e-02 0.691 0.4898 ns_0_revisions_after_3_30 -3.133e-02 1.780e-02 -1.761 0.0783 . ns_0_revisions_after_gt_30 1.580e-03 5.939e-03 0.266 0.7902 ns_0_revisions_deleted_after_0_3 -2.804e-02 2.294e-01 -0.122 0.9027 ns_0_revisions_deleted_after_3_30 -3.658e-01 4.417e-01 -0.828 0.4076 ns_0_revisions_deleted_after_gt_30 1.737e+01 8.829e+00 1.967 0.0491 * edits_decrease 1.109e-01 4.404e-01 0.252 0.8011 edits_del_decrease -1.482e+00 8.826e-01 -1.679 0.0932 . --- Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1 (Dispersion parameter for binomial family taken to be 1) Null deviance: 202.46 on 147 degrees of freedom Residual deviance: 184.63 on 137 degrees of freedom AIC: 206.63 Number of Fisher Scoring iterations: 10 > summary(merged_test$ns_0_revisions_deleted_after_gt_30) Min. 1st Qu. Median Mean 3rd Qu. Max. 0.0000 0.0000 0.0000 0.5238 0.0000 18.0000 > summary(merged_control$ns_0_revisions_deleted_after_gt_30) Min. 1st Qu. Median Mean 3rd Qu. Max. 0.00000 0.00000 0.00000 0.01562 0.00000 1.00000 > summary(merged_test$ns_0_revisions_after_3_30) Min. 1st Qu. Median Mean 3rd Qu. Max. 0.00 0.00 2.00 24.62 9.00 709.00 > summary(merged_control$ns_0_revisions_after_3_30) Min. 1st Qu. Median Mean 3rd Qu. Max. 0.00 0.00 4.00 26.28 12.00 682.00 > summary(merged_test$edits_del_decrease) Min. 1st Qu. Median Mean 3rd Qu. Max. -1.5000 0.5000 0.7500 0.6213 0.9000 0.9940 > summary(merged_control$edits_del_decrease) Min. 1st Qu. Median Mean 3rd Qu. Max. -0.7500 0.6250 0.8000 0.7017 0.8750 0.9900

Tuesday, February 14th

• Co-ordinate with Zack / Peter on generating new .csv data with banner counts for Gregory Gurevich [results sent to Peter G for review]
• Analysis, Huggle questions
• Generate metrics for "warnings" to filter by "first warning" on experimental templates

Tomorrow

• Request: recent editing activity for these csvs of users
• Fix DataMapper import of landing page requests to do batch imports - it is far too slow at the moment

Wednesday, February 15th

• Delivered banner counts to Gregory Gurevich
• Request: recent editing activity for these csvs of users - Pushed again to tomorrow

• Today I investigated the following:

Question:

Edits increased or decreased less after receiving template AND did not lead to a higher incident of blocks after template received.
Only look at people for whom this was their first message + the criteria above.


Data Munging / Filtering: 

Edit activity 0 - 3 days after posting 
3 <= edits before <= Inf,
Edits deleted before >= 0,
Blocks after = 0 (no blocks after seeing template)
namespace = 0
first_warning = TRUE


Findings:

 
FOR REGISTERED USERS:

Edits decreased by 44.20% for the control and 73.62% for the test template - 91.4% confident

Therefore the control template was certainly a good predictor in seeing a smaller decrease in edits after the posting event for first warning editors that had between 3 and 50 edits before the posting.  When registered users with more than 50 edits before the template posting were included the effect became inconclusive.


FOR NON-REGISTERED USERS:

Edits decreased by 83.71% for the control and 75.00% fro the test - 96.41% confident

Again the control template was a significant predictor in seeing a smaller decrease in edits after the posting event for first warning editors that had made between 5-50 edits before the posting.  Here the variable corresponding to a decrease in deleted edits was also shown to be an effective predictor, if not as strong as the predictor on sheer edit counts.  Note that the effect is not as strong as it is among registered users.

In this group there were no editors above 50 edits before receiving a warning.

---

A final note that in both cases strong predictors were not seen when editors have less than three edits were collected.


Conclusion:

In this experiment we see that:

  * the control is template results in a much smaller drop in edits post event for namaspace 0.
  * In general the improvements are somewhat larger for registered users (ie. smaller decrease in edits)

Modelling Analysis, Non-Registered Users (IPs) - R Output

Call: glm(formula = template ~ edits_decrease, family = binomial(link = "logit"), data = all_data) Deviance Residuals: Min 1Q Median 3Q Max -1.305 -1.305 1.055 1.055 1.607 Coefficients: Estimate Std. Error z value Pr(>|z|) (Intercept) -0.1788 0.2045 -0.874 0.3819 edits_decrease 0.4742 0.2261 2.098 0.0359 * --- Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1 (Dispersion parameter for binomial family taken to be 1) Null deviance: 635.88 on 461 degrees of freedom Residual deviance: 631.23 on 460 degrees of freedom AIC: 635.23 Number of Fisher Scoring iterations: 4 --------------- Reduction in edits Test: Min. 1st Qu. Median Mean 3rd Qu. Max. -1.6670 0.8045 1.0000 0.8371 1.0000 1.0000 Reduction in edits Control: Min. 1st Qu. Median Mean 3rd Qu. Max. -1.6670 0.6667 1.0000 0.7500 1.0000 1.0000

Modelling Analysis, Registered Users - R Output

Call: glm(formula = template ~ edits_decrease, family = binomial(link = "logit"), data = all_data) Deviance Residuals: Min 1Q Median 3Q Max -1.3945 -1.3195 0.9748 1.0409 1.3286 Coefficients: Estimate Std. Error z value Pr(>|z|) (Intercept) -0.1795 0.3361 -0.534 0.593 edits_decrease 0.6767 0.3942 1.716 0.086 . --- Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1 (Dispersion parameter for binomial family taken to be 1) Null deviance: 134.38 on 97 degrees of freedom Residual deviance: 130.16 on 96 degrees of freedom AIC: 134.16 Number of Fisher Scoring iterations: 4 --------------- Reduction in edits Test: Min. 1st Qu. Median Mean 3rd Qu. Max. -0.2500 0.6667 0.8667 0.7362 1.0000 1.0000 Reduction in edits Control: Min. 1st Qu. Median Mean 3rd Qu. Max. -3.8000 0.3250 0.9091 0.4420 1.0000 1.0000

Thursday, February 16th

• Request: recent editing activity for these csvs of users - Results sent

• Get on to alpha and tinker with the diff engine
  

Executing the following to simply get a sense of the type of results that we'll be seeing here:
   ryan@alpha:/home/yusuke/diffdbtest$ ./query.py Template:uw-vandalism1

If this does look to be helpful we can brainstorm some good patterns to start classifying editors.

• fix the DataMapper - this took some wrangling but the result is that I removed the IP geo-location code that makes DB requests to function and was severely slowing down the implementation. When no country data is available 'XX' is used as an iso_code for the moment.

• PT Analysis - Pushed to tomorrow

Thursday, February 16th

• Queries on alpha.wikilytics.org diff engine, coordinating with Diederik and Yusuke regarding usage of the engine

• PT Analysis

Question:

Edits increased or decreased less after receiving template AND did not lead to a higher incident of blocks after template received.
Only look at people for whom this was their first message

Also look at FEWER deleted revisions in relation to all of the above.
Is there anyone who edited MORE after receiving this template. What NS were those in (activity encouraged)

Differences between IP and registered for all of the above tests?


Data Munging / Filtering: 

3 <= edits before <= Inf,
Edits deleted before >= 0,
Blocks after = 0 (no blocks after seeing template)
namespace = 0
first_warning = TRUE


Findings:

None yet, this data is unfortunately very sparse so I may need to devise new metrics to learn anything.

Friday, February 17th

• Analysis of PT Huggle experiment - there does not seem to be a lot of editor activity after the template postings which makes analysis difficult

Data Munging / Filtering: 

All edits after
1 <= edits before <= Inf,
Edits deleted before >= 0,
Blocks after = 0 (no blocks after seeing template)
namespace = 0
first_warning = TRUE


Findings:

For non-registered users the drop in edits from the test template was less than the control (84.67% vs. 92.37%) there was a but the result was not highly confident (58.1%) this includes all editing activity any time after seeing the template posting.  

For registered users and deleted edits there was no observable difference however this is mainly due to sparse data.

Modelling Analysis, Non-Registered Users - R Output

Call: glm(formula = template ~ edits_decrease, family = binomial(link = "logit"), data = all_data) Deviance Residuals: Min 1Q Median 3Q Max -1.592 -1.330 1.022 1.032 1.032 Coefficients: Estimate Std. Error z value Pr(>|z|) (Intercept) 0.9370 0.6952 1.348 0.178 edits_decrease -0.5847 0.7239 -0.808 0.419 (Dispersion parameter for binomial family taken to be 1) Null deviance: 111.56 on 82 degrees of freedom Residual deviance: 110.74 on 81 degrees of freedom AIC: 114.74 Number of Fisher Scoring iterations: 4 Reduction in edits Test: Min. 1st Qu. Median Mean 3rd Qu. Max. -2.0000 1.0000 1.0000 0.8467 1.0000 1.0000 Reduction in edits Control: Min. 1st Qu. Median Mean 3rd Qu. Max. 0.0000 1.0000 1.0000 0.9237 1.0000 1.0000

Tuesday, February 21st

Out sick

Wednesday, February 22nd

• Generating metrics for Huggle short 1 & 2 experiment
• PT Huggle analysis (part of the Friday entry done today)
• Begin Huggle short 1 & 2 analysis

Thursday, February 23rd

• Meet with Nimish to discuss "revision survivability" metric, its application to the global education outreach project, and potential application as a more informative community metric
• Produce PT list for Steven and Maryana

• Huggle short 1 & 2 analysis

Data Munging / Filtering: 

Only tracking edits in the first three days after posting
1 <= edits before <= Inf,
Edits deleted before >= 0,
Blocks after = 0 (no blocks after seeing template)
namespace = 0
first_warning = TRUE


Findings:

For non-registered users the drop in edits from the test template was less than the control (73.15% vs. 76.66%) with a confidence level of 88.1%.  
For registered users the drop in edits from the test template was less than the control (20.22% vs. 25.32%) however the p-value (=> 23.5% confident) indicates that this result is not significant.  

Therefore there was an observable effect of this template in favour of the test for non-registered users.

Modelling Analysis, Non-Registered Users - R Output

Call: glm(formula = template ~ edits_decrease, family = binomial(link = "logit"), data = all_data) Deviance Residuals: Min 1Q Median 3Q Max -1.7200 -1.3945 0.9663 0.9748 0.9748 Coefficients: Estimate Std. Error z value Pr(>|z|) (Intercept) 0.56299 0.04348 12.948 <2e-16 *** edits_decrease -0.06576 0.04222 -1.558 0.119 --- Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1 (Dispersion parameter for binomial family taken to be 1) Null deviance: 6482.6 on 4901 degrees of freedom Residual deviance: 6480.1 on 4900 degrees of freedom AIC: 6484 Number of Fisher Scoring iterations: 4 Reduction in edits Test: Min. 1st Qu. Median Mean 3rd Qu. Max. -20.0000 1.0000 1.0000 0.7315 1.0000 1.0000 Reduction in edits Control: Min. 1st Qu. Median Mean 3rd Qu. Max. -10.0000 1.0000 1.0000 0.7666 1.0000 1.0000

Modelling Analysis, Registered Users - R Output

Call: glm(formula = template ~ edits_decrease, family = binomial(link = "logit"), data = all_data_reg) Deviance Residuals: Min 1Q Median 3Q Max -1.4973 -1.4247 0.9420 0.9488 0.9488 Coefficients: Estimate Std. Error z value Pr(>|z|) (Intercept) 0.58265 0.10073 5.784 7.28e-09 *** edits_decrease -0.01798 0.06024 -0.298 0.765 --- Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1 (Dispersion parameter for binomial family taken to be 1) Null deviance: 570.72 on 436 degrees of freedom Residual deviance: 570.63 on 435 degrees of freedom AIC: 574.63 Number of Fisher Scoring iterations: 4 Reduction in edits Test: Min. 1st Qu. Median Mean 3rd Qu. Max. -19.0000 0.0000 0.9306 0.2022 1.0000 1.0000 Reduction in edits Control: Min. 1st Qu. Median Mean 3rd Qu. Max. -8.0000 0.0000 0.8864 0.2532 1.0000 1.0000

• Huggle short 2 analysis

Data Munging / Filtering: 

Only tracking edits in the first three days after posting
5 <= edits before <= Inf (registered),
1 <= edits before <= Inf (non-registered),
Edits deleted before >= 0,
Blocks after = 0 (no blocks after seeing template)
namespace = 0
first_warning = TRUE


Findings:

For non-registered users the drop in edits from the control template was less than the test (71.38% vs. 79.91%) with a confidence level of 88.1%.  
For registered users the drop in edits from the test template was less than the control (55.63% vs. 88.27%) with a confidence level of 92.25%.  

Therefore there was an observable effect of this template in favour of the test for non-registered users and registered users.  
It is also noteworthy that for non-registered users the difference was heavily skewed to those that made very few edits before the template posting.  It should be further noted that much of the effect being seen is due to editors that don't make any edits after the posting.

Modelling Analysis, Non-Registered Users - R Output

Call: glm(formula = template ~ edits_decrease, family = binomial(link = "logit"), data = all_data) Deviance Residuals: Min 1Q Median 3Q Max -1.157 -1.157 -1.023 1.198 1.518 Coefficients: Estimate Std. Error z value Pr(>|z|) (Intercept) -0.2116 0.1073 -1.972 0.0486 * edits_decrease 0.1635 0.1035 1.579 0.1143 --- Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1 (Dispersion parameter for binomial family taken to be 1) Null deviance: 1079.8 on 779 degrees of freedom Residual deviance: 1077.2 on 778 degrees of freedom AIC: 1081.2 Number of Fisher Scoring iterations: 4 Reduction in edits Test: Min. 1st Qu. Median Mean 3rd Qu. Max. -3.4290 1.0000 1.0000 0.7991 1.0000 1.0000 Reduction in edits Control: Min. 1st Qu. Median Mean 3rd Qu. Max. -6.0000 0.9250 1.0000 0.7138 1.0000 1.0000

Modelling Analysis, Registered Users - R Output

Call: glm(formula = template ~ edits_decrease, family = binomial(link = "logit"), data = all_data) Deviance Residuals: Min 1Q Median 3Q Max -1.1224 -0.8574 -0.7639 1.1268 1.6578 Coefficients: Estimate Std. Error z value Pr(>|z|) (Intercept) 0.9267 0.9848 0.941 0.3467 edits_decrease -2.0091 1.1379 -1.766 0.0775 . --- Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1 (Dispersion parameter for binomial family taken to be 1) Null deviance: 80.201 on 62 degrees of freedom Residual deviance: 74.571 on 61 degrees of freedom AIC: 78.57 Number of Fisher Scoring iterations: 5 Reduction in edits Test: Min. 1st Qu. Median Mean 3rd Qu. Max. -3.4400 0.5500 0.9706 0.5563 1.0000 1.0000 Reduction in edits Control: Min. 1st Qu. Median Mean 3rd Qu. Max. 0.5263 0.8333 0.9359 0.8827 1.0000 1.0000

Friday, February 24th

• Email Aaron Swartz regarding fundraising analysis methodology
• Discuss Huggle analysis with Steven and Maryana - more namespaces

• Further breakdown of "Huggle 3" and "Huggle short 1 & 2"
• New experiments
• Visualize %decrease in edit activity after posting VS minimum edit count before posting

• Twinkle 1 Analysis

• Huggle short 1 & 2 analysis revisited:

Data Munging / Filtering: 

Only tracking edits in the first three days after posting
4 <= edits before <= Inf, (z84 vs. z85) 
5 <= edits before <= Inf, (z84 vs. z86) 
Blocks after = 0 (no blocks after seeing template), 
namespace = 0, 
first_warning = TRUE

Findings:

z85 (24 samples) had a significant (88.80% confident) difference in the decrease in edits after posting over z84 (30 samples), 68.43% decrease vs. 83.40% decrease.
z86 had a semi-significant (72.5% confident) difference in the decrease in edits after posting over z84, 64.91% decrease vs. 76.44% decrease.

Modelling Analysis, Registered Users z84 vs. z85 - R Output

Call: glm(formula = template ~ edits_decrease, family = binomial(link = "logit"), data = all_data) Deviance Residuals: Min 1Q Median 3Q Max -1.833 -1.050 -1.026 1.203 1.337 Coefficients: Estimate Std. Error z value Pr(>|z|) (Intercept) 0.8605 0.6579 1.308 0.191 edits_decrease -1.2279 0.7722 -1.590 0.112 (Dispersion parameter for binomial family taken to be 1) Null deviance: 95.524 on 68 degrees of freedom Residual deviance: 92.534 on 67 degrees of freedom AIC: 96.534 Number of Fisher Scoring iterations: 4 Percentage decrease in edits Test: Min. 1st Qu. Median Mean 3rd Qu. Max. -0.7500 0.6623 0.7778 0.6843 0.9896 1.0000 Percentage decrease in edits Control: Min. 1st Qu. Median Mean 3rd Qu. Max. -0.5000 0.8399 0.9582 0.8340 1.0000 1.0000

Modelling Analysis, Registered Users z84 vs. z86 - R Output

Call: glm(formula = template ~ edits_decrease, family = binomial(link = "logit"), data = all_data) Deviance Residuals: Min 1Q Median 3Q Max -1.5143 -1.0971 -0.1741 1.1767 1.3264 Coefficients: Estimate Std. Error z value Pr(>|z|) (Intercept) 0.8888 0.8926 0.996 0.319 edits_decrease -1.2454 1.1419 -1.091 0.275 (Dispersion parameter for binomial family taken to be 1) Null deviance: 52.679 on 37 degrees of freedom Residual deviance: 51.362 on 36 degrees of freedom AIC: 55.362 Number of Fisher Scoring iterations: 4 Percentage decrease in edits Test: Min. 1st Qu. Median Mean 3rd Qu. Max. -0.3333 0.6645 0.7143 0.6491 0.8886 0.9896 Percentage decrease in edits Control: Min. 1st Qu. Median Mean 3rd Qu. Max. 0.1000 0.7571 0.8667 0.7644 0.8889 0.9777

Next Week

• Visualize tests
• New experiments UWTEST

Monday, February 27th

• Twinkle 1 Analysis (note that we are measuring decrease in *deleted edits* here - different than the Huggle metrics)

Data Munging / Filtering: 

Only tracking edits in the first three days after posting
5 <= deleted edits before <= Inf
Blocks after = 0 (no blocks after seeing template), 
namespace = 0, 
first_warning = TRUE

Findings:

The control resulted in a significantly larger decrease in deleted edits after the posting, 83.47% vs. 57.70%.  The confidence level is 95.77%

Modelling Analysis, Registered Users - R Output

Call: glm(formula = template ~ edits_del_decrease, family = binomial(link = "logit"), data = all_data) Deviance Residuals: Min 1Q Median 3Q Max -1.9426 -1.1624 0.7303 1.1925 1.1925 Coefficients: Estimate Std. Error z value Pr(>|z|) (Intercept) 0.8435 0.3868 2.181 0.0292 * edits_del_decrease -0.8791 0.4330 -2.030 0.0423 * --- Signif. codes: 0 ‘***’ 0.001 ‘**’ 0.01 ‘*’ 0.05 ‘.’ 0.1 ‘ ’ 1 (Dispersion parameter for binomial family taken to be 1) Null deviance: 173.53 on 125 degrees of freedom Residual deviance: 167.76 on 124 degrees of freedom AIC: 171.76 Number of Fisher Scoring iterations: 4 Percentage decrease in deleted edits Test: Min. 1st Qu. Median Mean 3rd Qu. Max. -4.8000 0.5714 0.9677 0.5770 1.0000 1.0000 Percentage decrease in deleted edits Control: Min. 1st Qu. Median Mean 3rd Qu. Max. -1.0000 0.8155 1.0000 0.8347 1.0000 1.0000

Tuesday, February 28th

• Learning/brushing up on R plotting and ggplot
• Development of R scripts for composing plots of edit activity among groups during Huggle experiments

Wednesday, February 29th

• Worked on and produced plots of test vs. control edit activity for Huggle experiments
• Added first content to http://community-analytics.wikimedia.org/ - Posted discussion and plots on the change in editor activity
• updated source at [4]