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. Now using the data on the Sheetl worksheet tab, explore the data quantitatively by evaluating the summary statistics as follows. Click here for the Excel Data File a. For each column of numerical data (Annual Income, Credit Score, Late Payments, Default 0/1) in the dataset, calculate the mean, median, standard deviation, minimum, and maximum. b. Create a correlation table showing the correlation coefficient between each of the following four variables: Annual Income, Credit Score, Late Payments, Default 0/1. Complete this question by entering your answers in the tabs below. Required A Required B For each column of numerical data (Annual Income, Credit Score, Late Payments, Default 0/1) in the dataset, calculate the mean, median, standard deviation, minimum, and maximum. Note: Round "Default 0/1" answers to 3 decimal places and round all other answers to 2 decimal places. If the answer is negative, include parentheses. Mean Median Standard Deviation Minimum Maximum Annual Income Credit Score Default 0/1 Show less A

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 incorne 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. Now using the data on the Sheetl worksheet tab, explore the data quantitatively by evaluating the summary statistics as follows. Click here forthe Excet Data File a. For each column of numerical data (Annual Income, Credit Score, Late Payments, Defoult on) in the dataset, calculate the mean, median, standard deviation, minimum, and maximum. b. Create a correlation table showing the correlation coefficient between each of the following four variables: Annual income, Credit Score Late Payments, Default O/L Complete this question by entering your answers in the tabs below. For each column of numerical data (Annual Income, Credit Scove, Late Payments, Defautt Q/x ) in the dataset, calculate the mean, median, standard deviation, minimum, and maximum. Note: Round "Default 0/1 answers to 3 decimal places and round all other answers to 2 decimal places. If the answer is negative, include parentheses