This assignment is a Research Paper: "Economic and Social Cost of the Opioid Crisis in the US: A...

Question

This assignment is a Research Paper: "Economic and Social Cost of the Opioid Crisis in the US: A State Level Analysis Using Panel Data". It requires data to be collected in panel data format, doing calculations, using Stata to run regression commands, and writing a professional paper.

It’s very important that the analysis is done right and the paper is written up professionally! Please follow the Econ 690 Research Project PowerPoint file to gain understanding about the research and analysis. Please use the Opioid Paper Format PDF
file know how to section the paper.

Files given:

· Six articles are attached to gain understanding about the subject.

· A PowerPoint file - It has the Opioid research paper guidelines.

· Five videos are attached with the instructor going over the Opioid research paper development.

· Attached is an EXCEL file for you to get started organizing the data in a panel data format.An additional EXCEL file was given by the instructor with the % HS graduate data for the years 2000-2009.

· An EXCEL file - Sample OPOID Simulation file for calculations.

· Word file - List of Variables to Consider and Possible URL links to get the data.

· PDF file - Coefficient Interpretations file, given by the instructor.

· Word file - Has the Final Model Regressions Commands the instructor wants us to run in Stata.

· PDF file - Opioid Paper Format

Please take a look at this assignment in detail, and ask any questions ahead of time. Thanks!

datafiles-f4utlq5s.zip articles-vaficza0.zip regression-for-stata-0lui2p3q.zip research-paper-guidelines-ns3et00h.zip

Komalavalli · Accepted Answer

Sheet1
	state	stateid	year	t	mcarespendml	medicaidspending	overdoses	population	income	stategdp	unemploymentrate	lfpr	pctinsured	pcthsg	pctcg	cpi
	Alabama	1	2000	0	2503	3690	43	71234768	35,160	157221.3	4.6	63.6	4388.4975140952	77.5		157,221.30
	Alabama	1	2001	1	2608	4065	57	71482144	35,424	156853.2	6.3	73.3	4439.7942437697	80.2		156,853.20		mcarespendml		medicaidspending		overdoses		population		income		stategdp		unemploymentrate		lfpr		pctinsured		pcthsg		pctcg		cpi
	Alabama	1	2002	2	2855	4394	71	71681424	36,629	160422.4	4.0	65.2	4426.7234836863	78.9		160,422.40
	Alabama	1	2003	3	3176	4756	49	72055856	37,150	165134.7	4.2	62.2	4524.2953	79.9		165,134.70		Mean	6095.1333333333	Mean	7828.2065359477	Mean	457.5757575758	Mean	83754104.5276292	Mean	51214.9133126935	Mean	412774.499277606	Mean	5.6138286894	Mean	65.7133126935	Mean	5608.0192777301	Mean	86.0908734403	Mean		Mean	306830.363467492
	Alabama	1	2004	4	3360	5274	83	72491664	37,255	176625	4.9	67.0	4531.9050474	82.4		176,625.00		Standard Error	301.1383416045	Standard Error	345.2188026321	Standard Error	17.7433963147	Standard Error	3929643.89437123	Standard Error	330.5306903147	Standard Error	19446.7192097863	Standard Error	0.0642463917	Standard Error	0.1355893137	Standard Error	190.8935243309	Standard Error	0.1677692326	Standard Error	65535	Standard Error	12075.3696353508
	Alabama	1	2005	5	3689	5698	80	73116880	37,603	184369.5	2.7	72.2	4570.2884245	80.9		184,369.50		Median	3689	Median	4746	Median	286	Median	67507824	Median	49855	Median	220696.7	Median	5.2	Median	66	Median	4106.4735652	Median	86.8	Median		Median	184369.5
	Alabama	1	2006	6	3578	6732	124	74063696	37,952	187270.8	2.1	67.9	4720.2538157	82.1		187,270.80		Mode	1091	Mode	418	Mode	29	Mode	256760240	Mode	50602	Mode		Mode	4.5	Mode	61.6	Mode	6294.7827061	Mode	89.7	Mode		Mode
	Alabama	1	2007	7	3559	7135	165	74765440	39,980	189002.5	3.6	69.2	4669.0528541	82.1		189,002.50		Standard Deviation	8329.0749846547	Standard Deviation	9548.28029508	Standard Deviation	548.8993568319	Standard Deviation	93075339.0410976	Standard Deviation	10289.0121287446	Standard Deviation	605352.349046007	Standard Deviation	1.9999108181	Standard Deviation	4.2207278594	Standard Deviation	5942.279626954	Standard Deviation	3.7887627091	Standard Deviation		Standard Deviation	375891.34164491
	Alabama	1	2008	8	3863	7659	185	75491296	40,933	186946.7	5.7	67.7	4765.2997112	80.8		186,946.70		Sample Variance	69373490.1	Sample Variance	91169656.5934127	Sample Variance	301290.503930519	Sample Variance	8.66301873761527E15	Sample Variance	105863770.585453	Sample Variance	366451466495.519	Sample Variance	3.9996432805	Sample Variance	17.8145436635	Sample Variance	35310687.164912	Sample Variance	14.3547228659	Sample Variance		Sample Variance	141294300723.611
	Alabama	1	2009	9	4164	8039	206	76127008	41,381	180707.2	3.8	63.4	4816.5056135	80.8		180,707.20		Kurtosis	14.0105367721	Kurtosis	8.1499795086	Kurtosis	8.514145106	Kurtosis	13.1605033182	Kurtosis	0.05303742	Kurtosis	11.7902501367	Kurtosis	0.8467010865	Kurtosis	-0.2490997377	Kurtosis	9.2842390317	Kurtosis	-0.8641655451	Kurtosis		Kurtosis	10.4721817888
	Alabama	1	2010	10	5001	8299	187	76564768	42,212	184702.4	3.5	69.0	4379.9444042165			184,702.40		Skewness	3.4526718807	Skewness	2.5991798881	Skewness	2.5462170715	Skewness	3.1852226119	Skewness	0.5888054558	Skewness	3.2402530086	Skewness	0.9675108564	Skewness	-0.2873728509	Skewness	2.6762213474	Skewness	-0.3883435851	Skewness		Skewness	2.9471760731
	Alabama	1	2011	11	4426	8621	176		42,278	187605.8	4.2	67.2	4512.26203			187,605.80		Range	61544	Range	64579	Range	4283	Range	589681008	Range	56648	Range	3889223.5	Range	11.7	Range	22	Range	37498.7566976316	Range	15.9	Range	0	Range	2620559.5
	Alabama	1	2012	12	4771	8982	165		42,590	189245.5	4.7	69.5	4717.035223			189,245.50		Minimum	217	Minimum	216	Minimum	10	Minimum	7908800	Minimum	29697	Minimum	23016.8	Minimum	2.1	Minimum	53.3	Minimum	485.9704893684	Minimum	77.1	Minimum	0	Minimum	23016.8
	Alabama	1	2013	13	4673	9289	166		43,464	191369.8	4.4	69.5	5,316			191,369.80		Maximum	61761	Maximum	64795	Maximum	4293	Maximum	597589808	Maximum	86345	Maximum	3912240.3	Maximum	13.8	Maximum	75.3	Maximum	37984.727187	Maximum	93	Maximum	0	Maximum	2643576.3
	Alabama	1	2014	14	4983	9723	270		44,476	189886.3	3.0	67.9	5,442			189,886.30		Sum	4662777	Sum	5988578	Sum	437900	Sum	46986052640	Sum	49627251	Sum	399978489.8	Sum	5439.8	Sum	63676.2	Sum	5434170.68012044	Sum	43906.3454545455	Sum	0	Sum	297318622.2
	Alabama	1	2015	15			282		44,509	191335.2	2.7	71.4	5,576			191,335.20		Count	765	Count	765	Count	957	Count	561	Count	969	Count	969	Count	969	Count	969	Count	969	Count	510	Count	0	Count	969
	Alabama	1	2016	16			343		47,221	194283.8	3.8	70.1	6,047			194,283.80
	Alabama	1	2017	17			422		47,320	197566.6	4.1	63.4	6,269			197,566.60
	Alabama	1	2018	18			381		49,936	200800.9	5.2	61.6	6,368			200,800.90
	Alaska	2	2000	0	479	216	27	10047408	50,865	39406.6	3.3	68.1	6,537	90.4		39,406.60
	Alaska	2	2001	1	582	235	14	10139424	51,113	40958.7	3.5	70.1	6,513	91.1		40,958.70
	Alaska	2	2002	2	704	260		10277392	57,363	42979	2.8	67.8	6,561	92.2		42,979.00
	Alaska	2	2003	3	845	287	11	10374624	52,847	42355.3	3.6	68.6	6,644	90.6		42,355.30
	Alaska	2	2004	4	838	350	10	10548576	55,063	44055	3.0	75.0	5,086	90.2		44,055.00
	Alaska	2	2005	5	923	373	18	10671136	55,891	45657.1	5.3	62.5	5,199	91.7		45,657.10
	Alaska	2	2006	6	928	418	29	10804832	51,837	49190.2	3.4	70.2	5,768	92		49,190.20
	Alaska	2	2007	7	919	439	15	10884800	52,774	51721	4.8	68.4	6,439	92		51,721.00
	Alaska	2	2008	8	941	484	88	10999280	56,418	51252.1	2.8	73.1	2,914	90.7		51,252.10
	Alaska	2	2009	9	1062	541	90	11182320	61,604	56215.1	4.1	70.3	2,909	90.7		56,215.10
	Alaska	2	2010	10	1160	562	62	11423760	57,848	54601.5	2.7	72.2	2,881			54,601.50
	Alaska	2	2011	11	1279	611	66		61,137	55280.3	3.7	66.6	2,852			55,280.30
	Alaska	2	2012	12	1349	644	81		62,993	58283.6	5.0	63.0	2,827			58,283.60
	Alaska	2	2013	13	1315	696	69		67,629	55354.3	4.5	62.8	2,805			55,354.30
	Alaska	2	2014	14	1359	741	76		57,431	54188.2	3.7	67.5	2,758			54,188.20
	Alaska	2	2015	15			86		63,648	54740.8	3.0	70.7	2,760			54,740.80
	Alaska	2	2016	16			94		63,989	54246.6	4.1	67.0	2,731			54,246.60
	Alaska	2	2017	17			102		75,112	54129.5	3.0	64.2	2,671			54,129.50
	Alaska	2	2018	18			68		75,723	53249.6	5.2	68.6	2,692			53,249.60
	Arizona	3	2000	0	1869	3239	235	82569376	72,472	208439.5	4.2	64.4	2,657	85.1		208,439.50
	Arizona	3	2001	1	2513	3620	265	84375632	68,734	213166.2	4.0	66.8	2,651	83.8		213,166.20
	Arizona	3	2002	2	3159	3993	320	86340080	77,987	220696.7	3.7	64.9	37,985	84.6		220,696.70
	Arizona	3	2003	3	3761	4409	340	88165824	72,231	234065.9	2.5	72.7	37,634	83.8		234,065.90
	Arizona	3	2004	4	4354	4998	344	90438464	42,704	244317.3	3.9	65.4	37,292	84.4		244,317.30
	Arizona	3	2005	5	4976	5619	375	93425232	39,783	262326	4.4	68.3	36,794	85.8		262,326.00
	Arizona	3	2006	6	5426	6668	459	96466256	43,846	274179.4	3.3	72.2	36,691	83.1		274,179.40
	Arizona	3	2007	7	5888	7247	461	98682896	45,245	283250.7	2.8	70.5	36,295	83.1		283,250.70
	Arizona	3	2008	8	6566	7862	494	100485792	41,166	280810.1	2.3	68.0	36,208	83.9		280,810.10
	Arizona	3	2009	9	7569	8466	605	101490464	39,734	257498.5	5.1	69.1	35,940	83.9		257,498.50
	Arizona	3	2010	10	7920	8938	626	102619792	46,657	260307.1	5.6	55.9	35,854			260,307.10
	Arizona	3	2011	11	7177	9586	562		45,739	266101.5	3.4	73.1	35,394			266,101.50
	Arizona	3	2012	12	7103	10083	526		46,896	271440	3.8	71.3	35,159			271,440.00
	Arizona	3	2013	13	7348	10574	527		50,602	273481.9	5.2	62.7	34,488			273,481.90
	Arizona	3	2014	14	8371	11069	589		47,215	276948.9	6.3	72.6	34,004			276,948.90
	Arizona	3	2015	15			671		49,254	282577	4.7	65.6	33,798			282,577.00
	Arizona	3	2016	16			769		48,621	291275.2	4.8	61.8	5,160			291,275.20
	Arizona	3	2017	17			928		47,044	302455.4	5.5	67.0	5,028			302,455.40
	Arizona	3	2018	18			1106		46,914	313618.7	3.8	71.6	5,001			313,618.70
	Arkansas	3	2000	0	1566	2098	20	42857408	52,248	89871.7	2.9	67.0	4,971	81.7		89,871.70
	Arkansas	3	2001	1	1888	2371	30	43065136	57,100	89789	3.6	69.7	4,916	80.5		89,789.00
	Arkansas	3	2002	2	2211	2529	90	43294832	52,611	92950.5	6.5	67.5	4,877	81		92,950.50
	Arkansas	3	2003	3	2231	2714	89	43597056	62,283	96944.5	4.4	63.2	4,803	80.9		96,944.50
	Arkansas	3	2004	4	2591	2987	127	43994976	59,700	101733.6	4.1	68.4	4,641	79.2		101,733.60
	Arkansas	3	2005	5	2724	3266	123	44497552	61,125	105980	4.3	67.0	4,524	81.4		105,980.00
	Arkansas	3	2006	6	2758	3834	140	45148176	33,339	108460.6	5.1	70.0	4,480	82.5		108,460.60
	Arkansas	3	2007	7	2982	4151	148	45578400	29,697	107606.1	5.4	68.6	4,477	82.5		107,606.10
	Arkansas	3	2008	8	3119	4392	197	45992864	34,984	106536.5	4.2	67.9	4,410	81.3		106,536.50
	Arkansas	3	2009	9	3387	4623	201	46349488	36,658	102996.6	3.3	71.9	4,341	81.3		102,996.60
	Arkansas	3	2010	10	3733	4746	189	46745696	32,002	105662	4.3	69.4	3,521			105,662.00
	Arkansas	3	2011	11	3821	4981	169		32,387	107932.5	5.2	62.9	3,517			107,932.50
	Arkansas	3	2012	12	3930	5176	169		37,057	108492.1	5.6	61.5	3,546			108,492.10
	Arkansas	3	2013	13	4043	5304	162		36,538	110752.4	3.8	67.2	3,480			110,752.40
	Arkansas	3	2014	14	4960	5536	173		38,587	111734.5	4.2	70.0	3,437			111,734.50
	Arkansas	3	2015	15			203		39,919	112351	3.8	68.1	3,476			112,351.00
	Arkansas	3	2016	16			169		40,795	112798.1	5.2	67.9	3,462			112,798.10
	Arkansas	3	2017	17			188		44,922	113885.2	3.8	75.3	3,487			113,885.20
	Arkansas	3	2018	18			208		41,302	115937.6	5.5	61.5	3,492			115,937.60
	California	4	2000	0	19898	23728	1012	543807632	39,018	1696172.4	4.5	69.9	3,421	81.2		1,696,172.40
	California	4	2001	1	23473	25705	551	551671328	39,586	1692324.1	4.6	67.1	3,382	81		1,692,324.10
	California	4	2002	2	25419	27924	1453	557949488	42,798	1722522.4	3.1	73.2	3,392	80.2		1,722,522.40
	California	4	2003	3	28393	29684	1398	564050544	45,907	1789998.5	5.2	70.5	3,370	81.1		1,789,998.50
	California	4	2004	4	30045	31615	1413	569193216	39,376	1850904.5	3.4	71.7	902	81.3		1,850,904.50
	California	4	2005	5	31871	34445	1372	573247088	49,781	1926842.1	4.2	66.2	903	80.4		1,926,842.10
	California	4	2006	6	31821	40137	1511	576339232	49,751	2002437.4	5.0	63.2	891	80.8		2,002,437.40
	California	4	2007	7	33766	42382	1657	580004976	48,829	2041192.2	4.9	62.3	884	80.8		2,041,192.20
	California	4	2008	8	36512	47460	1801	585669392	47,262	2061638.8	5.6	67.6	863	80.5		2,061,638.80
	California	4	2009	9	38972	50818	1987	591379664	46,816	1995439.7	2.8	70.7	863	80.5		1,995,439.70
	California	4	2010	10	41772	53090	1929	597589808	49,222	2036015	4.4	67.2	862			2,036,015.00
	California	4	2011	11	44634	56254	1938		51,755	2063827.5	3.6	64.5	844			2,063,827.50
	California	4	2012	12	50959	59216	1719		49,300	2113096.4	6.4	67.7	826			2,113,096.40
	California	4	2013	13	55744	62146	1948		47,437	2179229	4.8	64.9	820			2,179,229.00
	California	4	2014	14	61761	64795	2024		55,319	2256054.7	4.5	66.1	798			2,256,054.70
	California	4	2015	15			2018		56,134	2357452.9	5.3	63.4	791			2,357,452.90
	California	4	2016	16			2012		54,283	2427894.6	3.0	73.0	779			2,427,894.60
	California	4	2017	17			2199		57,528	2541769.3	4.5	64.9	633			2,541,769.30
	California	4	2018	18			2410		55,734	2643576.3	5.0	68.0	620			2,643,576.30
	Colorado	5	2000	0	1889	2264	174	69230736	60,487	231589.8	4.4	71.8	605	89.7		231,589.80
	Colorado	5	2001	1	2028	2470	192	70810992	53,367	234979.4	3.3	70.6	596	88.6		234,979.40
	Colorado	5	2002	2	2263	2729	196	71846496	57,020	235417.3	3.3	68.4	592	87.6		235,417.30
	Colorado	5	2003	3	2391	2953	213	72459712	57,014	237782.3	6.0	68.1	582	88.7		237,782.30
	Colorado	5	2004	4	2500	3296	224	73200208	63,636	240747.6	5.4	55.8	569	88.3		240,747.60
	Colorado	5	2005	5	2699	3625	295	74110208	66,637	251558.4	4.4	73.1	540	89.3		251,558.40
	Colorado	5	2006	6	2678	4227	326	75526768	60,794	257430.2	3.8	71.6	547	90		257,430.20
	Colorado	5	2007	7	2845	4508	353	76861888	70,489	266887.5	5.9	62.1	554	90		266,887.50
	Colorado	5	2008	8	3059	4857	355	78235680	70,038	270981.4	7.2	72.3	572	88.9		270,981.40
	Colorado	5	2009	9	3415	5245	397	79555120	69,759	264966.3	6.2	66.0	554	88.9		264,966.30
	Colorado	5	2010	10	3952	5547	304	80785136	49,397	267858.9	5.3	62.2	553			267,858.90
	Colorado	5	2011	11	4198	5840	418		48,240	271700.6	6.8	66.6	19,184			271,700.60
	Colorado	5	2012	12	4595	6239	407		50,886	276823.1	5.7	71.9	19,012			276,823.10
	Colorado	5	2013	13	4937	6484	433		50,449	286259.1	4.4	67.5	18,775			286,259.10
	Colorado	5	2014	14	6038	7013	517		49,940	298655.3	4.3	68.0	18,405			298,655.30
	Colorado	5	2015	15			495		48,294	312409.7	7.0	66.9	18,049			312,409.70
	Colorado	5	2016	16			536		55,697	318953.4	4.9	62.0	18,074			318,953.40
	Colorado	5	2017	17			578		55,930	329960.6	5.3	68.4	18,062			329,960.60
	Colorado	5	2018	18			564		60,233	342535.9	4.0	65.8	17,886			342,535.90
	Connecticut	6	2000	0	3139	3107	165	54588432	63,371	216157.6	5.6	69.4	17,468	88.2		216,157.60
	Connecticut	6	2001	1	3221	3450	149	54925360	61,141	218135.3	6.6	67.0	16,921	87.5		218,135.30
	Connecticut	6	2002	2	3562	3677	172	55339984	60,940	216677.7	5.2	67.9	16,429	88		216,677.70
	Connecticut	6	2003	3	3442	3892	167	55749376	58,629	219186	4.0	72.5	16,348	87.5		219,186.00
	Connecticut	6	2004	4	3897	4290	193	55937504	57,255	233426.5	5.1	70.0	16,017	88.8		233,426.50
	Connecticut	6	2005	5	3923	4499	163	56111296	60,943	238549.5	5.8	62.1	9,672	90		238,549.50
	Connecticut	6	2006	6	4042	5217	224	56279360	66,596	248233.8	6.0	60.8	9,683	88.4		248,233.80
	Connecticut	6	2007	7	4134	5500	244	56436320	70,566	257953	4.5	66.8	9,658	88.4		257,953.00
	Connecticut	6	2008	8	4743	5871	230	56729264	67,912	257756	4.8	69.9	9,671	88.2		257,756.00
	Connecticut	6	2009	9	5514	6175	216	56988912	73,034	244894.7	5.2	68.7	9,553	88.2		244,894.70
	Connecticut	6	2010	10	5561	6290	223	57233168	74,984	244354.7	6.2	66.1	9,493			244,354.70
	Connecticut	6	2011	11	5703	6570	209		74,172	238542.4	4.5	75.1	9,347			238,542.40
	Connecticut	6	2012	12	6599	6728	201		53,347	240911.9	6.4	61.1	9,045			240,911.90
	Connecticut	6	2013	13	6524	7073	439		50,172	236050.6	5.3	69.2	8,706			236,050.60
	Connecticut	6	2014	14	6994	7410	525		55,100	235780.9	4.6	66.6	8,571			235,780.90
	Connecticut	6	2015	15			685		56,835	242706.5	3.7	73.4	8,426			242,706.50
	Connecticut	6	2016	16			855		54,965	243286.7	5.7	69.4	8,289			243,286.70
	Connecticut	6	2017	17			955		53,387	247358.5	4.5	71.5	8,124			247,358.50
	Connecticut	6	2018	18			948		62,404	249998.1	5.8	66.5	1,356			249,998.10
	Delaware	7	2000	0	508	607	29	12581968	64,851	56550.2	5.5	63.1	1,340	86.1		56,550.20
	Delaware	7	2001	1	558	693	36	12731184	65,998	58372.7	6.2	63.1	1,315	84.7		58,372.70
	Delaware	7	2002	2	603	753	48	12898704	67,781	56534.5	6.9	67.0	1,251	88.5		56,534.50
	Delaware	7	2003	3	677	823	37	13088048	64,141	57300	3.4	70.7	1,258	88.7		57,300.00
	Delaware	7	2004	4	757	946	35	13292848	70,161	60069.9	5.8	66.9	1,267	86.5		60,069.90
	Delaware	7	2005	5	810	1006	29	13522400	65,415	59335.1	4.6	64.5	1,255	86.9		59,335.10
	Delaware	7	2006	6	881	1170	37	13748288	64,247	60624.3	7.5	67.4	1,279	86		60,624.30
	Delaware	7	2007	7	935	1282	45	13947984	64,682	60477.9	5.6	65.0	1,249	86		60,477.90
	Delaware	7	2008	8	1035	1433	65	14141984	72,889	58655.7	5.1	66.5	1,253	86.5		58,655.70
	Delaware	7	2009	9	1108	1504	81	14267680	75,923	61517.7	6.4	63.1	1,224	86.5		61,517.70
	Delaware	7	2010	10	1168	1580	103	14396304	69,291	60577.2	3.2	73.0	1,213			60,577.20
	Delaware	7	2011	11	1277	1687	113		72,812	62919.3	5.1	65.2	1,203			62,919.30
	Delaware	7	2012	12	1450	1755	82		74,304	62354.6	6.3	68.1	1,590			62,354.60
	Delaware	7	2013	13	1423	1878	113		72,780	60235.8	5.7	71.2	1,574			60,235.80
	Delaware	7	2014	14	1506	2004	124		49,602	64940.1	3.8	71.0	1,546			64,940.10
	Delaware	7	2015	15			133		50,365	66793.5	4.4	68.6	1,526			66,793.50
	Delaware	7	2016	16			154		48,049	63001.3	7.1	67.4	1,518			63,001.30
	Delaware	7	2017	17			250		51,235	60801.2	6.5	55.9	1,501			60,801.20
	Delaware	7	2018	18			355		49,019	61735.1	5.3	72.3	1,475			61,735.10
	DC	8	2000	0	885	566	43	9152736	49,650	85355.9	4.0	71.0	1,442	80.703030303		85,355.90
	DC	8	2001	1	862	567	46	12731184	52,438	88440.7	6.0	62.2	1,375	81.2787878788		88,440.70
	DC	8	2002	2	969	589	29	12898704	52,114	91141.5	7.7	72.3	1,360	81.8545454545		91,141.50
	DC	8	2003	3	1015	608	60	13088048	55,214	92921	5.8	65.4	1,300	82.4303030303		92,921.00
	DC	8	2004	4	1155	651	53	13292848	52,219	97463.5	5.8	62.0	1,315	83.0060606061		97,463.50
	DC	8	2005	5	1209	699	44	13522400	54,589	99480.7	6.9	65.9	1,290	83.5818181818		99,480.70
	DC	8	2006	6	1208	769	55	13748288	57,522	99805.5	6.1	72.1	6,348	84.1575757576		99,805.50
	DC	8	2007	7	1328	778	29	13947984	54,660	102738.7	5.5	67.3	6,353	84.7333333333		102,738.70
	DC	8	2008	8	1424	829	31	14141984	48,972	106768.9	4.5	66.8	6,409	85.5		106,768.90
	DC	8	2009	9	1580	860	13	14267680	50,702	105893.9	7.3	66.9	6,364	85.5		105,893.90
	DC	8	2010	10	1774	881	34	14396304	57,756	109986.5	4.5	61.3	6,295			109,986.50
	DC	8	2011	11	1952	924	51		58,046	111646.5	5.1	68.3	6,263			111,646.50
	DC	8	2012	12	1983	956	44		54,091	112157	3.9	65.5	6,337			112,157.00
	DC	8	2013	13	2185	993	60		65,012	112332.4	5.6	68.7	6,141			112,332.40
	DC	8	2014	14	2178	1023	63		64,961	114553.6	6.7	66.3	6,136			114,553.60
	DC	8	2015	15			98		62,318	116808.4	5.3	67.8	6,149			116,808.40
	DC	8	2016	16			209		41,169	119644.3	4.4	71.4	6,100			119,644.30
	DC	8	2017	17			244		41,222	120898.9	5.5	70.6	6,036			120,898.90
	DC	8	2018	18			191		43,451	123836.1	6.2	62.3	6,016			123,836.10
	Florida	9	2000	0	7193	17743	556	256760240	44,993	642708.2	6.3	60.9	3,013	84		642,708.20
	Florida	9	2001	1	8138	19417	846	256760240	45,044	660659.5	5.1	66.7	3,033	84.1		660,659.50
	Florida	9	2002	2	9484	20818	959	256760240	39,070	689974	4.8	69.3	2,985	83.3		689,974.00
	Florida	9	2003	3	10778	22454	1043	256760240	48,477	722374.5	5.7	68.0	2,995	84.7		722,374.50
	Florida	9	2004	4	11876	24818	1196	256760240	53,141	769140.5	7.1	65.7	2,990	85.9		769,140.50
	Florida	9	2005	5	12178	27107	1097	256760240	56,928	815755.8	4.8	75.0	2,970	86.8		815,755.80
	Florida	9	2006	6	11758	31344	1223	256760240	60,675	839963.8	6.1	61.5	2,919	86.7		839,963.80
	Florida	9	2007	7	12386	33295	1473	256760240	50,783	850048.6	5.7	68.6	2,909	86.7		850,048.60
	Florida	9	2008	8	13239	36343	1478	256760240	68,277	816070.2	4.7	66.4	2,906	84.9		816,070.20
	Florida	9	2009	9	14331	39169	1590	256760240	55,251	769061.1	3.9	74.0	2,921	84.9		769,061.10
	Florida	9	2010	10	15904	40532	1674	256760240	65,246	775039.5	5.3	68.1	2,903			775,039.50
	Florida	9	2011	11	16160	42642	1576		55,590	772021.3	4.5	71.3	2,861			772,021.30
	Florida	9	2012	12	16594	44546	1326		70,071	778545	5.8	66.1	2,861			778,545.00
	Florida	9	2013	13	16896	45712	1268		70,982	794842.1	5.9	63.2	4,354			794,842.10
	Florida	9	2014	14	18285	47697	1399		60,057	817233.5	6.4	62.6	4,310			817,233.50
	Florida	9	2015	15			1838		85,750	852242.4	6.7	67.3	4,286			852,242.40
	Florida	9	2016	16			2798		81,282	881539.2	3.5	71.5	4,282			881,539.20
	Florida	9	2017	17			3245		83,382	912966.2	6.2	67.0	4,256			912,966.20
	Florida	9	2018	18			3189		36,421	943463.4	5.4	64.2	4,207			943,463.40
	Georgia	10	2000	0	4339	4810	115	131636848	38,856	389727.3	8.0	67.0	4,106	82.6		389,727.30
	Georgia	10	2001	1	5517	5290	183	134032608	40,535	394317.3	5.7	64.1	4,052	82.5		394,317.30
	Georgia	10	2002	2	6197	5752	215	136132096	42,990	399413.4	5.6	67.2	4,074	82.9		399,413.40
	Georgia	10	2003	3	6786	6232	236	137964688	38,972	411685.6	7.2	63.8	4,110	85.1		411,685.60
	Georgia	10	2004	4	7393	7014	258	140308032	38,024	428555.2	3.5	73.1	4,046	85.2		428,555.20
	Georgia	10	2005	5	6909	7657	300	142814752	45,676	447152.9	5.5	64.7	3,996	85.7		447,152.90
	Georgia	10	2006	6	6252	9384	331	146493008	45,631	453032.1	6.7	68.0	4,003	84.2		453,032.10
	Georgia	10	2007	7	7027	10108	385	149599808	44,066	455904	5.6	70.9	4,467	84.2		455,904.00
	Georgia	10	2008	8	6804	10892	404	152077488	47,886	445764.6	4.4	71.0	4,506	82.9		445,764.60
	Georgia	10	2009	9	6699	11724	490	153933536	45,794	428740.7	4.3	68.4	4,418	82.9		428,740.70
	Georgia	10	2010	10	7248	12370	534	155401392	46,140	433727.2	7.2	67.3	4,453			433,727.20
	Georgia	10	2011	11	7575	13054	535		45,105	441626.7	6.6	55.3	4,335			441,626.70
	Georgia	10	2012	12	7806	13873	536		46,071	447764.7	5.6	72.3	4,197			447,764.70
	Georgia	10	2013	13	8137	14573	530		44,857	454908.9	4.3	71.3	4,212			454,908.90
	Georgia	10	2014	14	8761	15318	710		48,825	470009.7	5.6	62.1	4,088			470,009.70
	Georgia	10	2015	15			858		51,176	489182.3	7.4	71.6	4,421			489,182.30
	Georgia	10	2016	16			918		48,532	506816.2	5.0	64.8	4,429			506,816.20
	Georgia	10	2017	17			1014		54,644	524874.7	5.6	62.4	4,447			524,874.70
	Georgia	10	2018	18			866		53,086	539300.3	6.2	65.6	4,390			539,300.30
	Hawaii	11	2000	0	589	723	29	131636848	53,681	55891.1	5.6	72.7	4,366	87.4		55,891.10
	Hawaii	11	2001	1	599	824	38	19416304	42,576	55678.5	5.1	66.7	1,332	89.1		55,678.50
	Hawaii	11	2002	2	685	881	46	19416304	41,901	56990.8	4.3	66.6	1,330	87.9		56,990.80
	Hawaii	11	2003	3	738	925	43	19416304	40,984	59978.8	8.1	67.7	1,300	88.5		59,978.80
	Hawaii	11	2004	4	875	992	57	19416304	45,926	63318.1	3.8	61.6	1,300	88		63,318.10
	Hawaii	11	2005	5	981	1046	67	19416304	42,438	67123.9	5.1	67.8	1,319	87.2		67,123.90
	Hawaii	11	2006	6	889	1222	54	19416304	42,939	68759.3	3.3	65.0	1,313	88.7		68,759.30
	Hawaii	11	2007	7	1041	1296	78	19416304	49,344	70080.4	4.9	68.3	1,315	88.7		70,080.40
	Hawaii	11	2008	8	1115	1443	53	19416304	43,340	70460.8	6.2	66.4	1,320	89.5		70,460.80
	Hawaii	11	2009	9	1125	1545	57	19416304	44,117	67927.5	5.4	67.1	1,294	89.5		67,927.50
	Hawaii	11	2010	10	1362	1629	74	19416304	47,439	69628.1	4.5	71.0	1,283			69,628.10
	Hawaii	11	2011	11	1416	1746	77		48,641	70646.6	5.5	71.1	1,269			70,646.60
	Hawaii	11	2012	12	1280	1848	62		49,555	71905.3	5.5	62.0	1,279			71,905.30
	Hawaii	11	2013	13	1470	1908	69		45,973	73063.2	5.7	60.8	1,269			73,063.20
	Hawaii	11	2014	14	1770	2036	59		48,121	73512.4	4.7	66.2	5,899			73,512.40
	Hawaii	11	2015	15			62		46,227	75869.5	4.6	68.6	5,812			75,869.50
	Hawaii	11	2016	16			77		50,768	77303.9	5.1	67.4	5,789			77,303.90
	Hawaii	11	2017	17			53		53,527	78941.6	7.0	65.6	5,667			78,941.60
	Hawaii	11	2018	18			59		46,992	79854.7	4.6	74.3	5,539			79,854.70
	Idaho	12	2000	0	598	727	28	20790880	55,821	47295.4	6.1	61.6	5,565	86.2		47,295.40
	Idaho	12	2001	1	706	807	51	21119392	57,985	46084.5	5.9	68.3	5,613	87.3		46,084.50
	Idaho	12	2002	2	750	866	45	21445952	57,016	47056.8	4.5	66.6	5,569	86.8		47,056.80
	Idaho	12	2003	3	812	936	54	21814080	47,439	48593.7	3.9	74.0	5,550	88.2		48,593.70
	Idaho	12	2004	4	963	1036	47	22268832	51,546	51815.1	4.4	67.1	5,493	87.9		51,815.10
	Idaho	12	2005	5	987	1144	50	22851856	56,242	56043	3.8	71.0	5,458	89.1		56,043.00
	Idaho	12	2006	6	1006	1381	70	23498704	59,586	57613.7	4.9	65.9	5,326	88.9		57,613.70
	Idaho	12	2007	7	1091	1472	62	24081680	51,834	58670.9	5.6	63.0	5,261	88.9		58,670.90
	Idaho	12	2008	8	1153	1598	72	24549120	47,303	60309.5	5.8	62.7	6,575	87.7		60,309.50
	Idaho	12	2009	9	1253	1735	62	24871024	60,470	57327.9	5.9	66.5	6,523	87.7		57,327.90
	Idaho	12	2010	10	1468	1812	79	25143200	55,649	58281.8	3.4	72.3	6,542			58,281.80
	Idaho	12	2011	11	1287	1953	77		59,539	58226.2	6.3	66.6	6,631			58,226.20
	Idaho	12	2012	12	1506	2087	59		61,408	58323.9	4.7	64.1	6,421			58,323.90
	Idaho	12	2013	13	1609	2199	77		64,022	60631.2	7.4	66.3	6,340			60,631.20
	Idaho	12	2014	14	1540	2370	78		71,223	62454	5.4	64.4	6,335			62,454.00
	Idaho	12	2015	15			90		59,047	63081.2	5.3	66.4	6,328			63,081.20
	Idaho	12	2016	16			119		56,263	65479	7.4	64.3	6,370			65,479.00
	Idaho	12	2017	17			103		61,521	66980.5	3.6	73.1	6,367			66,980.50
	Idaho	12	2018	18			120		64,514	71075.4	5.3	63.8	6,470			71,075.40
	Illinois	13	2000	0	7207	9057	558	198946576	72,133	640723.4	6.0	67.4	6,322	85.5		640,723.40
	Illinois	13	2001	1	7508	10095	525	199815120	64,235	642292.5	5.0	71.2	6,293	86.2		642,292.50
	Illinois	13	2002	2	8586	10753	569	200408896	80,108	647517.8	3.7	70.6	9,741	85.9		647,517.80
	Illinois	13	2003	3	9304	11400	460	200896096	73,599	658317.3	4.1	67.9	9,703	85.9		658,317.30
	Illinois	13	2004	4	9604	12500	532	201436368	73,575	676805.9	6.3	67.3	9,763	86.8		676,805.90
	Illinois	13	2005	5	11034	13532	590	201758448	38,241	687706.6	5.8	55.1	9,815	87.2		687,706.60
	Illinois	13	2006	6	9607	15855	870	202303280	37,611	704827.6	5.0	71.4	9,816	87.6		704,827.60
	Illinois	13	2007	7	11599	16833	691	203133856	44,358	712619.8	3.8	71.1	9,927	87.6		712,619.80
	Illinois	13	2008	8	11602	18055	846	203952608	44,176	706616.5	4.4	61.6	9,970	85.7		706,616.50
	Illinois	13	2009	9	13945	19074	886	204748448	42,372	688161	6.9	71.7	9,982	85.7		688,161.00
	Illinois	13	2010	10	15326	19787	867	205490656	37,715	698179.6	4.7	64.1	9,974			698,179.60
	Illinois	13	2011	11	12808	20725	907		46,213	711283.4	5.3	63.1	9,918			711,283.40
	Illinois	13	2012	12	13210	21285	1151		46,778	726399.1	5.4	65.5	9,910			726,399.10
	Illinois	13	2013	13	15506	21814	1072		47,050	726125	5.1	72.5	9,892			726,125.00
	Illinois	13	2014	14	15397	22520	1205		51,767	741194	4.8	67.0	9,836			741,194.00
	Illinois	13	2015	15			1381		49,184	751754.9	4.5	67.2	5,357			751,754.90
	Illinois	13	2016	16			1947		53,438	749333.5	7.0	68.2	5,285			749,333.50
	Illinois	13	2017	17			2202		47,459	755594.7	2.9	62.2	5,221			755,594.70
	Illinois	13	2018	18			2169		47,922	774065	5.7	68.1	5,203			774,065.00
	Indiana	14	2000	0	3419	4218	41	97469856	47,420	264121.7	2.8	65.8	5,121	84.6		264,121.70
	Indiana	14	2001	1	3783	4773	67	98044160	51,624	259474.8	4.0	69.1	5,190	84.4		259,474.80
	Indiana	14	2002	2	4066	5063	63	98495472	56,564	265345.1	5.7	66.7	5,149	85.3		265,345.10
	Indiana	14	2003	3	3984	5497	127	99146208	48,467	277151.6	5.4	67.4	5,129	86.4		277,151.60
	Indiana	14	2004	4	4759	6083	138	99728112	58,728	287655.9	4.3	71.6	5,127	87.2		287,655.90	205,722.60	208,617.80	213,079.40	221,774.40	232,712.80	247,773.20	245,500.20	230,367.70	232,150.70	236,411.00	246,836.20	234,975.70	235,384.70	228,452.80	235,355.10	233,016.00	228,428.50	233,774.40	236,265.60
	Indiana	14	2005	5	5246	6627	160	100457856	59,497	290328.2	5.1	70.6	5,076	87.2		290,328.20	48,490.20	49,471.00	50,910.40	52,209.80	54,256.00	54,926.90	55,448.40	55,359.90	54,653.90	53,630.10	54,305.00	53,789.00	53,679.70	53,239.10	54,037.90	54,425.80	55,565.40	56,662.60	58,178.80
	Indiana	14	2006	6	4766	7786	176	101322704	60,208	296112.7	5.9	62.1	5,054	88.2		296,112.70
	Indiana	14	2007	7	5183	8270	241	102073584	46,171	304085.7	7.2	63.2	4,922	88.2		304,085.70
	Indiana	14	2008	8	5914	9016	311	102796896	46,064	300962.6	4.9	66.6	4,895	85.7		300,962.60
	Indiana	14	2009	9	5809	9650	319	103349200	46,077	279520.7	4.5	68.9	2,895	85.7		279,520.70
	Indiana	14	2010	10	5888	10049	289	103849936	48,398	297517.3	4.8	66.9	2,934			297,517.30
	Indiana	14	2011	11	5760	10628	356		45,153	299064.5	6.8	65.5	2,929			299,064.50
	Indiana	14	2012	12	7112	11051	375		42,710	300513.9	4.1	73.3	2,850			300,513.90
	Indiana	14	2013	13	7183	11538	360		48,671	307279.1	7.6	61.5	2,907			307,279.10
	Indiana	14	2014	14	8868	12042	462		52,870	316783.1	5.4	67.9	2,903			316,783.

This assignment is a Research Paper: "Economic and Social Cost of the Opioid Crisis in the US: A State Level Analysis Using Panel Data". It requires data to be collected in panel data format, doing...

Answer To: This assignment is a Research Paper: "Economic and Social Cost of the Opioid Crisis in the US: A...

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment