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

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

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!