The Herfindahl–Hirschman Index is a commonly accepted measure of market concentration used by antitrust enforcement agencies and scholars in the field. T
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: 14-16). Read more from here:
https://www.urban.org/sites/default/files/publication/50116/2000212-Addressing-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:
Compare the following information between hospitals located in high, moderate and low competitive markets? (table 1)
What are the main significant differences between hospitals in different markets? (use ANOVA test)
Use the density curves and compare hospitals cost and revenues between three markets.
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
Hospital beds
Number of paid Employee
Number of non-paid Employees
Interns and Residents
System Membership
Total hospital cost
Total hospital revenues
Hospital net benefit
Available Medicare days
Available Medicaid days
Total Hospital Discharge
Medicare discharge
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
Download codes for E2 from here:E3-codes-dplyr
Download codes for E2 from here:E3-codes-no-dplyr
Download E3 question: All Exercises questions
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
