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). 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

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!