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

The dataset provides Herfindahl–Hirschman Index, and Herfindahl index categories, please use the herf_cat variable and answer the following questions: Note: “The Herfindahl–Hirschman Index is a...

1 answer below »

The dataset provides Herfindahl–Hirschman Index, and Herfindahl index categories, please use the herf_cat variable and answer the following questions:

Note: “The Herfindahl–Hirschman Index is a commonly accepted measure of market concentration used by antitrust enforcement agencies and scholars in the field. The HHI is calculated by squaring the market share of each firm competing in the market and then summing the resulting numbers” (NASI, 2015; pp: XXXXXXXXXXRead more from here:

https://www.urban.org/sites/default/files/publication/50116/ XXXXXXXXXXAddressing-Pricing-Power-in-Health-Care-Markets.pdf

For this exercise, you do not need to compute the HHI, but if you have any questions, please do not hesitate to ask me, but try to learn more about this you will need that to report your findings.

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

  1. Compare the following information between hospitals located in high, moderate and low competitive markets? (table 1)
  2. What are the main significant differences between hospitals in different markets? (use ANOVA test)
  3. Use the density curves and compare hospitals cost and revenues between three markets.
  4. What is the impact of being in a high-competitive market on hospital revenues and cost? Do you think being in a high-competitive market has a positive impact on net hospital benefits? What about the number of Medicare and Medicaid discharge? Do you think hospitals in a higher completive market more likely to accept more Medicare and Medicaid patients? What is the impact of other variables? Please discuss your findings in 1-2 paragraphs.

(Note: to answer to the last question, please compute the ratio-Medicare-discharge and ratio-Medicaid-discharge first and then run 2 t-tests) high vs. moderate and high vs. low competitive market), please support your findings with box-plot).

Table 3. Comparing hospital characteristics and market, 2011 and 2012

High Competitive Market

Moderate Competitive Market

Low Competitive

Market

ANOVA/Chi-Sq (results)

Hospital Characteristics

N

Mean

STD

N

Mean

STD

N

Mean

STD

  1. Hospital beds

  1. Number of paid Employee

  1. Number of non-paid Employees

  1. Interns and Residents

  1. System Membership

  1. Total hospital cost

  1. Total hospital revenues

  1. Hospital net benefit

  1. Available Medicare days

  1. Available Medicaid days

  1. Total Hospital Discharge

  1. Medicare discharge

  1. Medicaid discharge

14. Herfindahl index

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

(BONUS points: Use Master RStudio script is available for this exercise, but you need to modify that for this analysis)

Download data from here:HMGT400HOSP

Answered Same Day Jun 07, 2021

Solution

Pooja answered on Jun 08 2021
129 Votes
1) Table 3 is given below.
Table 3. Comparing hospital characteristics and market, 2011 and 2012
    
    High Competitive Market
    Moderate Competitive Market
    Low Competitive
Market
    ANOVA/Chi-Sq (results)
    Hospital Characteristics
    N
    Mean
    STD
    N
    Mean
    STD
    N
    Mean
    STD
    
    1. Hospital beds
    219
    130.9
    386.2
    1332
    420.5
    594.2
    1479
    373.6
    562.2
    0.01164
    2. Number of paid Employee
    219
    500
    813
    1324
    1570
    1955
    1470
    1309
    1722
    0.08189
    3. Number of non-paid Employee
    0
    Na
    Na
    25
    35.9
    30.5
    35
    47.0
    97.1
    0.5826
    4. Internes and Residents
    22
    38.3
    45.6
    423
    112
    176
    480
    86.6
    150
    0.1579
    5. System Membership
    219
    0.425
    0.495
    1332
    0.607
    .0489
    1479
    0.632
    0.483
    3.553e-06
    
    
    
    
    
    
    
    
    
    
    
    6. Total hospital...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here