I just want the process or equation for how to do those question, the data is too big I cannot post on here
Refer to the word LOANS This worksheet casco for 1000 ans Cours provide restes Thus.de of andere gecem 14 How do Copy SP Whose are mority payment Number Rang Rate Le Bolo A 38000 Rating c 612966 SOSOT c A . C 35.000 20 000 10500 se bo 16.00 50.000 STO.DOC 75.000 8888888 1009 1001 T8303 1992 1004 1093 100 100 can I just have the process for how to do those questions? because the data is too big, i can not post all Amanda Hu BbCel AaBbccc AaB AalbCd AaBbCd AaBbc daBbcc AaBbcc ong Subtitle T No Spac. Subtle Em... Intense E... Quote Intense Q- Find Replace Select- Title Styles Editing Refer to the worksheet named LOANS. This worksheet contains commercial loan information for 1000 loans. Columns Hand I provide interest rates. Thus, clients with "A credit ratings receive loans at an annual rate of 6%, clients with "B" credit ratings receive loans at an annual rate of 8%, and clients with "C" credit ratings receive loans at an annual rate of 12%. 14 How many clients have a credit rating of B? 311 15 Across all clients, what is the mean annual interest rate? (Note: this entails calculating interest rates, and providing an answer that is accurate to four digits right of the decimal.) 16 Across all clients, what is the mean (average) monthly payment amount (using the individual interest rates calculated for each client in Q15)? (Again, note this entails calculating payment amounts, assume payments are due at the end of each period and the loan balance is completely paid at the end of the loan.) 17 Which client has the largest monthly payment, and what is that monthly payment amount? (client number and payment amount) Refer to the word LOANS This worksheet casco for 1000 ans Cours provide restes Thus.de of andere gecem 14 How do Copy SP Whose are mority payment Number Rang Rate Le Bolo A 38000 Rating c 612966 SOSOT c A . C 35.000 20 000 10500 se bo 16.00 50.000 STO.DOC 75.000 8888888 1009 1001 T8303 1992 1004 1093 100 100 can I just have the process for how to do those questions? because the data is too big, i can not post all Amanda Hu BbCel AaBbccc AaB AalbCd AaBbCd AaBbc daBbcc AaBbcc ong Subtitle T No Spac. Subtle Em... Intense E... Quote Intense Q- Find Replace Select- Title Styles Editing Refer to the worksheet named LOANS. This worksheet contains commercial loan information for 1000 loans. Columns Hand I provide interest rates. Thus, clients with "A credit ratings receive loans at an annual rate of 6%, clients with "B" credit ratings receive loans at an annual rate of 8%, and clients with "C" credit ratings receive loans at an annual rate of 12%. 14 How many clients have a credit rating of B? 311 15 Across all clients, what is the mean annual interest rate? (Note: this entails calculating interest rates, and providing an answer that is accurate to four digits right of the decimal.) 16 Across all clients, what is the mean (average) monthly payment amount (using the individual interest rates calculated for each client in Q15)? (Again, note this entails calculating payment amounts, assume payments are due at the end of each period and the loan balance is completely paid at the end of the loan.) 17 Which client has the largest monthly payment, and what is that monthly payment amount? (client number and payment amount)
