Question: Please completer following question using excel and VLOOKUP. Project Management. A project has four activities ( A , B , C , and D )
Please completer following question using excel and VLOOKUP.
Project Management. A project has four activities A B C and D that must be performe
sequentially. The probability distributions for the time required to complete each of the activities
are as follows:
a Construct a spreadsheet simulation model to estimate the average length of the project and
the standard deviation of the project length.
b According to your simulation model, what is the estimated probability that the project will be
completed in weeks or less?
Hint: The project time includes the summation of all activity times; use VLOOKUP function in
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
