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...
icon
Related questions
Question
A1
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: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)
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
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
steps

Step by step

Solved in 3 steps with 7 images

Blurred answer
Recommended textbooks for you
A First Course in Probability (10th Edition)
A First Course in Probability (10th Edition)
Probability
ISBN:
9780134753119
Author:
Sheldon Ross
Publisher:
PEARSON
A First Course in Probability
A First Course in Probability
Probability
ISBN:
9780321794772
Author:
Sheldon Ross
Publisher:
PEARSON