Data on the number of occupants was collected for a large sample of renter-occupied, rent-controlled 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 renter-occupied, rent-controlled housing unit in New York City: Number of Occupants Probability
x f(x)
1 0.596
2 0.261
3 0.079
4 0.038
5 0.027
The upper left-hand corner of the Excel spreadsheet in the file you download should look like the following sample spreadsheet (except for the numeric values in column
Number of Occupants Probability Sq Dev from Mean
1 x f(x)
2 1 0.596
3 2 0.261 0.128
4 3 0.079 1.844
5 4 0.038 5.560
6 5 0.027 11.276
7
8 Expected Value
9 Variance
10 Standard Deviation
In cell B8 of the spreadsheet, select the correct Excel formula for computing the expected value of x. Enter this formula in cell B8 of your Excel spreadsheet. The expected value of x is.
In cell C2, select the correct formula for computing the squared deviation of x from its expected value μ when x1. Enter this formula in cell C2 of your Excel spreadsheet. The value of (x - )2 when x = 1 is___.
In your Excel spreadsheet, copy the formula you entered in cell C2 to cells C3 through C6 to compute the values of (x-μ)2 for x 2 through 5. The values in your spreadsheet should match the values shown in the previous spreadsheet.
In cell B9, select the correct formula for computing the variance of x. Enter this formula in your Excel spreadsheet. The variance of x is___.
In cell B10, select the correct formula for computing the standard deviation of x. Enter this formula in your Excel spreadsheet. The standard deviation of x is.