Mathematics
HPM 8015 NYMC Hospital Inpatient Discharges Paper

HPM 8015

New York Medical College

HPM

### Question Description

I’m studying and need help with a Statistics question to help me learn.

Analytics Assignment

Format: Powerpoint to answer questions accompanied by STATA do file. Use one slide per question (e.g. part a, slide 1, part b, slide 2…). Please answer each question part on a single slide and format appropriately as if this were a presentation. You must submit a “log file” and a “do file” as well via email. If you use SAS please send me the SAS code and output.

• Download the 2016 SPARCS Dataset available from Health.Data.NY.gov (Hospital Inpatient Discharges (SPARCS De-Identified))

(I recommend using the “insheet” command to import the data, keeping only the data that you need and then saving the data in STATA format (.dta))

1. Where did patients get discharged (e.g. home, hospice, etc) to when they were discharged from the hospital? Where did the men go and where did the women go? You must use the data dictionary and codebook to determine this. Show your answer in a table with percentages.
2. In a table, show the average length of stay of patients at every hospital in Westchester county in 2016. Create a column for Medicare, Medicaid, Commercially Insured and Other. List the hospitals vertically in rows and make the insurance types the columns and include totals both vertically and horizontally. Show as both absolute counts and percentages.
3. What are the license numbers for the top 3 physicians (attending physicians) delivering newborns in Westchester hospitals in 2016? (Hint: There is a shortcut to figuring out who is a newborn…read the data codebook!)
4. What were the average total costs of the deliveries with those three physicians by facility?
5. What are the average costs for newborns by hospital? Which hospital is the outlier? Why do you think that is? What portion were over \$100,000 and what portion were over \$1,000,000
6. Tell me something I didn’t know about the data and why it is important.

Note1: Use the table below to better classify insurance type

 SPARCS Description HPM 8015 Description Blue Cross/Blue Shield Commercial Department of Corrections Other Federal/State/Local/VA Other Managed Care, Unspecified Commercial Medicaid Medicaid Medicare Medicare Miscellaneous/Other Other Private Health Insurance Commercial

Note 2: Length of Stay is a “String” variable and must be converted into a numeric variable

The code for this is

destring lengthofstay, replace force

You will need to use the code below because for some reason the “cost” data is recorded as a string (meaning STATA reads it as a word not a number)

*First line of code eliminates the decimal point

replace totalcosts=subinstr(totalcosts,".","",.)

*Second line of code eliminates the “comma”

replace totalcosts=subinstr(totalcosts,",","",.)

*Third line of code changes the “string” to a numeric variable so we can add/subtract/multiply and the second line

destring totalcosts, replace force

Fourth line of code divides by 100 since we eliminated the decimal point.

replace totalcosts=totalcosts/100

1. What are the average costs for newborns by hospital? Which hospital is the outlier? Why do you think that is? What portion were over \$100,000 and what portion were over \$1,000,000
2. Tell me something I didn’t know about the data and why it is important.

Student has agreed that all tutoring, explanations, and answers provided by the tutor will be used to help in the learning process and in accordance with Studypool's honor code & terms of service.

uoscar (4178)
Carnegie Mellon University
Review
Review

Anonymous
Return customer, been using sp for a good two years now.

Anonymous
Thanks as always for the good work!

Anonymous
Excellent job

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4