Question: QUESTION 10 The RAND() function in excel models which of the following probability distributions? a. Normal distribution with mean 0 and standard deviation 1 b.
QUESTION 10
-
The RAND() function in excel models which of the following probability distributions?
a. Normal distribution with mean 0 and standard deviation 1
b. Uniform distribution with lower limit 0 and upper limit 1
c. Normal distribution with mean -1 and standard deviation 1
d. Uniform distribution with lower limit -1 and upper limit 1
QUESTION 11
-
If x is a random number between 0 and 1, then we can use x to simulate a variable that is uniformly distributed between 100 and 200 using the formula:
a. 100 + x
b. 200 - x
c. 100 + 100x
d. 200x
QUESTION 12
-
Which of the following statements is true regarding the Triangular distribution
a. It is a discrete distribution with a minimum, maximum and most likely value
b. It is more flexible and intuitive than the normal distribution
c. It is a symmetric distribution
d. All of these options
QUESTION 13
-
Solver can get stuck at a local optimum and never find the global optimum.
True
False
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
