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

  1. 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

  1. 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

  1. 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

  1. 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!