Blog

You are working as an analyst in a regional health system. Physicians at the hospital notice that an increasing number of their patients are not adequately controlling diabetes

You are working as an analyst in a regional health system. Physicians at the hospital notice that an increasing number of their patients are not adequately controlling diabetes and want to have nurses begin calling patients to remind them to have their A1C tested at least twice a year. The nurses said they would be happy to assist, but they want a list that identifies those patients who are not adequately controlling diabetes. Therefore, your boss has tasked you to identify all current patients with type 2 diabetes that visited any of the clinics or hospitals within the past year and assess whether they have had at least 2 A1C tests on record. In essence, the boss tasked you to create a diabetes registry using the health system’s EHR system.
The T2D excel file Download T2D excel filecontains all patients that you identified with an ICD diagnosis of diabetes that visited a clinic or hospital within the past year. In this data set, you pulled all procedures and observations (OBS), race (RACE), and gender (GENDER) for each patient. You also provided each patient with a study ID (STUDYID) to avoid having personal identifiable information in the registry. For this assignment, you may use any statistical software (including excel). You must provide descriptions of your methods and code (if applicable) used to calculate your responses in addition to the numeric answers for each question. You will be graded heavily on your description of your methods or “the how you got your answer.” Assess the overall population How many unique patients are there in the file? Which races do the patients represent? How many patients (# and proportion %) in each race? What is the average age of the population? Range? Median? Identify patients with Hemoglobin A1C testing on record What is the name of the OBS value that codes for A1C test/observation in the data set? How many patients (# and %) had ≥1 test on record? How many total tests were conducted during this time period for the entire population? What is the Average, Median, and Range of tests among those who were tested? How many patients are managing their diabetes (defined as ≥2 A1C tests)? How many patients in each race have their diabetes managed/unmanaged? What is the average age of the managed diabetes population? Range? Median? Helpful features and commands for those using Excel: Data tab -> Data Tools -> Remove Duplicates Data tab -> Sort & Filter -> Advanced Filter -> Filter Data tab -> Sort & Filter -> Advanced Filter -> Unique records only =AVERAGE() =AVERAGEIF() =COUNTIF() =COUNTIFS() =IF() =MAX() =MEDIAN() =MIN()

Related posts:

  1. Research Project Instructions: Sustainable Development: Research Paper: Each student should identify an area overburdened by pollution, applying EPA’s EJScreen: Environmental Justice Screening and Mapping Tool (https://www.epa.gov/ejscreen), which combines environmental and socioeconomic information in the area. Then, she needs to write a paper between six and eight pages (including figures, tables, and references). See the required format below. EJSCREEN is an environmental justice mapping and screening tool that provides EPA with a nationally consistent dataset and approach for combining environmental and demographic i
  2. The Assignment: Choose one historical concept about the Dahomey women warriors addressed in Edna Bay’s “Women in Combat,” a review of Stanley B. Alpern’s text Amazons of Black Sparta: The Women Warriors of Dahomey. Then in a five-page critical analysis – using a Womanist, Afrofuturist framework – that discusse
  3. explain what you see as a key problem or problems with the role of the class action in modern civil litigation. In doing so, make sure you explain how class actions differ from ordinary civil litigation, and create additional challenges.
  4. complete two discussion forums during the course.  Each consists of an initial post of 400-500 words addressing an instructor-provided topic.  The forums also require responses to the posts of at least two classmates. Each response should be 150-300 words.