You work for Lending Club as an accounting data analyst and you have been tasked with developing a diagnostic model of loan repayment. Your task is to use appropriate software tools, including Microsoft Office Excel and Tableau, to analyze data provided by the company. Your ultimate goal is to understand the link between loan characteristics, initial loan approval, and future loan repayment.

Part 1 – Written Report:

The report should cover all five deliverables as described on p. 280 of the textbook (link available on Blackboard) and follow the guidelines outlined on the next page.

Deliverable 1: Create and start working on your report

Deliverable 2: Prepare a DescriptiveStatistics of the Independent and Dependent Variables

Deliverable 3: Transform Data and Prepare another Set of Descriptive Statistics

Deliverable 4: Perform the Analysis

Deliverable 5: Create the Final Report

IMPORTANT: You must follow all instructions and formatting requirements (p. 280 of the textbook), carefully and exactly. If in doubt, reach out to your instructor.

Part 2 – Presentation:

Prepare a professional presentation to the Chief Loan Officer of Lending Club discussing your analysis. This presentation should be about 10 minutes in length and summarize the main findings and recommendations from your written report. It should be professional-looking, informative, and must include outputs, charts, and visualizations from Microsoft Office Excel and/or Tableau. You can use either PowerPoint or Tableau to prepare the presentation. You should record your presentation and submit it before the deadline.

Part 3 – WorkPapers (Files):

Prepare all your analysis, including visualizations, in Microsoft Office Excel and/or Tableau. All your work papers must be submitted with your report and should be organized in a professional, easy-to-follow way. Add explanations to your visualizations where necessary