Fill in these overall probabilities after you fill in the decision tree\'s branc

Question

Fill in these overall probabilities after you fill in the decision tree's branch probabilities via the SUM macro as indicated by color. Make sure to keep the SAME formatting in these 10 cells as are found in the 3 tables at the below right... Pass Overa Tier 1 Tier 2 Tier 3 the same as in the data tables Prix = r) 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0001 0.0004 0.0010 0.0021 0.0043 0.0078 0.0131 0.0206 0.0301 0.0412 0.0530 0.0646 0.0744 0.0815 0.0851 0.0847 0.4360 Format Pr(Fail Overall) 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0000 0.0001 0.0002 0.0005 0.0014 0.0031 0.0064 0.0120 0.0206 0.0325 0.0474 0.0640 0.0802 0.0936 0.1017 0.1033 0.0982 0.0875 0.0731 0.0574 0.0423 0.0294 0.0192 0.0118 0.0069

Explanation / Answer

For Tier 1, P(x <= 21) = P(x = 0) + P(x = 1) + P(x = 2) + .....+ P(x = 21)

So, in this spreadsheet, in the cell where it is asked to input P(x <= 21) for tier 1 (which is Pass), you would enter '=SUM(M5:M26)' (Here, I'm assuming that cell M5 contains Pr(x = r) value for r = 0 which is 0.000 and the cell M26 contains Pr(x = r) value for r = 21 which is 0.1017).

Similarly, in the cell where it is asked to input P(x <= 24 and x >= 22 ) for tier 1 (which is Maybe), you would enter '=SUM(M27:M29)' because P(x <= 24 and x >= 22 ) = P(x = 22) + P(x = 23) + P(x = 24).

Employ the same procedure for all the other probabilities while being careful to check index numbers in to the excel sum formula according to the boundaries set by the definition. Also, colour format these probability cells with same colours as those columns from which probabilities are calculated (Tier 1: beige, Tier 2: pink, Tier 3: purple).

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.