CVS Health: Exploring physician certification and guideline adherence evaluation data from 1970–2002 to uncover patterns, insights, and key questions.
Background
Suppose that you are on CVS Health's clinical analytics team, asked to assess the impact of two controversial changes that a physician specialty board implemented in 1990. Guideline adherence among certified physicians is of direct interest to us, since it bears on the quality of care our members receive. Physicians are not required to obtain board certification for this specialty to practice medicine, but the majority of doctors in this specialty do take the exam upon completing their residency program. If a physician fails to pass the exam, they have the option of re-taking the exam the following year or any year after that. This specialty board maintains a performance monitoring program where Physicians are rated on a 100 point scale based on how closely their practice patterns align with a variety of published clinical guidelines that the board endorses. There is strong supporting evidence that this composite score is positively correlated with patient outcomes -- in other words, physicians who score highly according to this metric are likely to provide patients with better care than those who score poorly. This data is only available for certified physicians.
In 1990, this specialty board made the decision to revamp their certification process in an attempt to increase the quality of care delivered by their physicians. Two primary changes were made:
However, the changes were highly controversial among physicians, many of whom felt that the additional requirements would be too burdensome and would be no more effective at increasing quality of care than the previous certification process.
Questions
To answer this question, you have been given the attached spreadsheet, which contains data on every physician who received board certification for this specialty between 1970 and 2002. In the background tab of the spreadsheet, you will find the year that each physician completed his/her residency training and the year that s/he received initial board certification. In the adherence_evaluations tab you will find annual results of a performance monitoring program that this specialty board maintains.
The attached data does not explicitly indicate whether a physician passed or failed their certification exam(s). However, prior analysis of the 1970-1990 data set has shown that all physicians who obtained certification the same year they completed residency passed their board exams on the first attempt. On the contrary, during the same time period, most physicians who obtained certification in subsequent years after completing residency did so because they failed the board exams the first year they took them.
Please work on the questions in the displayed order. Make sure that the solution reflects your entire thought process - it is more important how the code is structured rather than the final answers. You are expected to spend no more than 3 hours solving this project.