A B D E F G H M N. O P You would like to determine the expected duration and variance for the project's seven activities named A to G. Table 4 has the weights assigned to optimistic, most likely, and pessimistic situations. The expected duration for an activity is the weighted average of the weights and the duration for the activities in each of the situations. As an example, expected duration for Activity A=Weight of Optimistic * Optimistic duration + Weight of Most Likely * Most Likely duration + Weight of Pessimistic * Pessimistic duration. (e) Using the Sumproduct function, write a formula in cell H25 to compute the Expected duration for Activity A. Copy the formula to cells H26 to H31. The variance of activity is computed using formula ((p - 0)/6)^2, where p is the pessimistic duration and o is the optimistic duration. The value 6 is the sum of the weights. 16 (f) Write a formula in cell 125 to compute the activity A variance. Copy the formula to cells 126 to 131. 17 18 Table 4: Weights Optimistic Most likely Pessimistic 19 (0) (m) (p) 20 1 4 1 21 Sample Answer 22 Table 5: Expected duration and variance for seven activities 23 Preceding Most likely Pessimistic Expected Table 5: Expected duration and variance for seven activities Activity Optimistic (o) Variance o? 24 Activities (p) t (days) Activity Preceding Most likely Pessimistic Expected Optimistic (0) Activities (p) 25 6 (m) A 7 8 t(days) A 6 7 8 7.00 26 B 6 9 14 B 6 9 14 9.33 27 A 7 9 11 C 7 9 11 9.00 28 D A 5 10 12 D 5 10 12 9.50 29 E C,B 7 10 12 E C,B 7 10 12 9.83 30 F D 8 8 11 D 8 8 11 8.50 31 G E,F 5 8 10 E,F 5 8 10 7.83 32 (m) Variance o? 0.111111 1.777778 0.444444 1.361111 0.694444 0.250000 0.694444 F G