Skip to content

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