The attached dataset provides some information about hospitals in 2011 and 2012, download the data and then complete the descriptive table.

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Exercise #1:

The attached dataset provides some information about hospitals in 2011 and 2012, download the data and then complete the descriptive table. Please use the following format to report your findings. 

Table 1. Descriptive statistics between hospitals in 2011 & 2012

Hospital Characteristics 2011 2012 p-value

N Mean St. Dev N Mean St. Dev

1. Hospital beds

2. Number of paid Employee

3. Number of non-paid Employee

4. Total hospital cost

5. Total hospital revenues

6. Available Medicare days

7. Available Medicaid days

8. Total Hospital Discharge

9. Medicare discharge

10. Medicaid discharge

 

 

Based on your findings in which years hospitals had better performance? Please write a short paragraph and describe your findings.

 

Exercise #2:

Use the dataset from week1 exercise and then answer the following questions:

1) Compare the following information between teaching and non-teaching hospitals.

2) What are the main significant differences between teaching and non-teaching hospitals? (use ttest)

3) Comparing hospital net-benefit which hospitals has better performance? To answer this question first compute the hospital net benefits with subtracting hospital costs and revenues and then use ttest to compare the significant differences between teaching and non-teaching hospitals.

4) Use a box-plot and compare hospitals-cost and hospital-revenues between teaching and non-teaching hospitals.

5) Write a short paragraph and describe your findings.

Table 2. Descriptive statistics between teaching and non-teaching hospitals, 2011 & 2012

Hospital Characteristics Teaching Non-Teaching p-value

N Mean St. Dev N Mean St. Dev

1. Hospital beds

2. Number of paid Employee

3. Number of non-paid Employee

4. Internes and Residents

5. System Membership

6. Total hospital cost

7. Total hospital revenues

8. Hospital net benefit

9. Available Medicare days

10. Available Medicaid days

11. Total Hospital Discharge

12. Medicare discharge

13. Medicaid discharge

 

Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme