PEPPER Analysis Examining the PEPPER Reports is a critical part of CMI analysis. In this assignment, you will examine PEPPER target areas and populate a target with their facility’s data. Then compar

PEPPER Analysis 

Examining the PEPPER Reports is a critical part of CMI analysis. In this assignment, you will examine PEPPER target areas and populate a target with their facility’s data. Then compare their facility’s performance to that of your state and the nation. 

Assignment:PEPPER Analysis Assignment Revised 2023.docx  Reports:Use this report to choose a set of Target DRGs to review.  These are the national numbers for all hospitals:  AB202019_Ch14_NAT_TAS_STQ3FY19 PEPPER.xlsx Use this report to choose a specific state to review those same DRGs you reviewed in the national report:    AB202019_Ch14_STQ3FY19_TAS_ALLSTATE Use this report to look at the DRGs chosen for the specific hospital you are reviewing:   AB202019_Ch14_Inpatient Prospective Payment System IPPS Provider Summary for All Diagnosis-Related Groups_DRG FY2017.xlsx A few helpful hints:You will need to use the Excel filters to look at specific states, specific DRGs.  This will reduce the data so you can review one specific area.For this assignment, we are looking for you to compare a specific target area in a facility and compare it to the state and national numbers.