Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

HMGT 400 Research and Data Analysis in Health Care-Exercise Dataset:HMGTHOSP.csv (Please download dataset from the class) Required program: EXCEL (BONUS points for using RStudio or R Programming)....

1 answer below »

HMGT 400 Research and Data Analysis in Health Care-Exercise

Dataset:HMGTHOSP.csv (Please download dataset from the class)

Required program: EXCEL (BONUS points for using RStudio or R Programming).

Author, Hossein Zare, PhD

Citation: Zare, H XXXXXXXXXXHMGT 400 Research and Data Analysis in Health Care-Exercise. UMGC.EDU

For each week exercise, Master RStudio codes (for BONUS point seekers) and a video will be posted.

Week 2, Exercise:

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 t-test)
  3. Comparing hospital net-benefit, which hospital has better performance? To answer this question first compute the hospital net benefits with subtracting hospital costs and revenues and then use t-test 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 and their importance for the managerial decision-making. List a specific managerial function and the way the processed date will be used to meet the managerial objectives.

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 Employees

4. Interns 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

Use Excel for calculations (mandatory). Make sure to attach the plotted information

(BONUS points:Master RStudio script is available for this exercise (see the RStudio: working toward BONUS points module in week 2), modify as needed for the analysis)

Download data from here:HMGT400HOSP

Answered Same Day May 31, 2021

Solution

Pooja answered on Jun 02 2021
135 Votes
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
    936
    549.0256
    537
    2094
    299.6791
    605
    < 2.2e-16
    2. Number of paid Employee
    929
    2475.5633
    1001
    2081
    869.8128
    2551
    < 2.2e-16
    3. Number of non-paid Employee
    30
    57.08453
    32.6
    30
    27.65823
    102
    0.1409
    4. Internes and Residents
    617
    124.89580
    96.5
    308
    41.52964
    179
    < 2.2e-16
    5. System Membership
    936
    0.6698718
    0.494
    2094
    0.5773639
    0.471
    9.268e-07
    
    
    
    
    
    
    
    
    6. Total hospital cost
    936
    392976714
    169943309
    2094
    136608825
    424408629
    < 2.2e-16
    7. Total hospital revenues
    936
    417498875
    184064399
    2094
    145244082
    457483256
    < 2.2e-16
    8. Hospital net...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here