Assessment#3 ?Perform multiple regression on the relationship between hospital costs and patient age, risk

Assessment#3

 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. 

Preparation

Download the Assessment 3 Dataset [XLSX].

The dataset contains the following variables:

• cost (hospital cost in dollars).
• age (patient age in years).
• risk (count of patient risk factors).
• satisfaction (patient satisfaction score percentile rank).

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.

Additional Requirements

Your assessment should meet the following requirements:

• 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.