5. Suppose X is a binomial random variable with n = 10 and P = 0.17 and Y is a binomial random variable with n = 14 and P = 0.37. a. Use MS Excel to compute the probabilities associated with all values of X and Y. In column A, type the sample space for X beginning with 0 in cell A1. Click on the empty cell B1, then click on the = symbol in front of the long blank white area located just above the column letters. In this cell, type BINOMDIST(A1, 10,0.17,0). By first clicking on the = symbol, you instruct Excel to treat the contents of cell B1 as a formula rather than just text. A1 in the the formula indicates you want a binomial probability for the X = 0 value in cell A1. Copy this formula down B column to compute the probability for each value of X in the sample space. Repeat this procedure for random variable Y in columns C and D. Print-out the part of the spreadsheet that contains these probability distributions and append to this sheet. b. Compute the probability that X will be an odd number. c. Compute the probability that Y will be an odd number. d. Compute the probability that X and Y will be an odd number