+1 601-680-9567
ORDER NOW

Capella University Outcome Using Regression Models Paper

Capella University Outcome Using Regression Models Paper

Capella University Outcome Using Regression Models Paper

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 health care decision. Write a 3–4-page analysis of the results in a Word document and insert the test results into this document.

ORDER NOW FOR COMPREHENSIVE, PLAGIARISM-FREE PAPERS

 

  • Download the Assessment 3 Dataset [XLSX].
    • cost (hospital cost in dollars) .
    • age (patient age in years) .
    • risk (count of patient risk factors).
    • satisfaction (patient satisfaction score percentile rank) .
    • Perform the appropriate multiple regression using a dataset.
    • Interpret the statistical significance and effect size of the regression coefficients of a data analysis.
      • Interpret p-value and beta values.
    • Interpret the fit of the regression model for prediction of a data analysis.
      • Interpret R-squared and goodness of fit.
    • Apply the statistical results of the multiple regression of a data analysis to support a health care decision.
      • Generate a prediction with regression equation.
    • Write a narrative summary of the results that includes practical, administration-related implications of the multiple regression.
    • Write clearly and concisely, using correct grammar, mechanics, and APA formatting.
    • Written communication: Write clearly, accurately, and professionally, incorporating sources appropriately.
    • Length: 3–4 pages
    • Resources: Not required.
    • APA format: Cite your sources using current APA format.
    • Font and font size: Times Roman, 10 point.

The dataset contains the following variables:

Instructions

Hospital administration needs to make a decision on the amount of reimbursement required to cover expected costs for next year. For this assessment, using 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 health care 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 Copy From Excel to Another Office Program for instructions.

Submit both the Word document and the Excel file that shows the results.

Grading Criteria

The numbered assessment instructions outlined below correspond to the grading criteria in the Predicting an Outcome Using Regression Models Scoring Guide, 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.

Additional Requirements

Your assessment should meet the following requirements:

 

UNFORMATTED ATTACHMENT PREVIEW

cost age 13316 14043 17354 15338 14510 14703 17422 16958 12873 12185 10096 13787 29478 15900 16030 16037 11163 15974 15055 18636 9063 18247 14216 14881 17133 13668 15142 10834 10321 13906 18759 12974 17186 17262 17030 15655 16662 10036 16471 16269 17714 15179 29408 16060 15980 12265 risk 83 72 64 81 77 81 64 69 82 68 64 71 73 74 67 78 72 78 75 84 61 65 72 75 80 82 76 66 70 81 77 69 81 63 76 68 79 62 69 79 65 68 90 63 78 68 6 9 8 5 4 10 9 4 9 2 4 5 9 9 7 2 7 6 7 6 5 3 6 1 8 2 2 2 9 1 9 10 7 4 7 4 3 6 10 5 8 7 10 6 4 3 satisfaction 61 20 40 22 38 63 33 3 66 47 20 94 5 16 77 78 99 68 58 83 92 23 68 6 70 4 66 93 71 14 68 77 41 38 59 6 32 50 45 23 16 32 96 35 13 55 14254 15594 13452 12095 14817 18176 14847 14624 18471 13785 13380 14227 13824 11915 18384 16575 15453 13527 16285 15307 14514 12579 14772 15122 15473 15719 15123 16091 14874 14679