Answer Happy

Posted: **Mon Jul 11, 2022 11:17 am**

: Data On The Number Of Occupants Was Collected For A Large Sample Of Renter Occupied Rent Controlled Housing Units As Pa 1 (27.74 KiB) Viewed 41 times

: Data On The Number Of Occupants Was Collected For A Large Sample Of Renter Occupied Rent Controlled Housing Units As Pa 2 (27.74 KiB) Viewed 41 times

: Data On The Number Of Occupants Was Collected For A Large Sample Of Renter Occupied Rent Controlled Housing Units As Pa 3 (27.74 KiB) Viewed 41 times

: Data On The Number Of Occupants Was Collected For A Large Sample Of Renter Occupied Rent Controlled Housing Units As Pa 4 (25.62 KiB) Viewed 41 times

expected value -
(a). =PRODUCT(A2:A6, B2:B6)
(b). =SUMPRODUCT(A2:A6,B2:B6)
(c). =AVERAGE(A2:A6, B2:3B)(d). =SUM(A2:A6,B2:B6)
(c). =AVERAGE(A2:A6, B2:3B)
(d). =SUM(A2:A6,B2:B6)
Variance -
(a). =PRODUCT(C2:C6,B2:B6)
(b). =SUMPRODUCT(C2:C6,B2:B6)(c). =VAR(C2:C6,B2:B6)(d). =SUM(C2:C6,B2:36)
(b). =SUMPRODUCT(C2:C6,B2:B6)
(c). =VAR(C2:C6,B2:B6)
(d). =SUM(C2:C6,B2:36)
standard deviation -
(a). =STDEV(A2:A6, C2:C6)(b). =SQRT(B9)(c). =PRODUCT(A2:A6, C2: C6)(d). =SUM(A2:A6, C2: C6)
(a). =STDEV(A2:A6, C2:C6)
(b). =SQRT(B9)
(c). =PRODUCT(A2:A6, C2: C6)
(d). =SUM(A2:A6, C2: C6)

: Data On The Number Of Occupants Was Collected For A Large Sample Of Renter Occupied Rent Controlled Housing Units As Pa 5 (22.4 KiB) Viewed 41 times

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 Xx 1 2 3 4 5 Probability f(x) 0.596 0.261 0.079 0.038 0.027 To answer the questions that follow, download an Excel spreadsheet containing the previous data by clicking the following words in bold: Download, Excel File. A 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 C):

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 C): 1 2 3 4 5 6 7 8 9 10 Number of Occupants 1 2 3 4 5 Expected Value Variance Standard Deviation In cell B8 of the spreadsheet, select spreadsheet. The expected value of B Probability 0.596 0.261 0.079 0.038 0.027 =PRODUCT(A2:A6,82:86) =SUMPRODUCT(A2:A6, B2:B6) =AVERAGE(A2:A6, B2:B6) =SUM(A2:A6, B2:B6) Sq Dev from Mean 0.128 1.844 5.560 11.276 hputing the expected value of x. Enter this formula in cell B8 of your Excel your intermediate calculations.)

In cell B8 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 (Do not round your intermediate calculations.) In cell C2, select the correct formula for computing the squared deviation of x from its expected value u when x 1. Enter this formula in call C2 of your Excel spreadsheet. The value of (x-μ)² when x = 1 is (Do not round your intermediate calculations.) In your Excel spreadsheet, copy the formula you entered in cell C2 to cells C3 through C6 to compute the values of (x-μ) 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 (Do not round your intermediate calculations.) 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