In order to generate random numbers in Excel^® from a discrete distribution with a finite number of possible values and corresponding probabilities, we can use: A) only the RAND function B) only the VLOOKUP function C) only the VLOOKDOWN function D) the RAND function along with a VLOOKUP function

Question

Quizplus · Accepted Answer

The RAND function generates a random number between 0 and 1, which can be used to select a value from the distribution based on its probability. The VLOOKUP function allows us to match the random number to the corresponding value in the distribution based on its probability. Therefore, using both functions together allows us to generate random numbers from a discrete distribution with a finite number of possible values and corresponding probabilities.

In Order to Generate Random Numbers in Excel® from a Discrete

In Order to Generate Random Numbers in Excel^® from a Discrete