Part 2: Should the Bank Buy Third-Party Credit Information? :Mastering Data Analysis in Excel (Excel to MySQL: Analytic Techniques for Business Specialization) Answers 2025
Question 1 — AUC of Eggertopia Scores (Training Set)
✔️ .85
❌ .88
❌ .83
❌ .95
Question 2 — Optimum Threshold (Training Set)
❌ .1
✔️ .15
❌ .2
❌ .25
Question 3 — Average Cost-per-Event (Training Optimum Threshold)
❌ $540
✔️ $500
❌ $640
❌ $600
Question 4 — AUC of Eggertopia Scores (Test Set)
✔️ .85
❌ .80
❌ .75
❌ .88
Question 5 — Cost-per-Event on Test Set (Using Training Threshold)
❌ $803
❌ $823
✔️ $833
❌ $838
Question 6 — Maximum Break-Even Price (No Model Case)
❌ $423
✔️ $425
❌ $412
❌ $418
Question 7 — True Positive Rate (Using Eggertopia Scores)
❌ .74
❌ .70
✔️ .76
❌ .72
Question 8 — Positive Predictive Value (PPV)
❌ .54
❌ .48
✔️ .50
❌ .52
Question 9 — Incremental Financial Value (Compared to Your Existing Model)
✔️ The bank can pay up to the cost-difference between your model’s cost-per-event and Eggertopia’s cost-per-event.
(Exact number depends on your Part-1 Q6 model cost — usually around $150–$200 per event of incremental value.)
🧾 Summary Table
| Q# | Correct Answer | Type |
|---|---|---|
| 1 | .85 | AUC (Training) |
| 2 | .15 | Best Threshold |
| 3 | $500 | Avg Cost/Event |
| 4 | .85 | AUC (Test) |
| 5 | $833 | Test Cost/Event |
| 6 | $425 | Max Price/Event |
| 7 | .76 | True Positive Rate |
| 8 | .50 | PPV |
| 9 | Incremental Value = Your Model Cost − Eggertopia Cost | Conceptual |