YouDriveOut: The conversation The scene: Executives at YouDriveOut, a chain of used car lots, are brainstorming about how to ensure consistent financial performance. Alicia is the CFO, and Manuel is the Controller. Alicia Manuel, I'm thinking about switching our minimum credit score cutoff from 430 to 450 to improve our overall loan performance, that is, to increase the proportion of payments that our customers make on loans. Manuel You want me to compare the loan default rates for these? Alicia Yes, that's the idea. Manuel Any particular format? Alicia No, but whatever you create should show the difference in overall loan performance with the sales impact for the two cutoff numbers. And be sure to do the analysis by dealer with the dealer street address. Pivot tables could be useful. It would also be helpful to see the analysis by vehicle category. YouDriveOut: Credit score cutoff analysis Required: Download the loan data creditScore.xlsx (in iCollege). 2 Arrange your desktop to show the Word file and the Excel file before working on the analysis. 3 Plan the analysis by responding to the following steps and questions based on the conversation. Put responses in the Response column. When the responses name an What to analysis operation that you do not know how to do, enter it in the What to learn/How to Response learn/How to do it column. When you learn how to do it, explain it in the What to learn/How to do it do it column. a State the overall objective of the analysis. Identify assumptions embedded in the conversation. Verify that attributes required for the analysis are available in creditScore.xlsx (in College). Data definitions for the attributes are available in Table 1 (in iCollege)