The purpose of this assignment is to provide students with an opportunity to analyze data that was collected by the New York State Department of Health for all Isolated Coronary Artery Bypass Graft (CABG) procedures that occurred during 2011 thru 2013.
Assignment Instructions:
1. Read the Cardiac Case
Actions and the article “Adult Cardiac Surgery in New York State”Actions. Pay particular attention to Table 6 (Page 25) of this article, where data for each surgeon is presented.
2. After you have completed reading the article mentioned above, open up the Excel filethat is called “Analyzing Cardiac Surgery Data Download Analyzing Cardiac Surgery DataOpen this document with ReadSpeaker docReader”. This is essentially the data that you see in the article. I have removed all surgeons who did less than 10 procedures at any hospital. I have also removed the category of surgeons called “All Others” which you see in Table 6 of the article referenced above.
3. Based on the data that is presented in “Analyzing Cardiac Surgery Data”, please submit your Written Assignment
ActionsAnalyzing Cardiac Surgery Data – New York State – 2011 – 2013. Please remember: Questions 5 and 6 do not have a “right/wrong” answer. These questions require you to do some analysis and to think about different alternatives when analyzing the data.
4. Please submit your Excel file template you analyzed/manipulated/created Pivot Tables for as part of the Written Assignment here.