Data on 'd'1e number of occupants was collected for a large sample of renteroccupied, rentcontrolled housing units as part of the New York City Housing and Vacancy Survey. The relative frequency.' method is used to develop the following probability distribution for the number of occupants in a renteroccupied, rent-controlled housing unit in New York City: Number of Occupants 1: Probability P(x) 1 [1.596 2 [1.261 3 0.0?9 4 [1.038 5 0.02? To answer the quesh'ons that follow, download an Excel spreadsheet containing the previous data by clicking the following words in bold: Download Excel File. \fIn cell BB of the spreadsheet, select the correct Excel formula for computing the expected value of X. Enter this formula in cell BS of your Excel spreadsheet. The expected value of X is E . In cell C2, select the correct formula for computing the squared deviation of X from its expected value p when x = 1. Enter this formula in cell (:2 of vour Excel spreadsheet. The value of (x u]!2 when x = l is V . In vour Excel spreadsheet, copvr the formula you entered in cell C2 to cells C3 through C6 to compute the values of {x p)2 for x = 2 through 5. The values in your spreadsheet should match the values shown in the previous spreadsheet. In cell 39, select the correct formula for computing the variance of X. Enter this formula in vour Excel spreadsheet. The variance of X is V . In cell Bll], select the correct formula for computing the standard deviation of X. Enter this formula in your Excel spreadsheet. The standard deviation of X is v