Using the Ch09Problems.xls file under the Problem 09-08 tab, run a regression on the number of cases (IV) and LOS (DV). Interpret R², F, the IV coefficient and p-value, and the intercept. Describe the relationship between cases and LOS.

Problem 9.8 - DRG 143: Chest Pain, PA 2005
Hospital Name	Cases	Avg Charge	LOS
Abington Memorial	1293	$23,308	1.5
Albert Einstein	845	$20,960	1.5
Aliquippa Community	31	$7,700	1.9
Allegheny General	237	$11,481	1.6
Alle-Kiski	242	$10,276	1.7
Altoona Regional	147	$8,943	1.7
Armstrong County Memorial	42	$3,967	1.7
Ashland Regional	23	$5,369	1.4
Barnes Kasson County	52	$3,475	1.7
Berwick	92	$9,430	2.1
Bon Secours	115	$4,969	1.7
Bradford Regional	35	$4,828	1.7
Brandywine	319	$29,045	1.6
Brookville	34	$4,168	2.1
Butler Memorial	102	$7,010	1.6
Canonsburg General	88	$11,914	2.2
Carlisle Regional	170	$11,108	1.7
Central Montgomery	183	$18,349	1.5
Chambersburg	274	$10,151	1.8
Charles Cole Memorial	45	$5,884	2.0
Chester County	434	$9,195	1.7
Clarion	61	$4,110	1.3
Clearfield	35	$6,337	2.3
Community/Scranton	661	$9,945	1.5
Conemaugh Valley Memorial	328	$8,051	1.9
Corry Memorial	27	$3,452	1.4
Crozer-Chester	647	$26,164	1.5
Delaware County Memorial	578	$29,423	1.9
Doylestown	317	$13,732	1.4
DuBois Regional	37	$7,624	1.3
Easton	518	$12,392	1.5
Elk Regional	59	$6,957	1.5
Ellwood City	33	$4,535	2.2
Ephrata Community	136	$7,659	1.9
Evangelical Community	154	$4,583	1.3
Frankford	1717	$14,417	2.1
Frick	128	$6,678	1.8
Fulton County	57	$5,205	1.9
Geisinger Wyoming Valley	110	$12,786	1.6
Geisinger/Danville	86	$11,327	1.2
Gettysburg	94	$6,598	1.5
Gnaden Huetten Memorial	61	$4,151	1.5
Good Samaritan Regional	177	$5,362	1.9
Good Samaritan/Lebanon	223	$7,703	1.6
Graduate	251	$24,129	1.3
Grand View	384	$18,579	1.7
Hahnemann University	476	$35,185	2.0
Hamot	349	$10,772	1.6
Hanover	41	$7,692	2.2
Hazleton General	80	$10,661	2.0
Heart of Lancaster	59	$9,855	1.5
Highlands	33	$4,299	1.6
Holy Redeemer	407	$23,159	1.3
Holy Spirit	312	$10,138	1.7
Hospital Fox Chase Cancer	5	$5,175	1.5
Hospital University PA	750	$15,813	1.3
Indiana Regional	164	$7,803	2.0
J C Blair Memorial	70	$5,157	1.9
Jameson Memorial	269	$5,496	1.4
Jeanes	415	$30,362	1.7
Jefferson Regional	186	$6,311	1.9
Jennersville Regional	264	$17,917	1.7
Jersey Shore	34	$4,761	1.6
Kane Community	31	$4,117	1.7
Lancaster General	541	$8,994	1.8
Lancaster Regional	193	$10,898	1.7
Latrobe Area	227	$6,368	1.5
Lehigh Valley	995	$12,827	1.6
Lehigh Valley/Muhlenberg	398	$14,430	1.6
Lewistown	348	$5,964	1.8
Main Line Bryn Mawr	474	$18,635	1.7
Main Line Lankenau	818	$16,053	1.5
Main Line Paoli	304	$16,627	1.3
Marian Community	141	$6,157	1.9
Meadville	111	$5,633	1.6
Medical Center Beaver	286	$6,849	1.9
Memorial York	133	$8,039	1.7
Memorial/Towanda	40	$6,060	1.6
Mercy Fitzgerald	728	$20,029	1.4
Mercy Jeannette	70	$8,584	1.8
Mercy Philadelphia	647	$15,712	1.4
Mercy Pittsburgh	386	$11,259	1.6
Mercy Suburban	389	$18,742	1.6
Mercy/Scranton	445	$9,975	1.6
Methodist Division/TJUH	616	$17,326	2.0
Mid-Valley	11	$6,624	1.2
Millcreek Community	26	$7,988	2.1
Milton S Hershey	57	$7,618	1.3
Miners	9	$8,107	1.6
Monongahela Valley	107	$8,859	2.4
Montgomery	483	$10,779	1.8
Montrose General	45	$2,611	1.7
Moses Taylor	165	$9,310	1.6
Mount Nittany	168	$6,474	1.7
Muncy Valley	17	$3,126	1.4
Nason	56	$3,360	1.6
Nazareth	558	$25,577	1.9
Ohio Valley General	163	$6,722	1.6
Palmerton	39	$5,648	1.8
Pennsylvania	290	$18,237	1.6
Phoenixville	282	$10,422	1.3
Pinnacle Health	466	$10,191	1.7
Pocono	656	$10,899	1.4
Pottstown Memorial	281	$10,935	1.4
Pottsville Warne Clinic	197	$4,188	1.7
Punxsutawney Area	44	$3,480	1.6
Reading	132	$6,995	1.8
Riddle Memorial	484	$19,821	1.4
Robert Packer	150	$7,528	1.5
Roxborough Memorial	292	$8,646	1.7
Sacred Heart/Allentown	90	$8,485	1.6
Saint Vincent Health	235	$18,413	1.6
Sewickley Valley	113	$7,482	2.0
Shamokin Area Community	68	$3,542	1.7
Sharon Regional	331	$8,391	1.7
Soldiers & Sailors	7	$6,769	2.0
Somerset Center Health	64	$6,668	2.3
Southwest Regional MC	25	$3,993	1.4
Springfield	158	$26,364	1.5
St Clair Memorial	182	$8,207	1.9
St Joseph/Reading	97	$8,216	1.3
St Joseph's/Philadelphia	142	$9,574	2.3
St Luke's Miners	107	$6,671	2.1
St Luke's Quakertown	50	$9,739	1.7
St Luke's/Bethlehem	1219	$7,349	1.6
St Mary	1169	$12,035	1.6
Sunbury Community	154	$6,603	1.6
Taylor	395	$30,295	1.6
Temple East	694	$16,049	1.9
Temple Lower Bucks	355	$24,255	1.8
Temple University	1302	$33,569	1.4
Thomas Jefferson Univ	680	$19,559	1.6
Titusville Area	20	$4,648	1.4
Troy Community	6	$2,956	1.5
Tyler Memorial	62	$5,832	1.7
Tyrone	47	$3,374	1.7
Uniontown	297	$4,372	1.7
United Community	16	$8,887	1.2
Univ PA/Presbyterian	279	$13,526	1.3
UPMC Bedford	51	$5,428	1.5
UPMC Braddock	71	$8,816	1.7
UPMC Horizon	53	$6,747	1.7
UPMC McKeesport	282	$9,286	1.7
UPMC Northwest	242	$4,600	1.6
UPMC Passavant	187	$11,164	1.7
UPMC Presby Shadyside	342	$16,114	2.0
UPMC South Side	42	$13,054	2.2
UPMC St Margaret	131	$11,229	1.6
Warren General	26	$6,914	1.9
Washington	320	$7,499	1.8
Wayne Memorial	50	$6,193	1.6
Waynesboro	22	$9,862	1.7
Western PA Hosp/Forbes	257	$9,026	1.7
Western Pennsylvania	192	$13,599	2.0
Westmoreland Regional	207	$6,823	1.4
Williamsport	139	$7,790	1.6
Windber	19	$9,275	1.5
WVHCS	224	$7,981	1.6
York	312	$6,009	1.4