what is the descriptive analytics if this is the table: Using the Excel file "Session 3 LendingClub Assignment," complete the following instructions. Files Session 3 LendingClub Assignment.xlsx (Excel) This data set has been adapted from the course text. Information Lending institutions are always concerned about whether they are making profitable loans. One of the characteristics that must be managed is to limit the amount of bad loans which are "charged-off," meaning they are not collectible. These types of loans are losses to the institution. This assignment asks you to utilize descriptive, diagnostic, and predictive analytics to answer several questions related to charge-offs for LendingClub. Descriptive Analytics 1. Create one Pivot Table in a new tab (worksheet) named "Years and Grade" to provide answers to the following questions: a. What percentages of loan dollars (loan_amnt) are made to each grade (i.e., A through G)? b. What percentage of loan dollars (loan_amnt) are made by years of employment (emp_length)?

Sum of loan_amnt Column Labels | + Row Labels * 0 1 2 3 4 5 6 7 8 9 10/Grand Total A $59,655,350 $33,544,650 $46,435,200 $42,523,500 $31,626,225 | $30,920,900 $26,404,950 $28,754,125 $25,933,725 $20,422,025 $177,192,125 | $523,412,775 14.9% B $96,040,775 $51,605,925 $72,347,175 $63,306,050 $47,394,875 | $44,200,650 $40,662,350 $46,475,150 $44,081,725 $34,776,500 $303,401,200 | $844,292,375 24.1% c $110,075,075 $53,543,050 $78,947,600 $70,494,975 $52,145,975 | $52,374,025 $47,982,200 $51,485,000 $47,123,050 $39,050,950 $360,320,250 : $963,542,750 27.5% D $76,224,350 $38,391,800 $55,248,150 $49,470,400 $37,611,000 | $35,592,800 $33,509,775 $40,844,550 $34,544,950 $27,187,050 $260,882,650 | $689,507,475 19.7% E $37,229,075 $18,572,250 $27,770,900 $24,340,650 $19,054,450 | $19,006,375 $16,882,025 $19,056,775 $17,434,500 $15,660,650 $130,498,400 $345,506,050 9.9% F $11,585,850 $5,526,625 $8,150,750 $7,275,100 $5,590,650 $5,744,350 $5,841,350 $5,953,225 $5,687,650 $4,112,350 $38,830,475 | $104,298,375 3.0% G $3,501,075 $1,664,800 $3,018,200 $2,578,475 $1,011,275 $1,439,125 $1,765,175 $1,787,925 $1,705,275 $1,558,975 $12,589,475 $33,280,375 0.996 Grand Total $394,311,550 $202,849,100 $291,918,575 $259,989,150 $195,034,450 | $189,278,225 $173,048,425 $194,356,750 $176,570,875 $142,768,500 $1,283,714,575 | $3,503,840,175 100.0% 11.3% 5.8% 8.3% 7.4% 5.6% 5.4% 4.9% 5.5% 5.0% 4.1% 36.6% 100.0%