Place your order now for a similar assignment and have exceptional work written by our team of experts, At affordable rates
HMGT 400 6381 Research and Data Analysis in Healthcare (2228)
Activities and Assessments
Assignments Exercise # 3 Submission FolderExercise # 3 Submission Folder
Hide Assignment Information
Exercise # 3:
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:
For this exercise you do not need to compute the HHI, but if you have any questions, please do not hesitate to ask. However, try to learn more about this you will need that to report your findings.
Using the dataset from week1 exercise, answer the following questions.
Compare the following information between hospitals located in high, moderate and low competitive markets. (Table 3)
What are the main significant differences between hospitals in different markets? (use ANOVA test)
Using density curves or boxplots, compare hospital cost and revenues across the 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 hospital net benefits? What about the number of Medicare and Medicaid discharges? Do you think hospitals in a high competitive market are 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 the last question, compute the Medicare-discharge and Medicaid-discharge ratios first, then run 2 t-tests: high vs. moderate and high vs. low competitive market). Please support your findings with box-plots.
[Medicare and Medicaid Discharge Ratios: Total Medicare Discharges ÷ Total Hospital Discharges; Total Medicaid Discharges ÷ Total Hospital Discharges]
Table 3. Comparing hospital characteristics and market, 2011 and 2012
High Competitive Market
Moderate Competitive Market
ANOVA / Chi-Sq (results)
Number of paid Employees
Number of non-paid Employees
Interns and Residents
Total Hospital Cost ($)
Total Hospital Revenues ($)
Hospital Net Benefits ($)
Available Medicare Days
Available Medicaid Days
Total Hospital Discharges
Total Medicare Discharges
Total Medicaid Discharge
14. Herfindahl index
Round mean and st.dev figures to nearest whole number (except Herfindahl index). Use 2 decimal places for p values.
Use Excel for calculations (mandatory). Make sure to attach the plotted information
(BONUS points: 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 HMGT 400.docx
Sep 6, 2022 11:59 PM
Rubric Name: Exercise 1, 2, 3 start 2185
CriteriaOutstanding 90-100%Good 80-89%
Data coding: Used the class dataset and a statistical package to perform analysis. Developed codes and performed analysis using class materials and exercises
Used class codes or a statistical package. Codes can be used to repeat the analysis.
Used class codes or any other statistics package.
Codes cannot be used to repeat the analysis.
Did not use class codes or package but performed some analysis.
Did not use class codes or package but performed some analysis.
Did not complete the tables or partially developed the tables. Reported incorrectly on N, Means and St. Dev
Score of Data coding: Used the class dataset and a statistical package to perform analysis. Developed codes and performed analysis using class materials and exercises,
Analysis: Developed tables with correct numbers (N, Mean, Standard Deviation (SD)
Completed all tables with correct N, Means and St. Dev
Completed most of the tables with correct N or Means and St. Dev
Completed the tables but report correct Means but not N and St. Dev
Did not complete the tables or partially reported N, Means and St. Dev
Did not complete the tables, N, Means and St. Dev
Score of Analysis: Developed tables with correct numbers (N, Mean, Standard Deviation (SD),
Analysis: Developed plots with correct titles and legend
Developed all plots with correct variables, legends, and titles.
Developed all plots, correct variables and titles.
Developed most plots, with correct titles.
Developed plots, with no correct titles and legends.
Did not deveop plots
Score of Analysis: Developed plots with correct titles and legend,
Analysis: Performed correct t-TEST, ANOVA and completed tables correctly
Applied means tests for all requested variables
Applied means tests for most requested variables
Applied means tests for some requested variables
Applied wrong tests for some/all requested variables
Did not apply means tests for requested variables
Score of Analysis: Performed correct t-TEST, ANOVA and completed tables correctly,
Analysis: Described analysis with clear message and explained how results can address the questions
Addressed all questions, described them thoughtfully and with a clear message
Addressed most of the questions, described them good
Addressed some of the questions, described a few of them
Did not describe findings with a clear message but a message is present
Did not describe findings
Score of Analysis: Described analysis with clear message and explained how results can address the questions,
Writing Style: Writes clearly, concisely, and with few errors.
Writes throughout, including accurate spelling, punctuation, grammar, and sentence structure
Writing is acceptable, with a few errors in spelling, punctuation, grammar, and/or sentence structure
Writing is acceptable, but there are more than 3 errors in spelling, punctuation, grammar, and/or sentence structure
A high number of errors in spelling, punctuation, grammar and/or sentence structure
An unacceptable number of errors in spelling, punctuation, grammar and/or sentence structure
Score of Writing Style: Writes clearly, concisely, and with few errors.,
TotalScore of Exercise 1, 2, 3 start 2185,
/ 100Overall Score
Outstanding90 points minimum
Good80 points minimum
Sutisfactory70 points minimum
Substandard60 points minimum
Failure0 points minimum
Files to submit
(0) file(s) to submit
After uploading, you must click Submit to complete the submission.Add a FileRecord Audio