Categories
Health & Medical

HMGT 400 6381 Research and Data Analysis in Healthcare (2228) OOOlivia ONYECHI C

Place your order now for a similar assignment and have exceptional work written by our team of experts, At affordable rates

For This or a Similar Paper Click To Order Now

HMGT 400 6381 Research and Data Analysis in Healthcare (2228)
OOOlivia ONYECHI
Course Home
Syllabus
Content
Activities and Assessments
Grades
My Tools
Academic Support
More
Assignments Exercise # 3 Submission FolderExercise # 3 Submission Folder
Hide Assignment Information
Instructions
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:
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. 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
Low Competitive
Market
ANOVA / Chi-Sq (results)
Hospital Characteristics
N
Mean
St. Dev
N
Mean
St. Dev
N
Mean
St. Dev
Hospital Beds
Number of paid Employees
Number of non-paid Employees
Interns and Residents
System Membership
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
Due Date
Sep 6, 2022 11:59 PM
Hide Rubrics
Rubric Name: Exercise 1, 2, 3 start 2185
Print Rubric
CriteriaOutstanding 90-100%Good 80-89%
Satisfactory 70-79%
Substandard 60-69%
Failure 0-59%
Criterion Score
Data coding: Used the class dataset and a statistical package to perform analysis. Developed codes and performed analysis using class materials and exercises
15 points
Used class codes or a statistical package. Codes can be used to repeat the analysis.
13.35 points
Used class codes or any other statistics package.
Codes cannot be used to repeat the analysis.
11.85 points
Did not use class codes or package but performed some analysis.
10.35 points
Did not use class codes or package but performed some analysis.
5 points
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,
/ 15
Analysis: Developed tables with correct numbers (N, Mean, Standard Deviation (SD)
30 points
Completed all tables with correct N, Means and St. Dev
26.7 points
Completed most of the tables with correct N or Means and St. Dev
23.7 points
Completed the tables but report correct Means but not N and St. Dev
20.7 points
Did not complete the tables or partially reported N, Means and St. Dev
0 points
Did not complete the tables, N, Means and St. Dev
Score of Analysis: Developed tables with correct numbers (N, Mean, Standard Deviation (SD),
/ 30
Analysis: Developed plots with correct titles and legend
10 points
Developed all plots with correct variables, legends, and titles.
8.9 points
Developed all plots, correct variables and titles.
7.9 points
Developed most plots, with correct titles.
6.9 points
Developed plots, with no correct titles and legends.
0 points
Did not deveop plots
Score of Analysis: Developed plots with correct titles and legend,
/ 10
Analysis: Performed correct t-TEST, ANOVA and completed tables correctly
20 points
Applied means tests for all requested variables
17.8 points
Applied means tests for most requested variables
15.8 points
Applied means tests for some requested variables
13.8 points
Applied wrong tests for some/all requested variables
0 points
Did not apply means tests for requested variables
Score of Analysis: Performed correct t-TEST, ANOVA and completed tables correctly,
/ 20
Analysis: Described analysis with clear message and explained how results can address the questions
20 points
Addressed all questions, described them thoughtfully and with a clear message
17.8 points
Addressed most of the questions, described them good
15.8 points
Addressed some of the questions, described a few of them
5 points
Did not describe findings with a clear message but a message is present
0 points
Did not describe findings
Score of Analysis: Described analysis with clear message and explained how results can address the questions,
/ 20
Writing Style: Writes clearly, concisely, and with few errors.
5 points
Writes throughout, including accurate spelling, punctuation, grammar, and sentence structure
4.45 points
Writing is acceptable, with a few errors in spelling, punctuation, grammar, and/or sentence structure
3.95 points
Writing is acceptable, but there are more than 3 errors in spelling, punctuation, grammar, and/or sentence structure
3.45 points
A high number of errors in spelling, punctuation, grammar and/or sentence structure
1 point
An unacceptable number of errors in spelling, punctuation, grammar and/or sentence structure
Score of Writing Style: Writes clearly, concisely, and with few errors.,
/ 5
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
Submit Assignment
Files to submit
(0) file(s) to submit
After uploading, you must click Submit to complete the submission.Add a FileRecord Audio
Comments
Paragraph
Lato (Recommended)
19px (Default)
SubmitCancel

For This or a Similar Paper Click To Order Now

Leave a Reply