2019 Healthcare Expenditure and Income_Clean1.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1	Person Number	Age	Person's Wage Income	Wage Imputation Flag	Person's Total Income	Total Healthcare Expenditure	Total Healthcare Expenditure as Portion of Total Income	Out of Pocket	Out of Pocket Expenditure as Portion of Total Income	Private Insurance	Medicare	Medicaid	Veteran's Administration	Tricare	Other Federal Sources	State and Local	Total Government Expenditure	Worker's Comp and Unclassified Sources
2	1	32	40000	1	40000	0	#DIV/0!	0	0	0	0	0	0	0	0	0	0	0
3	2	42	40000	1	40000	54	0.00135	0	0	54	0	0	0	0	0	0	0	0
4	3	16	0	1	0	7827	#DIV/0!	320	#DIV/0!	7507	0	0	0	0	0	0	0	0
5	4	72	0	1	0	615	#DIV/0!	18	#DIV/0!	0	3	0	594	0	0	0	597	0
6	5	83	0	1	0	2452	#DIV/0!	459	#DIV/0!	0	1775	0	211	7	0	0	1993	0
7	6	46	0	1	7581	8663	1.142725234	74	0.009761245218	1555	0	0	0	0	0	0	0	0
8	7	21	10000	1	10000	269	0.0269	269	0.0269	0	0	0	0	0	0	0	0	0
9	8	20	0	1	6156	20	0.003248862898	0	0	0	0	20	0	0	0	0	20	0
10	9	33	32058	4	32058	14206	0.443134319	6164	0.1922764988	8043	0	0	0	0	0	0	0	0
11	10	79	0	1	87411	5766	0.06596423791	1036	0.01185205523	4099	630	0	0	0	0	0	630	0
12	11	85	9252	1	18504	11924	0.6444012105	149	0.008052313013	0	1247	10528	0	0	0	0	11775	0
13	12	57	0	1	6000	3834	0.639	188	0.03133333333	1641	0	0	0	0	0	1890	1890	0
14	13	71	0	1	19000	20324	1.069684211	1491	0.07847368421	2915	15851	66	0	0	0	0	15917	0
15	14	19	0	1	0	760	#DIV/0!	35	#DIV/0!	158	0	525	0	43	0	0	568	0
16	15	25	29000	1	29000	9356	0.3226206897	1058	0.03648275862	8298	0	0	0	0	0	0	0	0
17	16	46	18920	4	19920	1373	0.06892570281	385	0.01932730924	988	0	0	0	0	0	0	0	0
18	17	20	27118	1	27118	694	0.02559185781	70	0.002581311306	619	0	0	0	0	0	5	5	0
19	18	46	100340	4	101340	67833	0.6693605684	3375	0.03330373002	62224	0	0	0	0	0	2234	2234	0
20	19	56	0	1	11474	9055	0.7891755273	1267	0.1104235663	0	7773	15	0	0	0	0	7788	0
21	20	52	0	1	11340	1158	0.1021164021	373	0.03289241623	0	681	104	0	0	0	0	785	0
22	21	19	3552	1	3552	2185	0.6151463964	180	0.05067567568	0	0	2005	0	0	0	0	2005	0
23	22	24	14000	2	14000	3160	0.2257142857	188	0.01342857143	2972	0	0	0	0	0	0	0	0
24	23	42	0	1	0	2862	#DIV/0!	641	#DIV/0!	2223	0	0	0	0	0	0	0	0
25	24	39	41000	1	41000	3365	0.08207317073	1702	0.04151219512	1663	0	0	0	0	0	0	0	0
26	25	8	0	1	0	6033	#DIV/0!	1	#DIV/0!	5796	0	236	0	0	0	0	236	0
27	26	6	0	1	0	5258	#DIV/0!	1	#DIV/0!	3985	0	1272	0	0	0	0	1272	0
28	27	85	0	1	17130	57838	3.376415645	4189	0.2445417396	2072	51578	0	0	0	0	0	51578	0
29	28	-1	0	1	17130	8668	0.506012843	366	0.02136602452	2858	5279	0	0	0	0	165	5444	0
30	29	28	0	2	0	178	#DIV/0!	28	#DIV/0!	150	0	0	0	0	0	0	0	0
31	30	30	34757	2	34757	0	0	0	0	0	0	0	0	0	0	0	0	0
32	31	6	0	1	0	17505	#DIV/0!	654	#DIV/0!	0	0	16851	0	0	0	0	16851	0
33	32	3	0	1	0	76	#DIV/0!	1	#DIV/0!	0	0	75	0	0	0	0	75	0
34	33	1	0	1	0	166	#DIV/0!	26	#DIV/0!	0	0	140	0	0	0	0	140	0
35	34	41	672	5	1980	0	0	0	0	0	0	0	0	0	0	0	0	0
36	35	37	82368	5	82368	578	0.007017288267	261	0.003168706294	317	0	0	0	0	0	0	0	0
37	36	18	20000	1	20000	3852	0.1926	90	0.0045	3762	0	0	0	0	0	0	0	0
38	37	13	0	1	0	140	#DIV/0!	0	#DIV/0!	140	0	0	0	0	0	0	0	0
39	38	12	0	1	0	0	#DIV/0!	0	#DIV/0!	0	0	0	0	0	0	0	0	0
40	39	9	0	1	0	29	#DIV/0!	0	#DIV/0!	29	0	0	0	0	0	0	0	0
41	40	85	0	1	54585	12946	0.2371713841	321	0.005880736466	254	12371	0	0	0	0	0	12371	0
42	41	45	57996	2	57996	802	0.0138285399	199	0.003431271122	603	0	0	0	0	0	0	0	0
43	42	38	57996	2	57996	11920	0.205531416	1973	0.03401958756	9947	0	0	0	0	0	0	0	0
44	43	19	0	1	0	3820	#DIV/0!	3775	#DIV/0!	45	0	0	0	0	0	0	0	0
45	44	16	0	1	0	879	#DIV/0!	54	#DIV/0!	749	0	76	0	0	0	0	76	0
46	45	54	37000	1	37000	2252	0.06086486486	167	0.004513513514	2085	0	0	0	0	0	0	0	0
47	46	21	3600	4	3600	600	0.1666666667	250	0.06944444444	350	0	0	0	0	0	0	0	0
48	47	11	0	1	0	4310	#DIV/0!	2341	#DIV/0!	1969	0	0	0	0	0	0	0	0
49	48	33	40000	1	40000	678	0.01695	25	0.000625	653	0	0	0	0	0	0	0	0
50	49	31	37440	4	37440	29902	0.7986645299	167	0.004460470085	25506	0	0	0	0	0	0	0	0
51	50	11	0	1	0	130	#DIV/0!	0	#DIV/0!	0	0	130	0	0	0	0	130	0
52	51	52	0	1	8800	30758	3.495227273	1876	0.2131818182	0	11137	17745	0	0	0	0	28882	0
53	52	1	0	1	0	152	#DIV/0!	0	#DIV/0!	4	0	149	0	0	0	0	149	0
54	53	35	54600	4	54600	1109	0.02031135531	126	0.002307692308	983	0	0	0	0	0	0	0	0
55	54	36	53248	4	53248	9862	0.1852088341	901	0.01692082332	8962	0	0	0	0	0	0	0	0
56	55	4	0	1	0	6289	#DIV/0!	167	#DIV/0!	6122	0	0	0	0	0	0	0	0
57	56	81	31000	1	137794	12556	0.09112152924	1872	0.01358549719	10444	207	0	0	34	0	0	241	0
58	57	81	0	1	88533	4767	0.05384432923	289	0.003264319519	4376	102	0	0	0	0	0	102	0
59	58	50	56000	1	56000	0	0	0	0	0	0	0	0	0	0	0	0	0
60	59	48	12000	1	12000	0	0	0	0	0	0	0	0	0	0	0	0	0
61	60	18	0	1	0	0	#DIV/0!	0	#DIV/0!	0	0	0	0	0	0	0	0	0
62	61	16	0	1	0	0	#DIV/0!	0	#DIV/0!	0	0	0	0	0	0	0	0	0
63	62	14	0	1	0	0	#DIV/0!	0	#DIV/0!	0	0	0	0	0	0	0	0	0
64	63	11	0	1	0	0	#DIV/0!	0	#DIV/0!	0	0	0	0	0	0	0	0	0
65	64	61	56000	1	73997	37134	0.5018311553	756	0.0102166304	33392	2985	0	0	0	0	0	2985	0
66	65	29	35000	2	35000	7296	0.2084571429	5738	0.1639428571	1557	0	0	0	0	0	0	0	0
67	66	61	17594	1	17632	7824	0.443738657	4163	0.2361048094	3660	0	0	0	0	0	0	0	0
68	67	52	35959	1	35997	753	0.02091840987	127	0.003528071784	626	0	0	0	0	0	0	0	0
69	68	85	0	1	15683	30083	1.918191673	777	0.04954409233	3044	26200	0	0	61	0	0	26261	0
70	69	60	31200	4	31200	522	0.01673076923	70	0.002243589744	453	0	0	0	0	0	0	0	0
71	70	30	235928	1	235979	1347	0.005708135046	789	0.003343517855	558	0	0	0	0	0	0	0	0
72	71	31	113000	1	113050	4288	0.03793011942	2696	0.02384785493	1592	0	0	0	0	0	0	0	0
73	72	85	0	4	36000	332	0.009222222222	232	0.006444444444	0	100	0	0	0	0	0	100	0
74	73	37	36000	1	36000	4318	0.1199444444	1705	0.04736111111	2613	0	0	0	0	0	0	0	0
75	74	58	0	1	48597	7692	0.1582813754	1003	0.0206391341	0	6689	0	0	0	0	0	6689	0
76	75	63	0	1	24000	19116	0.7965	1935	0.080625	0	17163	0	0	0	0	0	17163	0
77	76	38	18000	1	18000	9681	0.5378333333	2627	0.1459444444	6647	0	0	0	0	0	0	0	0
78	77	49	32000	1	32000	14327	0.44771875	1518	0.0474375	12809	0	0	0	0	0	0	0	0
79	78	60	0	1	11347	1431	0.1261126289	5	0.0004406451044	0	0	1426	0	0	0	0	1426	0
80	79	29	38000	1	38000	1556	0.04094736842	369	0.009710526316	1187	0	0	0	0	0	0	0	0
81	80	28	48000	1	48000	788	0.01641666667	0	0	788	0	0	0	0	0	0	0	0
82	81	10	0	1	0	518	#DIV/0!	0	#DIV/0!	518	0	0	0	0	0	0	0	0
83	82	8	0	1	0	480	#DIV/0!	0	#DIV/0!	480	0	0	0	0	0	0	0	0
84	83	3	0	1	0	11549	#DIV/0!	4879	#DIV/0!	6670	0	0	0	0	0	0	0	0
85	84	63	34287	1	34292	9406	0.2742913799	2726	0.07949375948	6681	0	0	0	0	0	0	0	0
86	85	60	60312	1	60317	123239	2.043188487	7186	0.119137225	116053	0	0	0	0	0	0	0	0
87	86	30	60000	1	60000	85	0.001416666667	0	0	85	0	0	0	0	0	0	0	0
88	87	29	65000	1	65000	0	0	0	0	0	0	0	0	0	0	0	0	0
89	88	57	0	1	15000	3065	0.2043333333	323	0.02153333333	1041	1701	0	0	0	0	0	1701	0
90	89	85	0	1	14324	100	0.006981290142	0	0	0	100	0	0	0	0	0	100	0
91	90	31	28500	1	28500	220	0.007719298246	0	0	0	0	220	0	0	0	0	220	0
92	91	53	43056	4	46062	42183	0.915787417	1166	0.02531370761	40884	0	0	0	0	0	134	134	0
93	92	62	25000	4	43356	273	0.006296706338	73	0.001683734662	199	0	0	0	0	0	0	0	0
94	93	29	54841	1	54841	184	0.003355153991	25	0.0004558633139	159	0	0	0	0	0	0	0	0
95	94	-1	0	4	13600	19296	1.418823529	0	0	0	19296	0	0	0	0	0	19296	0
96	95	74	36000	1	52000	11985	0.2304807692	628	0.01207692308	373	10984	0	0	0	0	0	10984	0
97	96	85	0	1	63095	11677	0.1850701323	9339	0.1480148982	0	2338	0	0	0	0	0	2338	0
98	97	53	20000	1	20000	0	0	0	0	0	0	0	0	0	0	0	0	0
99	98	41	40000	1	40000	0	0	0	0	0	0	0	0	0	0	0	0	0
100	99	5	0	1	0	190	#DIV/0!	0	#DIV/0!	0	0	190	0	0	0	0	190	0