Multiple Choice
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
Correct Answer:
Verified
Correct Answer:
Verified
Q5: It is common in computer simulations to
Q8: The RAND() function in excel models which
Q10: Which of the following statements is true
Q16: The triangular distribution is sometimes used in
Q29: Which of the following statements are false
Q39: Data tables in spreadsheet simulations are useful
Q44: One important special use of bounded distributions
Q45: A discrete distribution is useful for many
Q47: The "building blocks" of all spreadsheet simulation
Q51: Obtain another set random numbers by pressing