ACCT 4310 / ACCT4310 Quiz Submissions - Quiz3A creditScore
Attempt 1
Written: Feb 10, 2020 9:45 AM - Feb 10, 2020 9:53 AM
Submission View
Your quiz has been submitted successfully.
Question 1 poin
Answer the questions based on the credit score conversation and data structure at the following link:
Credit score conversation and data structure.
Developing the analysis for the credit score cutoff decision in the following order would yield an analysis:
1 Determine the proportion of the purchase price paid down
2 Create a credit score attribute for each loan
3 Determine the number of payments that have to be paid for a loan to be current
4 Calculate the currency of each loan
1) with no redundant calculations
2) with redundant calculations
3) that cannot be completed
4) that gives ambiguous results
Hide Feedback
Because the number of payments is used in the calculation of the loan currency, the order that minimizes calculation
redundancy is the one indicated in the list.
Question 2 poin
Determining whether there are differences in how current loans are for loans with credit scores of 430-449 by vehicle
category requires attributes from these sheets:
1) loan and sales
, 2) loan and acquisitions
3) loan, dealer and acquisitions
4) loan, sales and acquisitions
Hide Feedback
The category is in the acquisitions sheet, which must be linked through the sales sheet on vehicleID. Thus, the loan,
sales, and acquisitions sheets are required.
Question 3 poin
Suppose a column for the dealer’s street is created in the setup sheet where the values are determined by the
following formula for the first loan (in row 2) and copied to the other rows. This formula returns:
=VLOOKUP(A2,Dealer!$A$2:$C$4,3,FALSE)
1) errors in cells for dealer street
2) correct values for dealer street
3) street values that are incorrect
4) null values for dealer street
Hide Feedback
The expression is correct except that the lookup parameter is set to column A (which contains vehicleID) rather than
column B (which contains dealerID), which causes the formulas to return errors in the cells for the street. Hmm…how
numerous are the ways in which formulas can be erroneous!
Question 4 poin
Suppose the following formula is used (for the loan in row 2) to determine the proportion of a vehicle’s price that the
buyer pays down and there is always a down payment. The formula is copied for the other loans. The formula:
= + D2/(C2+D2)
1) is correct
2) overstates the proportion
3) understates the proportion
Attempt 1
Written: Feb 10, 2020 9:45 AM - Feb 10, 2020 9:53 AM
Submission View
Your quiz has been submitted successfully.
Question 1 poin
Answer the questions based on the credit score conversation and data structure at the following link:
Credit score conversation and data structure.
Developing the analysis for the credit score cutoff decision in the following order would yield an analysis:
1 Determine the proportion of the purchase price paid down
2 Create a credit score attribute for each loan
3 Determine the number of payments that have to be paid for a loan to be current
4 Calculate the currency of each loan
1) with no redundant calculations
2) with redundant calculations
3) that cannot be completed
4) that gives ambiguous results
Hide Feedback
Because the number of payments is used in the calculation of the loan currency, the order that minimizes calculation
redundancy is the one indicated in the list.
Question 2 poin
Determining whether there are differences in how current loans are for loans with credit scores of 430-449 by vehicle
category requires attributes from these sheets:
1) loan and sales
, 2) loan and acquisitions
3) loan, dealer and acquisitions
4) loan, sales and acquisitions
Hide Feedback
The category is in the acquisitions sheet, which must be linked through the sales sheet on vehicleID. Thus, the loan,
sales, and acquisitions sheets are required.
Question 3 poin
Suppose a column for the dealer’s street is created in the setup sheet where the values are determined by the
following formula for the first loan (in row 2) and copied to the other rows. This formula returns:
=VLOOKUP(A2,Dealer!$A$2:$C$4,3,FALSE)
1) errors in cells for dealer street
2) correct values for dealer street
3) street values that are incorrect
4) null values for dealer street
Hide Feedback
The expression is correct except that the lookup parameter is set to column A (which contains vehicleID) rather than
column B (which contains dealerID), which causes the formulas to return errors in the cells for the street. Hmm…how
numerous are the ways in which formulas can be erroneous!
Question 4 poin
Suppose the following formula is used (for the loan in row 2) to determine the proportion of a vehicle’s price that the
buyer pays down and there is always a down payment. The formula is copied for the other loans. The formula:
= + D2/(C2+D2)
1) is correct
2) overstates the proportion
3) understates the proportion
