- +44 141 628 6080
- [email protected]

Recall you have been hired as the chief operating officer

The second part of the practicum involves the selection of the appropriate statistical technique to do analysis.

Recall you have been hired as the chief operating officer of a multi-hospital health care system. The CEO has approached you in your new role and asked you to do an analysis of factors affecting the total costs of hospitals in your region based on the data provided to you in an Excel file.

For this assignment, you will select the appropriate statistical test that allows you to conduct an analysis of the factors affecting hospital costs. You will have to select the correct statistical test and conduct that test in Excel. Based on the output you produce in Excel, analyze your data and produce a 250-word (approximately) summary describing the major findings of your analysis. Your final analysis should include (minimally), the following:

the variables that most affect hospital cost.

an overview of the P and F values in your Excel tables.

a discussion of the degrees of freedom and the sample size.

You should also discuss any significant relationships that present themselves in the Excel files produced from your statistical analysis. You are not limited by the information presented above. In fact, only discussing the aforementioned items will result in a score of "Basic" proficiency in the scoring rubric. However, the aforementioned items are the minimum areas you need to address in your narrative.

Submit both your statistical tables (output) and your summary. You should combine these items in one document so that you are sending your instructor one combined file rather than two individual files.

Now Priced at $35 (50% Discount)

Recommended **(97%)**

1923969

Questions

Asked

3,689

Active Tutors

1433453

Questions

Answered

**
Start Excelling in your courses, Ask a tutor for help and get answers for your problems !! **

Â©TutorsGlobe All rights reserved 2022-2023.

## Q : Srategy 1nbsp invest in a 3 year zero with a current ie t

problem 1now is t 0nbsp you have 20000 that you are willing to investing for 3 yearsnbsp you are considering three