HITT 2105 Week 13 Homework (Chapter 12) CC/MCC Capture Rate Practice (Level 5Evaluate) Figure 12.6 in the textbook on page 189. walks you through the calculation for the CC/MCC capture rate for a MS-DRG family. The formula is: # of cases for the MS-DRG / total # of cases in the MS-DRG family x 100 (What did happen / what could have happened x 100) Using the instructions provided in the textbook complete the CC/MCC capture rates for the MS-DRG families found in the file Ch12 CCMCC Capture Rate Practice.xlsx. Which is attached to this project. When you have finished your calculations, analyze the results and prepare a small report detailing your findings and any insights you may have from your results. Submit both calculations and summary. You will be graded upon the accuracy of your calculations and critical thinking skills. This homework is worth 50 points