Which of the following Excel functions would properly generate a random number for the duration of activity A in the project described above, which is uniformly distributed in intervals [1.7)? 07 RANDO 01-5 RANDO O 1+6" RANDO 01-7 RANDO O NORMINVERANDO.5.1)
Which of the following Excel functions would properly generate a random number for the duration of activity A in the project described above, which is uniformly distributed in intervals [1.7)? 07 RANDO 01-5 RANDO O 1+6" RANDO 01-7 RANDO O NORMINVERANDO.5.1)
A First Course in Probability (10th Edition)
10th Edition
ISBN:9780134753119
Author:Sheldon Ross
Publisher:Sheldon Ross
Chapter1: Combinatorial Analysis
Section: Chapter Questions
Problem 1.1P: a. How many different 7-place license plates are possible if the first 2 places are for letters and...
Related questions
Question
A1
Transcribed Image Text:Which of the following Excel functions would properly generate a random number for the duration of activity A in the project described
above, which is uniformly distributed in intervals (1.7)?
O RANDO
O 1+5 RANDO
O1+6RANDO
O1+7 RANDO0
ONORMINVIRANDOS.1)
Transcribed Image Text:A project has three activities A, B, and C that must be carried out sequentially; in order of A, then B, then C. The probability distributions
of the times required to complete each of the activities A. B, and C are uniformly distributed in intervals (1.7), (2,3) and [3,5) respectively.
Run 1000 simulation trials in Excel.
The "total project completion time" is a(n).
O Output of the simulation
O Input of the simulation
Decision variable in the simulation
O A fixed value in the simulation
Question 9
For the above project having three activities A, B, and C that must be carried out sequentially. The standard deviation of the project
completion time in the project described above is closest to:
O 189
O 147
O 211
O 235
O 163
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 7 images
Recommended textbooks for you
A First Course in Probability (10th Edition)
Probability
ISBN:
9780134753119
Author:
Sheldon Ross
Publisher:
PEARSON
A First Course in Probability (10th Edition)
Probability
ISBN:
9780134753119
Author:
Sheldon Ross
Publisher:
PEARSON