Question 6 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). A B 1 Probability Example 2 3 4 5 6 7 8 89 9 10 X 1 2 3 4 Total f(x) 0.20 0.30 0.35 0.15 1 F(x) =VLOOKUP(RAND(),D4:E7,2,false) =VLOOKUP(RAND(),D4:E7,2,true) =VLOOKUP(RAND(),B4:E7,4,true) =VLOOKUP(RAND(),C4:F7,3,true) D None of the answers are correct. F'(x) E X 12 3 4 1 pts F 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:

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: -VLOOKUP(RAND0,D4:E7,2,false) -VIOOKUP(RAND0,D4:E7,2,true) -VLOOKUP(RAND0,B4:E7, A,true) -VIOOKUP(RAND(),CA:F7,3,true) None of the answers are correct