Question: Answer the next 3 questions using the following information: A project has three activities A , B , and C that must be carried out

Answer the next 3 questions using the following information: A project has three activities A, B, and C that must be carried out sequentially. The probability distributions of the times required to complete each of the activities A, B, and C are uniformly distributed in intervals [1,5],[2,3] and [3,6], respectively. Find the total project completion time and run 1000 simulation trials in Excel.
Which of the following Excel functions would properly generate a random number for the duration of activity A in the project described above?
Group of answer choices
1+5* RAND()
NORM.INV(RAND(),1,5)
1+4* RAND()
NORM.INV(RAND(),5,1)
5* RAND()

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!