Discussion of the degrees of freedom and the sample size

Question

Assignment:

Select the appropriate statistical test that allows you to conduct an analysis of the factors affecting hospital costs. You will have to select the correct statistical test and conduct that test in Excel.

1. Analyze your data and produce a 250-word summary describing the major findings of your analysis.

2. The variables that most affect hospital cost.

3. An overview of the P and F values in your Excel tables.

4. A discussion of the degrees of freedom and the sample size.

5. Discuss any significant relationships that present themselves in the Excel files produced from your statistical analysis

Hospital	Total Beds in the Hospital	Total Number of Services offered in the facility	Total operating cost per year	Full-Time Equivalents	Case Mix Adjusted Discharges	Total Surgical Visits per year	Total ER Visits per year	Total Ambulatory Visits per year	Total Live Births per year
1	60	140	64331896	376	1282	6898	24126	1393	702
2	65	140	122146708	582	2277	7075	11402	251	250
3	43	144	46481090	303	661	2970	9753	1287	443
4	122	152	135096200	857	3311	21494	25580	3289	1502
5	79	170	233734561	1395	5756	32258	59382	2082	3076
6	60	149	159399584	734	3100	12978	35053	2621	750
7	78	110	1129431915	572	1468	24319	27641	2911	0
8	40	124	101344345	496	1220	6402	16856	853	416
9	77	135	107606586	456	1098	8566	33607	1115	462
10	20	136	52811772	503	1579	8582	22893	1544	714
11	85	121	71332538	476	921	8905	22497	568	129
12	75	149	80100410	886	1645	11186	30815	1483	238
13	40	136	47997004	71	231	6574	0	625	0
14	114	149	106953900	1050	2800	17868	31857	1861	789
15	29	135	66159737	181	406	7530	0	928	0
16	60	128	77698890	374	919	6004	0	749	0
17	86	149	72571020	490	2294	11024	26801	1305	702
18	20	137	33890360	318	541	435	1874	453	353
19	92	144	90378372	1080	2000	11954	37873	1700	1200
20	40	133	72571812	130	1366	5656	14841	997	449
21	224	198	354097261	2686	12966	71663	30207	8792	0
22	134	197	252896395	1302	7041	22066	35080	5400	0
23	150	187	99809865	1213	4814	26267	23052	3146	1067
24	140	189	291002040	4771	10530	66084	51377	6193	1750
25	210	206	deleted	2713	12000	42050	41104	5109	2682
26	250	195	635719011	4609	16636	76728	19670	11011	0
27	150	157	159291211	1418	6437	31798	34890	3908	660
28	155	191	240386978	1694	7856	54653	52290	4695	2956
29	2	83	47824729	8	122	7699	0	325	0
30	2	86	39505252	192	583	7427	0	363	114
31	131	136	168112580	1368	3100	41119	51141	4277	1076
32	30	106	50374425	361	614	1775	12525	869	0
33	101	133	101811566	962	1739	11042	22105	1807	720
34	180		132674596	1374	3504	19576	38521	3165	1619
35	150	145	133246519	1512	3283	23641	26454	3421	1616
36	2	78	42533051	1	170	7602	0	2082	0
37	23	147	42267738	431	643	2375	22863	307	435
38	131	121	110985783	934	938	15479	24475	1723	0
39	106	131	57585450	755	1212	8265	12114	1211	381
40	11	112	20608644	125	155	1230	1624	98	26
41	13	87	11017818	165	175	723	0	177	88
42	29	121	41110232	967	328	3568	0	1195	301
43	26	124	32987171	311	600	3795	5122	453	199
44	25	102	29925571	328	963	3518	20964	918	418
45	104	133	127582023	1126	2517	18507	27604	5213	604
46	50	132	32715235	22	416	3487	8201	340	183
47	85	124	31993465	324	508	2954	4556	457	141
48	17	106	24856133	375	285	1997	6104	289	144
49	39	109	35320048	408	794	1306	15178	400	474
50	412	155	268521593	3991	10668	76140	20702	9672	2089
51	203	137	80725005	967	3296	13570	21178	2395	1028
52	477	180	449112700	4771	16467	133867	83229	6918	3669
53	539	184	457043818	4843	21141	119776	55583	2082	2673
54	166	115	72454403	499	922	8876	18711	1423	533
55	15	137	87091348	195	972	15498	21008	2355	0
56	30	135	81495413	431	1198	6815	23313	1198	1092
57	6	94	21660247	222	204	2463	0	389	273
58	6	100	24620386	241	281	2008	0	413	222
59	10	107	23872832	229	491	2667	1117	455	253
60	7	106	28000000	330	375	1800	13370	512	270
61	15	120	37778177	415	455	2510	7333	536	266
62	15	154	96849621	190	1521	11434	10001	2092	0
63	2	101	15783121	90	49	792	5190	187	0
64	100	145	78819659	459	1803	7475	14531	1261	481
65	20	130	43505204	622	907	1183	15825	1257	518
66	3	92	18907920	157	3100	1572	7567	420	0
67	15	122	29631482	321	3100	2139	5676	500	255
68	20	122	70935956	725	1358	16250	15760	1387	493
69	15	124	58431299	158	165	2586	11762	344	420
70	9	123	66906100	198	500	10000	14500	1000	0
71	45	170	194432564	1038	3163	25517	21722	2323	432
72	110	186	165151572	1978	6668	26977	32893	4697	742
73	25	124	51467691	697	933	7918	22939	1560	273
74	52	155	143039315	1198	2749	26983	28938	2960	702
75	40	143	87885000	963	2401	18123	26512	2321	850
76	25	131	80641895	735	1660	12840	23097	2658	527
77	245	177	435805108	3888	15682	75068	52645	2082	1801
78	85	137	183138339	1066	3768	13643	9846	1634	407