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)

College Algebra (MindTap Course List)
12th Edition
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:R. David Gustafson, Jeff Hughes
Chapter8: Sequences, Series, And Probability
Section8.7: Probability
Problem 39E: Assume that the probability that an airplane engine will fail during a torture test is 12and that...
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
College Algebra (MindTap Course List)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage