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

RAND function can be used to generate a random number between 0 and 1. We can then use a VLOOKUP function to match this random number to a corresponding value based on the probability distribution. Therefore, the best choice is the combination of the two functions - the RAND function and a VLOOKUP function.

In Order to Generate Random Numbers in Excel from a Discrete