Question: The RAND ( ) function in Excel returns a pseudo - random number between 0 and 1 . If you enter this function into 1
The RAND function in Excel returns a pseudorandom number between and If you enter this function into cells ie enter the formula in one cell and copy it to other cells approximately how many of these cells will contain values between to
A project has two activities A and B that must be carried out sequentially. The probability distributions of the times required to complete each of the activities A and B are uniformly distributed in intervals and respectively. Find the total project completion time and run simulation trials in Excel.
a What is the output of the simulations?
b What is the Excel functions would properly generate a random number for the duration of activity A in the project described above?
c What is the standard deviation of the project completion time in the project described?
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
