Using the "Session 4 LendingClub Assignment" Excel file, complete the following instructions. Files Session 4 LendingClub Assignment.xlsx (Excel) The data set has been adapted from the course text. Information Analytical information is extremely valuable; however, its value is limited if the information cannot be clearly communicated. This exercise utilizes pivot charts and a customized table to demonstrate information related to loans by Employement Tenure (emp_length), Interest Rates (int_rate), Grade, and Loan Status (loan_status). Can I get a step by step instructions on how to create these SUMIFS. 1. Using the Sumifs function in Excel, create a customized chart to demonstrate: a. Loan Amounts by Term and Grade b. Charged-Off Amounts by Term and Grade c. Charge-Off Percentages of Loan Amounts by Term and Grade. This is what part of my Excel Data Table look like

A B C D E G H loan amnt * term int rate grade . grade_num emp_length loan_status purpose addr state 15000 60 0.1239 C 10 Fully Paid debt_consolidation VA 10400 36 0.0699 A 8 Charged Off credit card CA 12800 60 0.1714 D 4 10 In Grace Period car CA 21425 60 0.1559 D 4 6 Fully Paid credit_card MO 9600 36 0.1366 C 3 10 Fully Paid debt_consolidation NJ 7650 36 0.1366 C 3 0 Charged Off debt_consolidation AZ 2500 36 0.1199 B 2 0 Fully Paid home_improvement MN 17000 36 0.1366 C 10 Fully Paid debt_consolidation NY 21075 60 0.2199 E 10 Current debt consolidation IL 11 12975 36 0.1786 D 10 Charged Off house FL 12 5250 36 0.1144 B 2| Fully Paid debt_consolidation MD 13 10000 36 0.1199 B 8 Charged Off debt_consolidation MI 14 23325 36 0.1431 C 10 Charged Off credit_card WA 15 16000 60 0.1144 B 6 Fully Paid debt_consolidation VA 16 6000 36 0.1049 B 10 Fully Paid home_improvement KY 17 3000 36 0.1049 B 9: Fully Paid medical CA 18 2000 36 0.1599 D 7 Fully Paid other AZ 19 2000 36 0.1499 C 8 Fully Paid credit card NY 20 2000 36 0.1431 C 2 Fully Paid other FL 21 7200 36 0.1239 C 5 Fully Paid debt_consolidation TX 22 13550 60 0.1999 E 5 Current debt_consolidation GA 23 14000 36 0.1049 B I N W A U N W N N O W N U Q W W A N N N W N N 10 Fully Paid credit_card TX 24 1000 36 0.1239 C 3 Fully Paid other MN 25 6000 36 0.1499 C 1 Fully Paid debt_consolidation CA 26 5000 36 0.1049 B 4 Charged Off debt_consolidation AZ 27 18000 36 0.1199 B 8 Fully Paid debt consolidation FL 78 2000 36 0.1299 C 0 Fully Paid medical IN 29 10800 36 0.0949 B 8 Fully Paid debt consolidation IN 30 15000 60 0.2099 E 3 Current other TX 31 4000 36 0.1599 D 9 Fully Paid debt_consolidation NY 32 18450 36 0.1431 C 10 Charged Off home_improvement CO 33 28000 60 0.1049 B 2 Fully Paid debt_consolidation FL 34 9600 36 0.0749 A 7 Fully Paid debt_consolidation IL