On a certain flight, from prior data, 70% of passengers will buya meal. A typical row in the economy section of this flight seats10 in "3-4-3" seating. Create an Excel spreadsheet. In your Excelspreadsheet, answer the following questions: a. What method wasused to determine that 70% of passengers will buy a meal? b. Usethe letter M to stand for your random variable. What is the meaningof M? The answer to this question begins, "Let M = ...." c. Whatprobability distribution is appropriate to assign to M? d. Computethe probability mass function, pmf, of that probabilitydistribution from (c) above using an Excel formula. The values ofthe pmf should be in one vertical column (see the attached PDF foran example). NOTE 1: You can put n and p somewhere on your Excelsheet. Then, in your computation of the pmf, using =BINOM.DIST(),you should reference (and "lock") the cells. NOTE 2: Looking below,you can see that you are asked to create the cdf adjacent to thispmf. If you lock the column here in (d), then you can copy the=BINOM.DIST() formula to the adjacent column, and simply change theFALSE to TRUE. Then, you can propagate the formula down and bedone. e. Compute the cumulative distribution function, cdf, usingan Excel formula. The values of the cdf should be in one verticalcolumn, adjacent to the pdf. f. Verify Excel's formula in d. asfollows: Create one column based on Excel's version of nCr =COMBIN(n, r) Create an adjacent column that computes theprobability of the successes Create an adjacent column thatcomputes the probability of the failures Multiply the three factorsand verify that this matches the numerical value in d g. In atypical row in economy, how many passengers would you expect topurchase a meal? h. How likely is this to occur? i. Compute theinterval one standard deviation, ?, above and one standarddeviation below this expected value. j. What is the probability ofthe interval P(? - ? ? M ? ? + ?) = ? k. What is the probabilitythat at least one passenger buys a meal in a typical row ineconomy? l. What is the probability that no passenger buys a mealin a typical row in economy? Upload your Excel workbook file tothis assignment. NOTE: Two OPTIONAL opportunities for extra credit:I. Create a graph of the probability mass function, pmf, the "comb"function. II. Create a graph of the cumulative probabilitydistribution, cdf, the step function (HARDER). You may do eitherone or both for extra credit.