FINAL-Data-for-2016-FIO-US-Auto-Affordability-Analysis-1.xlsx

	A	B	C	D	E	F	G	H	I	J
1			AP ZIP Codes Generally				AP ZIP Codes – Affordability Index > 2%
2	State	# ZIP Codes	Total #	% State	Total Population	% State Pop.	Total #	% State AP ZIP Codes	Total Population	% State Affected Persons Pop.
3	State	# ZIP Codes	Total #	ZIP Codes	Total Population	% State Pop.	Total #	% State AP ZIP Codes	Total Population	% State Affected Persons Pop.
4	AK	238	160	67.20%	157,014	21.60%	-	0.00%	-	0.00%
5	AL	642	229	35.70%	1,478,597	30.70%	11	4.80%	52,273	3.50%
6	AR	591	170	28.80%	569,706	19.30%	7	4.10%	17,125	3.00%
7	AZ	405	166	41.00%	2,456,770	37.40%	13	7.80%	198,707	8.10%
8	CA	1,763	893	50.70%	24,915,144	65.50%	6	0.70%	98,417	0.40%
9	CO	525	123	23.40%	1,292,051	24.90%	-	0.00%	-	0.00%
10	CT	282	51	18.10%	1,049,902	29.20%	19	37.30%	434,518	41.40%
11	DC	53	12	22.60%	408,414	64.40%	3	25.00%	143,984	35.30%
12	DE	67	7	10.40%	146,590	16.00%	3	42.90%	82,333	56.20%
13	FL	983	323	32.90%	7,921,414	40.90%	95	29.40%	2,856,314	36.10%
14	GA	735	294	40.00%	4,518,269	45.60%	10	3.40%	188,235	4.20%
15	HI	94	81	86.20%	1,340,036	96.20%	-	0.00%	-	0.00%
16	IA	934	118	12.60%	393,351	12.80%	-	0.00%	-	0.00%
17	ID	278	54	19.40%	113,121	7.10%	1	1.90%	913	0.80%
18	IL	1,383	286	20.70%	4,226,070	32.80%	10	3.50%	78,455	1.90%
19	IN	775	142	18.30%	1,412,167	21.60%	4	2.80%	38,460	2.70%
20	KS	698	111	15.90%	536,093	18.60%	4	3.60%	32,417	6.00%
21	KY	768	231	30.10%	890,428	20.40%	99	42.90%	429,806	48.30%
22	LA	515	183	35.50%	1,539,121	33.50%	44	24.00%	604,509	39.30%
23	MA	537	94	17.50%	1,862,527	28.00%	-	0.00%	-	0.00%
24	MD	468	146	31.20%	2,701,458	45.90%	10	6.80%	334,269	12.40%
25	ME	432	55	12.70%	120,135	9.00%	-	0.00%	-	0.00%
26	MI	987	195	19.80%	2,369,870	24.00%	77	39.50%	1,706,039	72.00%
27	MN	885	137	15.50%	829,108	15.40%	5	3.60%	95,275	11.50%
28	MO	1,024	268	26.20%	1,512,925	25.10%	24	9.00%	349,448	23.10%
29	MS	423	203	48.00%	1,108,069	37.10%	4	2.00%	9,546	0.90%
30	MT	361	103	28.50%	93,051	9.20%	-	0.00%	-	0.00%
31	NC	808	277	34.30%	3,233,072	33.20%	-	0.00%	-	0.00%
32	ND	383	47	12.30%	60,908	8.70%	-	0.00%	-	0.00%
33	NE	581	90	15.50%	295,529	15.90%	3	3.30%	46,694	15.80%
34	NH	248	47	19.00%	261,362	19.80%	-	0.00%	-	0.00%
35	NJ	595	143	24.00%	3,438,632	38.70%	82	57.30%	2,309,120	67.20%
36	NM	368	228	62.00%	1,354,026	65.20%	5	2.20%	2,845	0.20%
37	NV	175	64	36.60%	1,395,364	50.50%	6	9.40%	223,268	16.00%
38	NY	1,794	403	22.50%	8,657,611	44.20%	115	28.50%	5,233,053	60.40%
39	OH	1,197	277	23.10%	2,650,639	22.90%	41	14.80%	503,008	19.00%
40	OK	648	166	25.60%	850,198	22.30%	4	2.40%	34,350	4.00%
41	OR	417	68	16.30%	537,993	13.80%	4	5.90%	76,739	14.30%
42	PA	1,798	354	19.70%	2,585,456	20.30%	35	9.90%	1,067,469	41.30%
43	RI	77	11	14.30%	274,741	26.10%	6	54.50%	171,402	62.40%
44	SC	424	192	45.30%	1,594,317	33.70%	7	3.60%	9,720	0.60%
45	SD	371	89	24.00%	105,274	12.60%	1	1.10%	1,349	1.30%
46	TN	629	172	27.30%	1,735,983	26.90%	12	7.00%	167,167	9.60%
47	TX	1,935	801	41.40%	14,512,014	55.60%	32	4.00%	873,405	6.00%
48	UT	288	58	20.10%	356,561	12.50%	3	5.20%	14,943	4.20%
49	VA	896	298	33.30%	2,728,933	33.30%	7	2.30%	7,908	0.30%
50	VT	255	45	17.60%	102,499	16.40%	0	0.00%	-	0.00%
51	WA	598	164	27.40%	1,488,096	21.60%	5	3.00%	29,378	2.00%
52	WI	774	117	15.10%	921,005	16.10%	4	3.40%	93,626	10.20%
53	WV	706	191	27.10%	247,597	13.40%	24	12.60%	18,725	7.60%
54	WY	178	35	19.70%	46,074	8.00%	0	0.00%	-	0.00%
55	Total	32,989	9,172	27.80%	115,395,285	36.70%	845	9.20%	18,635,212	16.10%
56
57
58
59
60
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