In: Statistics and Probability
Plot the probability mass function (PMF) and the cumulative distribution function (CDF) of 3 random variables following (1) binomial distribution [p,n], (2) a geometric distribution [p], and (3) Poisson distribution [?]. You have to consider two sets of parameters per distribution which can be chosen arbitrarily. The following steps can be followed: Setp1: Establish two sets of parameters of the distribution: For Geometric and Poisson distributions take two values of p (p1 and p2) and take two values of [?], (?1 and ?2) respectively. For the binomial you should take two values of p and two values of n, first keep p fixed and change n, in the second keep n fixed and change p. Step 2: Generate the random variables (at least 10 values) [column 1] Step 3: Calculate the PMF [column 2] and CDF [column 3] Step 4: Plot the PMF and CDF in different graphics (It is recommended to combine the graphics while changing the parameters).
PLEASE DO IT IN EXCEL.SHOW HOW TO APPLY FORMULAS IN EXCEL.