{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Stats-CH15-Minitab - CIS 3340 CRN#33386 MW 1:00 2:15 PM...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
CIS 3340 – CRN #33386 Hospital Database MW 1:00 – 2:15 PM Chapter 15 Statement : Construct a correlation matrix for the hospital database variables. Perform a stepwise multiple regression analysis to predict Personnel by Control, Service, Beds, Admissions, Census, Outpatients, and Births. Descriptive Statistics: Control, Service, Beds, Admissions, Census, ... Variable Mean SE Mean StDev Variance Control 2.1500 0.0641 0.9064 0.8216 Service 1.1600 0.0260 0.3675 0.1351 Beds 209.9 12.2 172.1 29614.2 Admissions 6832 470 6646 44171146 Census 144.1 10.6 149.6 22370.0 Outpat. Visits 98225 8405 118865 14128831687 Births 874.0 75.2 1063.7 1131384.6 Tot. Exp. 67140 4977 70386 4954251319 Payroll Exp. 30501 2313 32716 1070326022 Personnel 861.5 58.1 821.6 675021.6 Correlations: Control, Service, Beds, Admissions, Census, Outpat. Visi, ... Control Service Beds Admissions Service 0.003 0.966 Beds -0.158 0.045 0.025 0.529 Admissions -0.125 -0.355 0.625 0.079 0.000 0.000 Census -0.198 0.168 0.910 0.495 0.005 0.018 0.000 0.000 Outpat. Visi 0.099 -0.290 0.340 0.602 0.162 0.000 0.000 0.000 Births -0.106 -0.360 0.429 0.856 0.134 0.000 0.000 0.000 Personnel -0.137 -0.212 0.753 0.879 0.053 0.003 0.000 0.000 Census Outpat. Visi Births Outpat. Visi 0.279 0.000 Births 0.337 0.567 0.000 0.000 Personnel 0.655 0.644 0.697 0.000 0.000 0.000 Are some of the variables highly correlated? Which ones and why? The following pairs are highly correlated because they have R-values higher than 0.7 or lower than -0.7 and significant p-values:
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}