Reference no: EM133498408

Case Study: Hospital administration needs to make a decision on the amount of reimbursement required to cover expected costs for next year. For this assignment, using the information on hospital discharges from last year, perform multiple regression on the relationship between hospital costs and patient age, risk factors, and patient satisfaction scores, and then generate a prediction to support this healthcare decision. Write a 3-4-page analysis of the results in a Word document and insert the test results into this document (copied from the output file and pasted into a Word document). Refer to the "Copy From Excel to Another Office Program" resource for instructions.

Grading Criteria
The numbered assignment instructions outlined below correspond to the grading criteria in Predicting an Outcome Using Regression Models rubric, so be sure to address each point. You may also want to review the performance-level descriptions for each criterion to see how your work will be assessed

• Perform the appropriate multiple regression using a dataset.
• Interpret the statistical significance and effect size of the regression coefficients of data analysis.
• Interpret p-value and beta values.
• Interpret the fit of the regression model for the prediction of data analysis.
• Interpret R-squared and goodness of fit.
• Apply the statistical results of the multiple regression of data analysis to support a health care decision.
• Generate a prediction with the regression equation.
• Write a narrative summary that includes practical, administration-related implications of the multiple regression.
• Write clearly and concisely, using correct grammar, mechanics, and APA formatting.