Seattle bike counter analysis

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD
1		2012	2012c	2013	2013c	2014	2014c	2015	2015c	2016	2016c	2017	2017c	2018	2018c	2019	2019c	2020	2020c	2021	2021c	2022	2022c	2023	2023c
2	Ja			44884	44884	59873	59873	60630	60630	51733	51733	49805	49805	58591	58591	72883	72883	58986	58986	35616	35616	34316	34316	47629	47629
3	F			50027	94911	47025	106898	58659	119289	60381	112114	42001	91806	50677	109268	36099	108982	72457	131443	29479	65095	38476	72792	40366	87995
4	Mr			66089	161000	63494	170392	71144	190433	69804	181918	58747	150553	77284	186552	85457	194439	57897	189340	50200	115295	56375	129167	60118	148113
5	Ap			71998	232998	86855	257247	83697	274130	93639	275557	68413	218966	79947	266499	87932	282371	65375	254715	69345	184640	63188	192355	60494	208607
6	My			108574	341572	118644	375891	107775	381905	114159	389716	109089	328055	129813	396312	129123	411494	72668	327383	73033	257673	73495	265850	105039	313646
7	Jn			99280	440852	110907	486798	113717	495622	107617	497333	107801	435856	113145	509457	132512	544006	75787	403170	77473	335146	85259	351109
8	Jl			117974	558826	120669	607467	112780	608402	105683	603016	118904	554760	128018	637475	137714	681720	88177	491347	93994	429140	99891	451000
9	Au			104549	663375	112490	719957	103351	711753	112380	715396	120188	674948	111809	749284	142414	824134	88351	579698	86354	515494	104137	555137
10	S			80729	744104	97558	817515	91140	802893	94157	809553	96498	771446	96242	845526	112174	936308	58143	637841	74366	589860	90964	646101
11	O			81352	825456	83184	900699	83003	885896	69883	879436	88143	859589	90982	936508	104498	1040806	58751	696592	58181	648041	74451	720552
12	N	50647	50647	59270	884726	56990	957689	56668	942564	64097	943533	57684	917273	68431	1004939	84963	1125769	39920	736512	40130	688171	49895	770447
13	D	36369	87016	43553	928279	48507	1006196	43992	986556	38937	982470	45862	963135	46941	1051880	61377	1187146	36077	772589	27459	715630	26990	797437
14
15																							Month	Avg	Pct. max	stdev	stdev/mean	median	IQR	IQR/median
16																							Ja	52,267.82	46.51%	11,488.29	21.98%	51,733.00	13,173.00	25.46%
17		12m rolling																					F	47,786.09	42.52%	12,435.45	26.02%	47,025.00	15,247.00	32.42%
18	O13	912472																					Mr	65,146.27	57.97%	10,199.26	15.66%	63,494.00	12,152.00	19.14%
19	N13	921095																					Ap	75,534.82	67.21%	11,309.83	14.97%	71,998.00	18,382.00	25.53%
20	D13	928279																					My	103,764.73	92.33%	21,325.74	20.55%	108,574.00	27,134.50	24.99%
21	Ja14	943268																					Jn	102,349.80	91.07%	17,988.11	17.58%	107,709.00	23,821.25	22.12%
22	F14	940266																					Jl	112,380.40	100.00%	15,469.46	13.77%	115,377.00	18,888.75	16.37%
23	Mr14	937671																					Au	108,602.30	96.64%	15,937.98	14.68%	108,179.00	8,915.00	8.24%
24	Ap14	952528																					S	89,197.10	79.37%	14,863.46	16.66%	92,648.50	13,146.25	14.19%
25	My14	962598																					O	79,242.80	70.51%	14,387.68	18.16%	82,177.50	15,878.25	19.32%
26	Jn14	974225																					N	57,154.09	50.86%	12,789.06	22.38%	56,990.00	11,412.50	20.03%
27	Jl14	976920																					D	41,460.36	36.89%	9,865.23	23.79%	43,553.00	10,178.50	23.37%
28	Au14	984861
29	S14	1001690
30	O14	1003522
31	N14	1001242
32	D14	1006196
33	Ja15	1006953
34	F15	1018587
35	Mr15	1026237
36	Ap15	1023079
37	My15	1012210
38	Jn15	1015020
39	Jl15	1007131
40	Au15	997992
41	S15	991574
42	O15	991393
43	N15	991071
44	D15	986556
45	Ja16	977659
46	F16	979381
47	Mr16	978041
48	Ap16	987983
49	My16	994367
50	Jn16	988267
51	Jl16	981170
52	Au16	990199
53	S16	993216
54	O16	980096
55	N16	987525
56	D16	982470
57	Ja17	980542
58	F17	962162
59	Mr17	951105
60	Ap17	925879
61	My17	920809
62	Jn17	920993
63	Jl17	934214
64	Au17	942022
65	S17	944363
66	O17	962623
67	N17	956210
68	D17	963135
69	Ja18	971921
70	F18	980597
71	Mr18	999134
72	Ap18	1010668
73	My18	1031392
74	Jn18	1036736
75	Jl18	1045850
76	Au18	1037471
77	S18	1037215
78	O18	1040054
79	N18	1050801
80	D18	1051880
81	Ja19	1066172
82	F19	1051594
83	Mr19	1059767
84	Ap19	1067752
85	My19	1067062
86	Jn19	1086429
87	Jl19	1096125
88	Au19	1126730
89	S19	1142662
90	O19	1156178
91	N19	1172710
92	D19	1187146
93	Ja20	1173249
94	F20	1209607
95	Mr20	1182047
96	Ap20	1159490
97	My20	1103035
98	Jn20	1046310
99	Jl20	996773
100	Au20	942710