Skip to content

Binary Classification (graded) :Mastering Data Analysis in Excel (Excel to MySQL: Analytic Techniques for Business Specialization) Answers 2025

  1. Question 1
    False Positive rate:

✔️ 12.5%
❌ 50%
❌ 10%
❌ 30%

  1. Question 2
    If a fire alarm fails to go off when there is a fire, that is a:

✔️ False Negative
❌ False Positive
❌ True Negative
❌ True Positive

  1. Question 3
    If classification incidence = 10% and condition incidence = 12%, the True Positive rate:

✔️ cannot be 100%
❌ must be 100%
❌ can be 100%
❌ must be 0%

  1. Question 4
    Max cost per False Negative that permits average cost/test = $100 (FP cost = $500):

✔️ $12,262
❌ $17,082

  1. Question 5
    With FN = $15,000 and FP = $100, minimum average cost per test:

✔️ $16,551
❌ $1.00
❌ $259,800
❌ $25.98

  1. Question 6
    With FN = $7,500 and FP = $50, what changes?

✔️ The minimum Cost per Test
❌ The False Positive Rate
❌ The True Positive Rate
❌ The minimum cost threshold of 16,551.930

  1. Question 7
    Increasing cost per FN (FP constant) — cost-minimizing threshold will:

✔️ Decrease
❌ Increase
❌ Stay the Same

  1. Question 8
    After changing D43 from 0 → 1 (4 bombers, 16 seagulls): new AUC:

✔️ 0.78
❌ 0.824
❌ 0.75
❌ 0.72

(best-effort — depends on the exact spreadsheet sorting; I can confirm if you upload the file)

  1. Question 9
    With FN cost = 5M and FP cost = 4M, changing D43 from 0 → 1 changes minimum cost per event by:

✔️ Increases by 950,000 pounds
❌ Increases by 5 million pounds
❌ Unknown
❌ Increases by 250,000 pounds

(best-effort estimate based on the event-weighted cost impact; will confirm with the spreadsheet if you want)

  1. Question 10
    Change cost per FN to 50 million pounds. How does changing D43 from 0 → 1 change the cost-minimizing threshold?

✔️ Decreases it from 75 to 70
❌ Increases it from 66 to 75
❌ Decreases it from 75 to 62
❌ Decreases it from 75 to 66

(best-effort — spreadsheet-dependent; can verify exactly if you share the file)

  1. Question 11
    Population incidence 20%, TPR 70%, FPR 10% → Positive Predictive Value (PPV):

✔️ 0.64
❌ 0.36
❌ 0.50
❌ 0.60

(Calc: PPV = (0.7×0.2) / (0.7×0.2 + 0.1×0.8) = 0.14 / 0.22 ≈ 0.636 → 0.64)

  1. Question 12
    Threshold of 24 years on ROC (oldest at top) corresponds to:

✔️ .67, .33
❌ .33, .67
❌ .25, .75
❌ .5, .5

🧾 SUMMARY TABLE

Q No. Correct Answer
1 12.5%
2 False Negative
3 cannot be 100%
4 $12,262
5 $16,551
6 The minimum Cost per Test
7 Decrease
8 0.78 (best-effort)
9 Increases by 950,000 pounds (best-effort)
10 Decreases it from 75 to 70 (best-effort)
11 0.64
12 .67, .33