1.Suppose loan currency was compared for the following credit score strata: (1) <450 (2) 450-469 (3) 470 and above This configuration for the credit score strata:

Question options:

1)	includes all relevant strata

2)	includes unnecessary strata

3)	needs a stratum for 490 and above

4)	conceals some relevant outcomes

Hide Feedback

Feedback: Because loans with credit scores of <430 have slightly higher loan currency than those with credit scores in the 430-449 stratum, including them in the 430-449 conceals some relevant outcomes. For a complete analysis, loans with credit scores less than 430 should be included in their own strata, i.e., < 430.

2.Creating the table below requires use of data from which sheets:

Question options:

1)	loan, acquisitions, and sales

2)	loan, dealer, and sales

3)	loan and acquisitions

4)	loan and sales

Hide Feedback

Feedback: The loan sheet contains attributes relevant to evaluating the proposed change to the minimum credit score on an overall basis. The make attribute is in acquisitions, which requires a join (or VLOOKUP) on vehicleID to sales, which requires a join (or VLOOKUP) on loanID to loan.

Please, find right answers, and you can also read the feedbacks.