In: Statistics and Probability
A project has five activities: A, B, C, and D, which must be carried out sequentially. The probability distributions of the number of weeks required to complete each of the activities A, B, and C are uniform in intervals [1,5], [2,3], and [3,6], respectively. The number of weeks required to complete activity D is a beta distribution with shape parameters a=2 and b=5, lower bound 2, and upper bound 10. Use simulation to forecast the total completion time of the project.
a. What are the mean and standard deviation of the total completion time?
b. What are the upper and lower bounds of a 95% confidence interval for the completion time?
c. What is the probability that the project will be completed within
for A to C column
for beta distribution
I generated Unif(0,1) in G column
then use BETA.INV(p, α, β , lower bound ,upper bound) for each p in G column
last Sum is A+ B+ C +D
then mean ,sd is calculate for sum