document.write( "<A HREF=/cgi-bin/jump-to-question.mpl?question=459853>Question 459853</A>: <I><SPAN STYLE=\"word-break: break-all;\"> Should I sacrifice near-normality in order to run regression analysis in Excel2007?\r<BR>\n" );
document.write( "\n" );
document.write( "The first part of my assignment was correcting for missing data.  Seeing that some of the variables were anything but normal, I removed outliers.  This left me with uneven sample sizes.  If I am trying to analyze the factors affecting hospital cost don't I have to run regression analysis?  When I try to do it in excel it obviously won't allow me to do it since the sample sizes are not equivalent.  \r<BR>\n" );
document.write( "\n" );
document.write( "So, if I am interested in how the different factors affect cost, do I remove the outliers in cost variable (y), and subsequently remove the accompanying variables across the board?  List wise deletion except to correct for outliers?\r<BR>\n" );
document.write( "\n" );
document.write( "Or do I just accept that the majority of these are skewed and go from there?\r<BR>\n" );
document.write( "\n" );
document.write( "Any guidance would be appreciated. My Ocd tendencies are not good when taking an introductory biostats class LOL.\r<BR>\n" );
document.write( "\n" );
document.write( "Thanks in advance!\r<BR>\n" );
document.write( "\n" );
document.write( "Here are my desc stats <BR>\n" );
document.write( "w/ orig data<BR>\n" );
document.write( "					<BR>\n" );
document.write( "Mean	125636198.1	85	137	967	3100	18507	20577	2082	651<BR>\n" );
document.write( "Median	77698890.47	48	134	498	1251	8582	20833	1296	420<BR>\n" );
document.write( "Mode	#N/A	15	124	4771	#N/A	#N/A	0	#N/A	0<BR>\n" );
document.write( "Standard Deviation	163253552.2	102	30	1178	4491	25771	16569	2244	792<BR>\n" );
document.write( "Sample Variance	2.66517E+16	10468.92	887.90	1386601.94	20169352.31	664147515.61	274531737.27	5034278.69	626619.76<BR>\n" );
document.write( "Kurtosis	19.36996943	7.47	-0.19	4.45	4.97	7.61	1.77	4.61	3.88<BR>\n" );
document.write( "Skewness	3.862249824	2.48	0.41	2.24	2.31	2.65	1.08	2.07	2.00<BR>\n" );
document.write( "Range	1118414097	537	128	4842	21092	133432	83229	10913	3669<BR>\n" );
document.write( "Minimum	11017817.58	2	78	1	49	435	0	98	0<BR>\n" );
document.write( "Maximum	1129431915	539	206	4843	21141	133867	83229	11011	3669<BR>\n" );
document.write( "Sum	9673987257	6497	10112	73467	229400	1425053	1605018	154057	50098<BR>\n" );
document.write( "Count	77	76	74	76	74	77	78	74	77<BR>\n" );
document.write( "Below shows descriptive statistics afterthe removal of outliers & missing data									<BR>\n" );
document.write( "Mean	71.79631515	59	133	581	1226	9711	16776	1392	384<BR>\n" );
document.write( "Median	66.9061	40	133	431	938	7502.5	16856	1204.5	381<BR>\n" );
document.write( "Mode	#N/A	40	124	431	#N/A	#N/A	0	#N/A	0<BR>\n" );
document.write( "Standard Deviation	41.44398741	53	25	453	1016	8129	10960	1135	349<BR>\n" );
document.write( "Sample Variance	1717.604093	2859	650	204778	1031616	66077065	120111788	1287801	121824<BR>\n" );
document.write( "Kurtosis	0.491434794	0.268559434	0.088756826	0.80076461	2.047540427	0.26399267	-0.992319081	1.308159612	0.93664116<BR>\n" );
document.write( "Skewness	0.859322829	1.040215988	0.304137886	1.117717591	1.372018541	1.069535728	-0.069213819	1.286450345	0.974957725<BR>\n" );
document.write( "Range	183.414746	222	108	1970	4765	31075	37873	4599	1502<BR>\n" );
document.write( "Minimum	11.017818	2	83	8	49	723	0	98	0<BR>\n" );
document.write( "Maximum	194.432564	224	191	1978	4814	31798	37873	4697	1502<BR>\n" );
document.write( "Sum	3805.204703	3375	7599	31964	62532	524388	956256	75158	21123<BR>\n" );
document.write( "Count	53	57	57	55	51	54	57	54	55<BR>\n" );
document.write( "Confidence Level(95.0%)	11.42337744	14.18755301	6.765346749	122.3344783	285.6660103	2218.729794	2907.960637	309.7443555	94.35664243<BR>\n" );
document.write( "		Original Data (No Adjustments)							<BR>\n" );
document.write( "									<BR>\n" );
document.write( "Mean	125636198.1	85	137	967	3100	18507	20577	2082	651<BR>\n" );
document.write( "Median	77698890.47	48	134	498	1251	8582	20833	1296	420<BR>\n" );
document.write( "Mode	#N/A	15	124	4771	#N/A	#N/A	0	#N/A	0<BR>\n" );
document.write( "Standard Deviation	163253552.2	102	30	1178	4491	25771	16569	2244	792<BR>\n" );
document.write( "Sample Variance	2.66517E+16	10468.92	887.90	1386601.94	20169352.31	664147515.61	274531737.27	5034278.69	626619.76<BR>\n" );
document.write( "Kurtosis	19.36996943	7.47	-0.19	4.45	4.97	7.61	1.77	4.61	3.88<BR>\n" );
document.write( "Skewness	3.862249824	2.48	0.41	2.24	2.31	2.65	1.08	2.07	2.00<BR>\n" );
document.write( "Range	1118414097	537	128	4842	21092	133432	83229	10913	3669<BR>\n" );
document.write( "Minimum	11017817.58	2	78	1	49	435	0	98	0<BR>\n" );
document.write( "Maximum	1129431915	539	206	4843	21141	133867	83229	11011	3669<BR>\n" );
document.write( "Sum	9673987257	6497	10112	73467	229400	1425053	1605018	154057	50098<BR>\n" );
document.write( "Count	77	76	74	76	74	77	78	74	77\r<BR>\n" );
document.write( "<BR>\n" );
document.write( "<BR>\n" );
document.write( "<BR>\n" );
document.write( "<BR>\n" );
document.write( "\n" );
document.write( "orig. data set<BR>\n" );
document.write( "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<BR>\n" );
document.write( "1	60	140	64331896	376	1282	6898	24126	1393	702<BR>\n" );
document.write( "2	65	140	122146708	582	2277	7075	11402	251	250<BR>\n" );
document.write( "3	43	144	46481090	303	661	2970	9753	1287	443<BR>\n" );
document.write( "4	122	152	135096200	857	3311	21494	25580	3289	1502<BR>\n" );
document.write( "5	79	170	233734561	1395	5756	32258	59382		3076<BR>\n" );
document.write( "6	60	149	159399584	734		12978	35053	2621	750<BR>\n" );
document.write( "7	78	110	1129431915	572	1468	24319	27641	2911	<BR>\n" );
document.write( "8	40	124	101344345	496	1220	6402	16856	853	416<BR>\n" );
document.write( "9	77	135	107606586	456	1098	8566	33607	1115	462<BR>\n" );
document.write( "10	20	136	52811772	503	1579	8582	22893	1544	714<BR>\n" );
document.write( "11		121	71332538	476	921	8905	22497	568	129<BR>\n" );
document.write( "12	75	149	80100410	886	1645	11186	30815	1483	238<BR>\n" );
document.write( "13	40	136	47997004	71	231	6574	0	625	0<BR>\n" );
document.write( "14	114	149	106953900	1050	2800	17868	31857	1861	789<BR>\n" );
document.write( "15	29	135	66159737	181	406	7530	0	928	0<BR>\n" );
document.write( "16	60	128	77698890	374	919	6004	0	749	0<BR>\n" );
document.write( "17	86	149	72571020	490	2294	11024	26801	1305	702<BR>\n" );
document.write( "18	20		33890360	318	541	435	1874	453	353<BR>\n" );
document.write( "19	92	144	90378372	1080	2000	11954	37873	1700	1200<BR>\n" );
document.write( "20	40	133	72571812	130	1366	5656	14841	997	449<BR>\n" );
document.write( "21	224	198	354097261	2686	12966	71663	30207	8792	0<BR>\n" );
document.write( "22	134	197	252896395	1302	7041	22066	35080	5400	0<BR>\n" );
document.write( "23	150	187	99809865	1213	4814	26267	23052	3146	1067<BR>\n" );
document.write( "24	140	189	291002040	4771	10530	66084	51377	6193	1750<BR>\n" );
document.write( "25	210	206		2713	12000	42050	41104	5109	2682<BR>\n" );
document.write( "26	250	195	635719011	4609	16636	76728	19670	11011	0<BR>\n" );
document.write( "27	150	157	159291211	1418	6437	31798	34890	3908	660<BR>\n" );
document.write( "28	155	191	240386978	1694	7856	54653	52290	4695	2956<BR>\n" );
document.write( "29	2	83	47824729	8	122	7699	0	325	0<BR>\n" );
document.write( "30	2	86	39505252	192	583	7427	0	363	114<BR>\n" );
document.write( "31	131	136	168112580	1368		41119	51141	4277	1076<BR>\n" );
document.write( "32	30	106	50374425	361	614	1775	12525	869	0<BR>\n" );
document.write( "33	101	133	101811566	962	1739	11042	22105	1807	720<BR>\n" );
document.write( "34	180		132674596	1374	3504	19576	38521	3165	1619<BR>\n" );
document.write( "35	150	145	133246519	1512	3283	23641	26454	3421	1616<BR>\n" );
document.write( "36	2	78	42533051	1	170	7602	0		0<BR>\n" );
document.write( "37	23	147	42267738	431	643	2375	22863	307	435<BR>\n" );
document.write( "38	131	121	110985783	934	938	15479	24475	1723	0<BR>\n" );
document.write( "39	106	131	57585450	755	1212	8265	12114	1211	381<BR>\n" );
document.write( "40	11	112	20608644	125	155	1230	1624	98	26<BR>\n" );
document.write( "41	13	87	11017818	165	175	723	0	177	88<BR>\n" );
document.write( "42	29	121	41110232		328	3568	0	1195	301<BR>\n" );
document.write( "43	26	124	32987171	311	600	3795	5122	453	199<BR>\n" );
document.write( "44	25	102	29925571	328	963	3518	20964	918	418<BR>\n" );
document.write( "45	104	133	127582023	1126	2517		27604	5213	604<BR>\n" );
document.write( "46	50	132	32715235	22	416	3487	8201	340	183<BR>\n" );
document.write( "47		124	31993465	324	508	2954	4556	457	141<BR>\n" );
document.write( "48	17	106	24856133	375	285	1997	6104	289	144<BR>\n" );
document.write( "49	39	109	35320048	408	794	1306	15178	400	474<BR>\n" );
document.write( "50	412	155	268521593	3991	10668	76140	20702	9672	2089<BR>\n" );
document.write( "51	203		80725005		3296	13570	21178	2395	1028<BR>\n" );
document.write( "52	477	180	449112700	4771	16467	133867	83229	6918	3669<BR>\n" );
document.write( "53	539	184	457043818	4843	21141	119776	55583		2673<BR>\n" );
document.write( "54	166	115	72454403	499	922	8876	18711	1423	533<BR>\n" );
document.write( "55	15	137	87091348	195	972	15498	21008	2355	0<BR>\n" );
document.write( "56	30	135	81495413	431	1198	6815	23313	1198	1092<BR>\n" );
document.write( "57	6	94	21660247	222	204	2463	0	389	273<BR>\n" );
document.write( "58	6	100	24620386	241	281	2008	0	413	222<BR>\n" );
document.write( "59	10	107	23872832	229	491	2667	1117	455	253<BR>\n" );
document.write( "60	7	106	28000000	330	375	1800	13370	512	270<BR>\n" );
document.write( "61	15	120	37778177	415	455	2510	7333	536	266<BR>\n" );
document.write( "62	15	154	96849621	190	1521	11434	10001	2092	0<BR>\n" );
document.write( "63	2	101	15783121	90	49	792	5190	187	0<BR>\n" );
document.write( "64	100	145	78819659	459	1803	7475	14531	1261	481<BR>\n" );
document.write( "65	20	130	43505204	622	907	1183	15825	1257	518<BR>\n" );
document.write( "66	3	92	18907920	157		1572	7567	420	0<BR>\n" );
document.write( "67	15	122	29631482	321		2139	5676	500	255<BR>\n" );
document.write( "68	20	122	70935956	725	1358	16250	15760	1387	493<BR>\n" );
document.write( "69	15	124	58431299	158	165	2586	11762	344	420<BR>\n" );
document.write( "70	9	123	66906100	198	500	10000	14500	1000	0<BR>\n" );
document.write( "71	45	170	194432564	1038	3163	25517	21722	2323	432<BR>\n" );
document.write( "72	110	186	165151572	1978	6668	26977	32893	4697	742<BR>\n" );
document.write( "73	25	124	51467691	697	933	7918	22939	1560	273<BR>\n" );
document.write( "74	52	155	143039315	1198	2749	26983	28938	2960	702<BR>\n" );
document.write( "75	40	143	87885000	963	2401	18123	26512	2321	850<BR>\n" );
document.write( "76	25	131	80641895	735	1660	12840	23097	2658	527<BR>\n" );
document.write( "77	245	177	435805108	3888	15682	75068	52645		1801<BR>\n" );
document.write( "78	85		183138339	1066	3768	13643	9846	1634	407\r<BR>\n" );
document.write( "\n" );
document.write( " </SPAN>\n" );
document.write( "</I><HR><TABLE width=100%><TR><TD><B><A HREF=http://www.algebra.com/>Algebra.Com's</A> Answer #315359 by </B><A HREF=/tutors/aboutme.mpl?userid=math-vortex><B>math-vortex(648)</B></A><img src=\"/images/stars/stars-11.gif\" alt=\"\" >&nbsp;<A HREF=/tutors/aboutme.mpl?userid=math-vortex><IMG SRC=http://www.algebra.com/images/aboutme-small.gif BORDER=0 alt=\"About Me\" VALIGN=MIDDLE></A>&nbsp;<IMG SRC=http://www.algebra.com/cgi-bin/show-face.mpl?user=math-vortex><BR>You can <A HREF=\"/cgi-bin/embed-solution.mpl?show=1&solution=315359\">put this solution on YOUR website!</A><BR><SPAN STYLE=\"word-break: break-all;\"> Have you thought of using SPSS rather than Excel? I think you will have much more flexibility and better information about your data with a true statisitics program. I think you can get a free trial download if your STAT Lab doesn't have the software. (Google SPSS Statistics.)\r<BR>\n" );
document.write( "\n" );
document.write( "Good Luck! </SPAN>\n" );
document.write( "</TD></TR></TABLE>\n" );