who bikes - income - Google Sheets

	A	B	C	D	E	F	G	H	I	J	K	L	R	S	T
1		bike commuter counts			total worker counts
2	total	698280			137852180		103389135
3	<$5k	11690	11690		786655	786655				should go into poorer cell	should go into richer cell
4	$5k-10k	20850	20850		1489350	1489350	2,276,005	first quartile	34,463,045	2,439,660	594,725	0.8040047654
5	$10k-12,499	14460	28920		1278095	2592400	3,554,100		68,926,090	15,762,625	1,543,450	0.910814555
6	$12,500-15k	14460			1314305		4,868,405		103,389,135	9,530,200	6,574,155	0.5917778141
7	$15k-17,499	17965	33440		1733590	3429415	6,601,995		137,852,180
8	$17,500-20k	15475			1695825		8,297,820
9	$20k-22,499	21230	37790		2322990	4372640	10,620,810
10	$22,500-$25k	16560			2049650		12,670,460							bike commuters	all commuters
11	$25k-27,499	18945	34850		2589710	4900735	15,260,170						$0	11,690	786,655
12	$27,500-30k	15905			2311025		17,571,195						$5,000	20,850	1,489,350
13	$30k-$32,500	20400	36430		2991330	5624190	20,562,525						$10,000	28,920	2,592,400
14	$32,500-35k	16030			2632860		23,195,385						$15,000	33,440	3,429,415
15	$35k-37,500	17170	33170		2905950	5676470	26,101,335						$20,000	37,790	4,372,640
16	$37,500-40k	16000			2770520		28,871,855						$25,000	34,850	4,900,735
17	$40k-42,499	18775	34785		3151530	6185915	32,023,385		268,787				$30,000	36,430	5,624,190
18	$42,500-45k	16010		12872.11629	3034385		35,057,770	second quartile					$35,000	33,170	5,676,470
19	$45k-$47,499	15215	30290		2953030	5880015	38,010,800						$40,000	34,785	6,185,915
20	$47,500-50k	15075			2926985		40,937,785						$45,000	30,290	5,880,015
21	$50k-55k	29605	29605		6360400	6360400	47,298,185						$50,000	29,605	6,360,400
22	$55k-60k	26995	26995		5865280	5865280	53,163,465						$55,000	26,995	5,865,280
23	$60k-75k	72465	24155	66002.17673	17306075	5768691.667	70,469,540		156030.0604				$60,000	24,155	5,768,692
24	$75k-100k	91325	24155		23389395	5768691.667	93,858,935	third quartile		poorest quartile	268,787		$65,000	24,155	5,768,692
25	$100k-$125k	62785	24155	37154.77006	16104355	5768691.667	109,963,290	third quartile	134942.5933	second quartile	156,030		$70,000	24,155	5,768,692
26	$125k-150k	38935	18265		9770305	4677879	119,733,595	top quartile		third quartile	134942.5933		$75,000	18,265	4,677,879
27	>$150k	73755	18265		18118590	4677879	137,852,185	top quartile	138320.2299	richest quartile	138320.2299		$80,000	18,265	4,677,879
28			18265			4677879							$85,000	18,265	4,677,879
29			18265			4677879							$90,000	18,265	4,677,879
30			18265			4677879							$95,000	18,265	4,677,879
31			12557			3220871							$100,000	12,557	3,220,871
32			12557			3220871							$105,000	12,557	3,220,871
33			12557			3220871							$110,000	12,557	3,220,871
34			12557			3220871							$115,000	12,557	3,220,871
35			12557			3220871							$120,000	12,557	3,220,871
36			7787			1954061							$125,000	7,787	1,954,061
37			7787			1954061							$130,000	7,787	1,954,061
38			7787			1954061							$135,000	7,787	1,954,061
39			7787			1954061							$140,000	7,787	1,954,061
40			7787			1954061							$145,000	7,787	1,954,061
41			3687.75			905929.5							$150,000	3,688	905,930
42			3687.75			905929.5							$155,000	3,688	905,930
43			3687.75			905929.5							$160,000	3,688	905,930
44			3687.75			905929.5							$165,000	3,688	905,930
45			3687.75			905929.5							$170,000	3,688	905,930
46			3687.75			905929.5							$175,000	3,688	905,930
47			3687.75			905929.5							$180,000	3,688	905,930
48			3687.75			905929.5							$185,000	3,688	905,930
49			3687.75			905929.5							$190,000	3,688	905,930
50			3687.75			905929.5							$195,000	3,688	905,930
51			3687.75			905929.5							$200,000	3,688	905,930
52			3687.75			905929.5							$205,000	3,688	905,930
53			3687.75			905929.5							$210,000	3,688	905,930
54			3687.75			905929.5							$215,000	3,688	905,930
55			3687.75			905929.5							$220,000	3,688	905,930
56			3687.75			905929.5							$225,000	3,688	905,930
57			3687.75			905929.5							$230,000	3,688	905,930
58			3687.75			905929.5							$235,000	3,688	905,930
59			3687.75			905929.5							$240,000	3,688	905,930
60			3687.75			905929.5							$245,000	3,688	905,930
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100