Diagnostic Analytics Create one Pivot Table in a new tab (worksheet) named "Status and Grade" to provide answers to the following questions: What is the overall percentage of loan dollars charged-off? How does the percentage of charge-off's by grade (greater or lesser) compare to the percentage of loan dollars made by grade? Create one Pivot Table in a new tab (worksheet) named "Status and Years" to provide answers to the following questions: What is the overall percentage of loan dollars charged-off? How does the percentage of charge-off's by years of employment (greater or lesser) compare to the percentage of loan dollars made by years of employment?

Column Labels Total Sum Total Sum Total Sum of of of Charged Off Fully Paid loan amnt loan_amnt2 loan_amnt3 Row Labels * Sum of loan_amnt Sum of loan_amnt2 Sum of loan_amnt3 Sum of loan_amnt Sum of loan_amnt2 Sum of loan_amnt3 $27,247,850 4.5% 0.9% $489,026,350 20.0% 16.0% $516,274,200 16.9% 16.9% $89,035,650 14.6% 2.9% $686,832,825 28.1% 22.5% $775,868,475 25.4% 25.4% $167,483,375 27.5% 5.5% $648,090,900 26.5% 21.3% $815,574,275 26.7% 26.7% $164,712,575 27.1% 5.4% $387,259,500 15.9% 12.7% $551,972,075 18.1% 18.1% $108,379,875 17.8% 3.6% $167,848,325 6.9% 5.5% $276,228,200 9.1% 9.1% $37,550,325 6.2% 1.2% $48,234,325 2.0% 1.6% $85,784,650 2.8% 2.8% $13,927,025 2.3% 0.5% $13,846,400 0.6% 0.5% $27,773,425 0.9% 0.9% Grand Total $608,336,675 100.0% 19.9% $2,441,138,625 100.0% 80.1% $3,049,475,300 100.0% 100.0%