Friendly Bank is very active with making loans to deserving people in the local community. However, the bank does need to carefully evaluate each loan to make sure that the recipient of the loan will likely repay the loan as scheduled. Therefore, the bank needs to obtain a prediction of whether this is likely and what the probability is. The bank primarily uses the annual income and the credit rating of the person applying for the loan as the predictor variables for obtaining this prediction. The bank has compiled all of the historical records of substantial loans and their outcomes over recent years. This information is provided in the spreadsheet. Click here for the Excel Data File a. Identify the three loan applicants that have missing data by specifying the loan number and the data that is missing. b. Select any suspicious data, indicating the loan number. c. Some analysis requires numerical rather than text data. Add another column to the dataset labeled "Default 0/1" and transform the Yes & No data in the "Default "column to O's and I's in the new column with a 1 representing Yes and a O representing No. Complete this question by entering your answers in the tabs below. Required A Required B Required C Identify the three loan applicants that have missing data by specifying the loan number and the data that is missing. Loan Number Missing Data Required A Required B > Complete this question by entering your answers in the tabs below. Required A Required B Required C Select any suspicious data, indicating the loan number. Note: You may select more than one answer. Single click the box with the question mark to produce a check mark for al correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect. Loan number: 1443 Loan number: 1545 Loan number: 2449 Loan number: 2475) Loan number: 4488 Loan number: 4540 Loan number: 4450 Show lessA a. Identify the three loan applicants that have missing data by specifying the loan number and the data that is missing. b. Select any suspicious data, indicating the loan number. c. Some analysis requires numerical rather than text data. Add another column to the dataset labeled "Default 0/1 and transform the Yes & No data in the "Default "column to O's and 1's in the new column with a 1 representing Yes and a O representing No. Complete this question by entering your answers in the tabs below. Required A Required B Required C Some analysis requires numerical rather than text data. Add another column to the dataset labeled "Default 0/1" and transform the Yes & No data in the "Default "column to 0's and 1's in the new column with a 1 representing Yes and a 0 representing No. Select the correct formula you would enter into cell F2: < Required B Required C