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). Which of the following statements are correct? Assuming cells C4 to C7 were set up correctly, then the formula "=C5" would work in cell D4. Exactly two answers are correct. Cell D7 will have a value of "0.85". The value "0.2" goes in cell C5. The formula "=B4+B5" would work for cell D5
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
