In the class we analysed bank loan applications. Using this information as an input complete the following tasks. Each student should use only the assigned subset of data to complete this task. The data rows assigned to each student will be published in the portal together with the Excel data file from the class. Please note, youll be using the same subset of data as you used for Assignment 1. Please assume for this assignment that all the loans were provided in CAD (ignore currency column). There is no need to apply any additional filters. Task 1: Regression analysis The bank manager is asking you if it is possible to predict the loan amount that the applicant will be approved for based on their credit score. 1) Build a regression model with the data you have. 2) Interpret the model and validate if this model can be used for prediction 3) If the model is valid, please answer the question: what will be the predicted approved loan amount for the applicant with a credit score of 701? Task 2: Cluster analysis The bank manager is wondering if there are specific market segments among loan applicants. In particular, she is interested to know how many segments (clusters) exist in the subset of data and how are they different. 1) Run the cluster analysis 2) Determine the optimal number of customer segments 3) Explain the results and provide your insights and observations