Refer to the worksheet named LOANS. This worksheet conta como formation for 1000 loans Columns and provide interest rates Thus, dents with 'N' cheating receive lansate of clients with credit ratings receive loans rate of 8%, and herits with credit ratings receive lansate of 12% 14 How many clients have a credit of 15 Across all clients, what is the mean strate? Note: this enticing nterests and providing an awer that is ac to four digits night of the decima 16 Across all clients, what is the mean age orthly payment amounting the individual interest rates calculated for eacher in otetta calculating pano assume paym due the end of each perod and the lance is compathe end of the loan 11 dient uber and payment amount H 3 Credit Rating 092 Client Credit Interest Loan of Monthly Payment Number Rating Rate Amount Payments Amount 14 B 65.000 120 894300 15,000 177064 C 35,000 812160 c 6 509207 106.000 630467 10 000 24 98495447 155.000 24 999 947894 50.000 24 1000 751000 170.000 00 1001 716500 75.000 120 20 000 1003 1004 1005 1006 100T LOOB 1000 1010 1012 1013 1014 1015 1016 1017 can I just have the process for how to do those questions? because the data is too big, i can not post all