Virginia Hospitals_2001-2005 database to create a new worksheet by copying and pasting the variables listed below

Asked by paulw
Dated: 19th Jun'15 08:57 AM
Bounty offered: $45.99

Complete the assignment, use the saved version of the Virginia Hospitals_2001-2005 database to create a new worksheet by copying and pasting the variables listed below.

Next, run a multiple regression model using 2005 data that has Total operating expense_05 as the dependent variable and the following variables as independent predictors:
•Staffed beds_05
•Medicare Days_05
•Medicaid Days_05
•Total Surgeries_05
•RN FTE_05
•Occupancy
•Ownership
•System Membership
•Rural/Urban
•Teaching Affiliation
•Age 65+
•Crime Rate
•Uninsured

Then, write a 2- to 3-page paper in which you:
•Specify the model in terms of a regression equation.

•For each predictor variable, state a hypothesis based on your understanding of the expected relationship of that variable to the dependent variable and provide your rationale for the stated hypothesis.

•Report summary descriptive statistics for each of the variables in your model (mean or percentage, and standard deviation).
 

Report the coefficient and the sign (plus [+] or minus [–]) for each variable and the statistical significance of each variable (level of significance or nonsignificance), as well as the R-square for the model.

•Interpret the findings and explain what they would mean to a health care professional working in a hospital setting.

Your written assignments must follow APA guidelines. Be sure to support your work with specific citations from this week's Learning Resources and additional scholarly sources as appropriate. Refer to the Essential Guide to APA Style for Students to ensure your in-text citations and reference list are correct.

Solution-Virginia Hospitals-2001-2005 -Multiple-Regression-Analysis
Answered by paulw
Expert Rating: 494 Ratings
Dated: 19th Jun'15 09:03 AM
5 words and 2 attachment(s).
Tutorial Rating: Not Rated
Sold 0 times.
(preview of the tutorial; some sections have been intentionally blurred)
…Please…

attachments

solution-Virginia_Hospitals-Multiple-Regression-Analysis.xlsx
Preview of solution-Virginia_Hospitals-Multiple-Regression-Analysis.xlsx
HospitalBon     Mary's   Community HospitalCarilion     HospLee       Regional   CtrMaryview Medical     HospitalReston       Medical   Secours-Richmond Comm     CenterHenrico       Health   Medical CenterCarilion     HospLewis-Gale       Health   Mem HealthcenterR     Cty
solution-Virginia_Hospitals_2001-2005-multiple_regression_analysis.docx
Preview of solution-Virginia_Hospitals_2001-2005-multiple_regression_analysis.docx
affiliation     unrelated   the operating     there       trend   from the     these       65+   also we     a       some   increase in     of       65+   operating expenses     for       decreases   Rate (x11)Here     cannot       trend   some hospitals     the       expenses   and for     it       in   crime rate     also       a   trend as     hospitals       number   uninsured people     increases       hospitals   decreases with     the       people   statistics (mean