mba 522 appendix 5-2 binomial

# mba 522 appendix 5-2 binomial - trials p 10 0.3 x 0 1 2 3 4...

This preview shows page 1. Sign up to view the full content.

This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: trials p 10 0.3 x 0 1 2 3 4 5 6 7 8 9 10 f(x) 0.028248 0.121061 0.233474 0.266828 0.200121 0.102919 0.036757 0.009002 0.001447 0.000138 5.9E-006 P(X < = x) 0.028248 0.149308 0.382783 0.649611 0.849732 0.952651 0.989408 0.99841 0.999856 0.999994 1 P(X > = x ) 1 0.9717525 0.8506917 0.6172172 0.3503893 0.1502683 0.047349 0.0105921 0.0015904 0.0001437 5.905E-006 1. The first column I generated is f(x). I used FALSE b/c I don't want cumulative prob distribution. I just want the probability of exact values of x reported. 2. The second column I generated reports the probability that the random variable takes on values of x or lower. I used TRUE because I wanted the cumulative distribution to be produced. 3. The third column I generated reports the probability that the random variable takes on values of x or higher than X. W ith a formula that I wrote, I used entries in the f(x) column to generate this third column. Please click on various cells in each column to see the formula bar. As to why your attempt did not work, I bet it is b/c for selecting the 10 and the 0.3 as your wrote the formulas, y ou did not use the \$ signs in designating the cell address. Notice in writing the formula for cell D5, I have used \$ B\$ 1 for referencing 10. Similarly, in writing the formula for D5, I have used \$ B\$ 2 for referencing 0.3. Reason: as I copy the formula down the column, the reference to these cells remain FIXED and does not change to the cell below it. Let me know if this answers your question. Dr. J. ...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online