Write a 3–4-page analysis of the results in a Word document and insert the test results into this document.

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. 

Get Your Custom Essay Written From Scratch
We have worked on a similar problem. If you need help click order now button and submit your assignment instructions.
Just from $13/Page

Place an Order

 

Preparation

Download the Assessment 3 Dataset [XLSX].

The dataset contains the following variables:

Get Assignment Writing Help

Our experts are ready to complete your assignment, course work. essay, test, dissertation, research paper, quiz

Get Started

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