User:Ixtal/Analysis on administrators' activity

Let's do some data analysis babyy! Note: averages do not include users from the cohort with no edits in target year, so concerns about bias (e.g. survivorship bias) remain. Data for 2024 is not included as only partial data was available at time of writing.

Average edits per admin cohort, yearly

Year of Adminship / Average Edits	2006	2007	2008	2009	2010	2011	2012	2013	2014	2015	2016	2017	2018	2019	2020	2021	2022	2023
pre2006	7214	4398	3416	4119	3115	2973	2240	1979	1726	1925	2343	2387	1862	2966	2299	1849	1499	1410
2006	10419	6112	3422	2286	2016	1616	1427	1224	1030	851	1379	1740	2020	4943	3761	1935	4659	1059
2007	5357	10660	6790	4833	3845	3061	3435	2731	2510	2383	2368	2311	2392	1953	2957	2132	1669	1845
2008													3435	3369	2491	2200	1620	1839
2009													3747	4423	4309	5577	4012	3853
2010													3834	4132	4378	5338	3922	3281
2011													2638	2573	2030	2139	1845	2703
2012													5396	5290	3889	3378	4180	3458
2013													4883	5482	4444	4443	4223	5947
2014													7389	6806	6020	4725	3134	3464
2015													11678	18038	18377	6452	20574	12255
2016													3060	4098	9973	7481	6363	4395
2017													2402	3465	4142	6009	4846	3558
2018													4794	5078	4956	3532	7241	5190
2019													2427	3080	2958	3173	5484	8051
2020													4697	5998	8797	12674	7910	6958
2021													7478	10236	11107	7439	10625	8329
2022													2059	1342	1381	1867	1410	1725
2023													1258	620	1642	671	683	1756

Median edits per admin cohort, yearly

Year of Adminship / Mean Edits	2006	2007	2008	2009	2010	2011	2012	2013	2014	2015	2016	2017	2018	2019	2020	2021	2022	2023
pre2006															39	50	70	56
2006	8022	3200	774	308	133	90.5	60	38	33	30	25	24			30	28	59	41
2007	4010	8622	3571	2060	1246	612	473	360	151	180	127	139	112	97	96	74	95	91
2008									229	247	117	123	144	105	174	195	134	152
2009									401	201	217	169	168	143	157	149	150	107
2010									941	1099	595	773	578	338	195	193	310	393
2011									869	860	394	304	389	235	284	114	392	153
2012									889	1615	331	672	329	143	284	107	146	317
2013									1600	1356	732	769	918	852	556	490	779	532
2014									2220	1557	823	473	344	156	74	61	103	229
2015									3700	2843	1552	1852	2146	1657	755	537	503	660
2016									228	383	2686	1002	1281	513	1034	1005	1126	1372
2017									161	321	149	2543	1046	779	172	659	503	462
2018									227	617	554	146	4429	1493	1171	1303	997	984
2019									181	220	318	173	461	3636	3296	1481	910	1803
2020									227	357	216	121	95	870	3676	1014	983	694
2021									1556	2521	2625	2433	1960	2112	2158	2652	1358	1327
2022									73	22	95	36	82	57	100	31	4175	2353
2023									46	61	889	82	136	234	755	4530	11755	7710

Discussion

Median is included to account for outliers affecting the average. Data taken from this quarry query. Processed using code from this github repository.

Thanks

Users Cryptic, Novem Linguae, BilledMammal, Galobtrotter, Pppery and BD2412 helped in making the query in this thread. Particular thanks go to Cryptic and Novem Linguae.