Question: Suppose there is the discrete probability distribution shown in the screen capture below under the X and f(x) columns. Let F(x) be the cumulative probability

Suppose there is the discrete probability distribution shown in the screen capture below under the X and f(x) columns. Let F(x) be the cumulative probability distribution and F(x) be the adjusted version discussed in Week 6 for simulating random draws from X. The goal is to complete the set up of the experiment in Excel where a random draw can be taken from X with the corresponding probabilities, f(x) Assuming that the proper values are entered in cells C4 through D7. A formula that would work to simulate a random draw from this probability distribution would be: Exactly two answers are correct. =VLOOKUP(RAND(),D4:E7,2,false) =VLOOKUP(RAND(),B4:E7,4,true) =VLOOKUP(RAND(),C4:F7,3,true) =VLOOKUP(RAND(),D4:F7,2,true)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
