Required Information Lab Note: The tools presented in thls lab periodically change. Updated instructions, if applicable, can be found in the eBook and lab walkthrough videos in Connect. Case summary: LendingClub Is a peer-to-peer marketplace where borrowers and Investors are matched together. The goal of LendingClub is to reduce the costs assoclated with these banking transactions and make borrowing less expensive and investment more engaging. LendingClub provides data on loans that have been approved and rejected since 2007, Including the assigned interest rate and type of loan. This provides several opportunittes for data analysis. There are several Issues with this dataset that you have been asked to resolve before you can process the data. This will require you to perform some cleaning, reformatting, and other transformation techniques. Data: Lab 2-3 Lending Club Approve Stats.zlp - 120MB ZIp / 120MB Excel Note: Submit your answers for the following Analysis Questions in the text entry fleld below. AQ1. What do you expect will be major data quality issues with LendingClub's data? Required Information Lab Note: The tools presented in this lab periodically change. Updated instructions, if applicable, can be found in the eBook and lab walkthrough videos in Connect. Case summary: LendingClub is a peer-to-peer marketplace where borrowers and Investors are matched together. The goal of LendingClub is to reduce the costs assoclated with these banking transactions and make borrowing less expensive and investment more engaging. LendingClub provides data on loans that have been approved and rejected since 2007 , including the assigned interest rate and type of loan. This provides several opportunitles for data analysis. There are several issues with this dataset that you have been asked to resolve before you can process the data. This will require you to perform some cleaning, reformatting, and other transformation techniques. Data: Lab 2-3 Lending Club Approve Stats.zlp - 120MB ZIp / 120MB Excel Note: Submlt your answers for the following Analysis Questions in the text entry field below. AQ1. Why do you think it is Important to remove text values from your data before you conduct your analysis? AQ2. What do you think would happen in your analysis if you didn't remove the text values? AQ3. Did you run into any major issues when you attempted to clean the data? How did you resolve those? AQ4. What are some steps you could take to clean the data and resolve the difficulties you Identified