I need to use excel for this, I'm really confused can someone help me out please

Assume that Figure 19-4 is the before diagram for the Billing department. Further assume that the after results are as follows: Activity Activity Code Process Denied PDB 12 Review with Supervisor RWS 10 Locate Documentation LD 6 Copy Documentation 5 33 Required 1. Redo the Pareto diagram with the after results. Use Figure 19-4 as a guide) 2. Comment on the before and after routs for the Bling department No. 22 Activity PDB RWS LD CD 10 6 5 43 51 23 14 12 100% 400 100% 30- 51% Number 20 10 Key to Activity Codes POB - Process Denied Bills RWS Review with Supervisor LD Locate Documentation CD-Copy Documentation POB RWS LD CO