Ch. 5 Develping Discrete Probabiity using Excel

Please read through the problem before response: Please do problem 11. only.

 It shows us what the probability distributions are for discrete random variables (says, the number of TV's or computers sold; it can be X=0, 1, 2, 3, 4, or 5 with different probabilities, see Table 5.4 on P. 234). The chapter then shows us how to find the average value, variance, and the s.d. of the random variable. For instance, later in this chapter, it shows us how to find the average number of TV's sold, says 1.5 units shown in Table 5.5 on P. 239, and the variance of the number of TV's sold at 1.25 units in Table 5.6 on P. 239.

That is it. 

(1) What is the valid probability distribution --- "two" conditions (you have to check "two" conditions, not only "one" condition) on P. 234. There's no stats function for it.