The data file may be downloaded with the numbers in some data columns (e,g,: Total Hospital Cost and Total Hospital Revenue) expressed or presented in scientific notation. Please, re-format all such data columns from scientific format (e.g.: 4.823 X 10e2) to regular number format (482.3). Another example is 4.5×10e−3 reformated to 0.0045.

Table 1 attached

NOTE: Please note how the t Value and the (Pr<|t|) values are presented in the last column. The format should be the same for each hospital characteristic.

Figure E.1 –

Attached

In your Summary Report:

1. Findings: Please write a short paragraph to describe your findings. Make sure to attach any plotted graph(s).
2. Performance – Conclusion: Based on your findings in which year did US hospitals have better performance? What is that based on?

The question you are asked is – in which year (2011 or 2012) did hospitals have better performance? To determine that you would need to use the data to calculate a measure of performance for each hospital.  So, for example, you could calculate Hospital Cost per Discharge = Total Hospital Cost/Total Hospital Discharges, for each hospital (see the last row in Table 1 template above). Then you can comment on which year the hospitals had better performance, based on the values in that row.  This is an example. You could combine other sets of hospital data to create a different measure of performance. Insert that measure as another row in the Table, and determine if the difference in hospital performance for the 2 years is statistically significant for that measure.

 

 

HMGT400HOSPITAL.csv

 

 

ScreenShot2024-04-28at10.11.13AM.png

 

 

ScreenShot2024-04-28at10.10.35AM.png

stata_name	stcd	year	total_hosp_cost	total_hosp_revenue	hospital_beds	bedsize_cat	teaching_hospital	system_member	level_trauma	white	rural_area	herf_cat	herf_index	non_white	log_hosp_cost	log_hosp_revenue	total_hospital_beds	total_hospital_medicare_days	total_hospital_medicaid_days	interns_and_residents	total_hospital_employees_on_payr	total_hospital_non_paid_workers	total_hospital_medicare_discharg	total_hospital_medicaid_discharg	total_hospital_discharges	own
Arizona	86	2012	1.89E+07	1.73E+07	19	1	0	0	0	58.7	0	1	0	41.3	16.75435	16.66785	168.92	11551.5	8206.92		855.048		2695.488	2867	8879	0
Arizona	86	2012	8.01E+07	7.94E+07	88	3	0	0	0	58.5	0	1	2	41.5	18.19875	18.19	138.02	14629.86	2423.52		1209.024		4117.736	697	6998	1
Arizona	86	2012	1.47E+08	1.33E+08	134	4	0	0	0	82	0	1	2	18	18.80468	18.70265	74.16	3784.2	4354.38		490.464		1305.488	1253	4320	0
Arizona	86	2012	7.74E+07	8.81E+07	72	3	0	0	0	82	0	1	2	18	18.16424	18.29439	25.75	306	225.42		132.84		74.504	66	257	0
Arizona	86	2012	1.53E+08	1.41E+08	187	4	0	0	0	58.7	0	1	2	41.3	18.84588	18.76257	19.57	1545.3	98.94		139.608		259.096	18	429	2
Arizona	86	2012	1.60E+07	1.70E+07	21	1	0	0	0	20.4	1	0	2	79.6	16.58738	16.65044	20.6	1042.44	235.62		185.148		160.128	77	366	2
Arizona	86	2012	7.02E+08	7.55E+08	460	7	0	0	1	55.3	0	1	2	44.7	20.36947	20.4425	493.37	28329.48	46840.44	356.34	4570.98		5216.392	9139	26341	2
Arizona	86	2012	2.07E+07	2.29E+07	14	1	0	0	3	58.5	0	1	2	41.5	16.84361	16.94799	237.93	5724.24	11063.94	95.39	1073.82		1195.4	1481	6836	0
Arizona	86	2012	1.67E+08	1.72E+08	163	4	0	0	3	55.3	0	1	2	44.7	18.93446	18.96016	14.42	961.86	255		154.62		151.232	98	356	1
Arizona	86	2012	2.32E+07	2.06E+07	56	3	0	1	0	16	0	1	2	84	16.95965	16.84255	61.8	3816.84	1180.14		307.2		1159.816	312	2738	0
Arizona	86	2012	9.60E+07	1.20E+08	3550	4	0	1	0	58.7	0	1	0	41.3	18.37936	18.59896	37.08	1138.32	2433.72		315.804		433.68	660	2426	0
Arizona	86	2012	1.31E+08	1.49E+08	110	4	0	1	0	82	0	1	2	18	18.68941	18.82107	101.97	8494.56	3713.82	8	882.924		2048.304	934	4332	1
Arizona	86	2012	1.81E+08	1.99E+08	460	5	0	1	0	58.7	0	1	0	41.3	19.01667	19.10902	360.5	12812.22	9098.4		1110		3155.856	2109	10925	1
Arizona	86	2012	5.37E+07	3.92E+07	3550	2	0	1	0	58.7	0	1	2	41.3	17.79862	17.48499	210.12	10312.2	9235.08		1303.464		2696.6	2715	12235	0
Arizona	86	2012	2.28E+08	2.45E+08	3550	6	0	1	0	58.7	0	1	0	41.3	19.24457	19.31838	354.32	27260.52	9731.82		1711.284		7236.896	2559	18413	1
Arizona	86	2012	3.15E+08	3.79E+08	267	5	0	1	1	55.2	0	2	2	44.8	19.56899	19.7525	252.35	16108.86	15733.5		1894.188		3968.728	3487	12895	2
Arizona	86	2012	2.64E+08	2.81E+08	460	5	0	1	1	58.7	0	1	0	41.3	19.39099	19.45325	273.98	17960.16	16340.4		1704.816		4232.272	3447	16298	2
Arizona	86	2012	4.70E+08	5.17E+08	3550	8	0	1	1	58.7	0	1	0	41.3	19.96899	20.06368	273.98	17960.16	16340.4		1704.816		4232.272	3447	16298	1
Arizona	86	2012	3.94E+08	4.35E+08	3550	7	0	1	1	58.7	0	1	0	41.3	19.79191	19.89182	273.98	17960.16	16340.4		1704.816		4232.272	3447	16298	1
Arizona	86	2012	3.48E+07	3.67E+07	25	2	0	1	3	65.9	0	1	2	34.1	17.36395	17.41857										0
Arizona	86	2012	5.24E+07	5.62E+07	49	2	1	0	0	52.3	0	2	2	47.7	17.77366	17.8452	507.79	29487.18	40869.36	44.66	3096.06		7225.776	8762	29644	1
Arizona	86	2012	4.28E+08	4.54E+08	553	8	1	0	0	55.3	0	1	2	44.7	19.8756	19.9329	50.47	2233.8	2249.1		500.772		563.784	654	2095	0
Arizona	86	2012	1.22E+08	1.23E+08	89	3	1	0	3	43.9	1	1	2	56.1	18.61977	18.62993	91.67	4144.26	5121.42		788.256		1223.2	1544	3712	0
Arizona	86	2012	2.23E+08	2.16E+08	3550	4	1	1	0	58.7	0	1	0	41.3	19.22436	19.19189	244.11	29369.88	2147.1	89.71	5149.536		6878.832	264	12315	2
Arizona	86	2012	2.27E+08	2.68E+08	3550	6	1	1	0	58.7	0	1	0	41.3	19.24058	19.40528	397.58	38496.84	4977.6	1.88	2182.056		9723.328	1340	22069	1
Arizona	86	2012	9.23E+08	9.84E+08	244	5	1	1	0	58.7	0	1	0	41.3	20.64341	20.70665	327.54	32268.72	11889.12		1869.108		8493.456	2780	20464	2
Arizona	86	2012	2.72E+08	2.95E+08	3550	7	1	1	0	58.7	0	1	0	41.3	19.42014	19.50291	169.95	8433.36	12750		1059.324		2466.416	4690	13654	0
Arizona	86	2012	6.06E+08	6.80E+08	3550	8	1	1	1	58.7	0	1	0	41.3	20.22179	20.33736	585.04	37101.48	53716.26	129.3	4415.16		7460.408	10624	36275	0
Arizona	86	2012	1.98E+08	2.41E+08	3550	5	1	1	2	58.7	0	1	0	41.3	19.1031	19.30064	220.42	12159.42	24371.88		1554.48		3299.304	5620	18796	2
Arkansas	71	2012	8125045	7994666	49	2	0	0	0	84	0	1	2	16	15.91046	15.89429	111.24	8150.82	1690.14		717.768		2257.36	803	4634	2
Arkansas	71	2012	7.38E+07	7.72E+07	125	4	0	0	0	95.2	0	2	2	4.800003	18.11635	18.16157	120.51	11514.78	1907.4		704.808		2766.656	561	4925	1
Arkansas	71	2012	7.12E+07	7.71E+07	124	4	0	0	0	89	0	1	2	11	18.08072	18.16073	13.39		1.02					1	1	2
Arkansas	71	2012	2.28E+07	2.36E+07	33	2	0	0	0	68.2	1	0	2	31.8	16.9437	16.97513	25.75	1785	57.12		103.896		394.76	26	502	1
Arkansas	71	2012	1.05E+07	1.03E+07	85	3	0	0	0	71	1	0	2	29	16.16907	16.143	25.75	1164.84	44.88		178.392		306.912	22	395	1
Arkansas	71	2012	1.62E+07	1.88E+07	25	2	0	0	0	40.3	1	0	2	59.7	16.60155	16.75008	25.75	1051.62	194.82		117.936		259.096	62	414	2
Arkansas	71	2012	9525674	8233617	25	2	0	0	0	92.2	1	0	2	7.800003	16.0695	15.92374	25.75	2970.24	762.96		180.468		760.608	429	1243	2
Arkansas	71	2012	2.08E+07	2.22E+07	72	3	0