Question 1 3 pts Data obtained from a county auditor in the worksheet Home Market Value provide information about the age, square footage, and current market value of houses along one street in a particular subdivision. Considering these data as a population of homeowners on this street, compute the mean, variance, standard deviation, and N N xi i=1 (+1-4) coefficient of variation, using formulas i=1 = N N X - u , and CV = Standard Deviation Mean Verify your i=1 0= calculations using the appropriate Excel function. Show your work in the worksheet and choose the right answers from the following three drop down lists: The mean house age is [Select ] A the variance of square feet is [Select] A [Select] (choose the correct unit), and the standard deviation of market value is (Select ] [ Select ] 9. Among the three, [Select ] has the greatest relative dispersion (You need to calculate CVs to answer this last question). Question 1 3 pts Data obtained from a county auditor in the worksheet Home Market Value provide information about the age, square footage, and current market value of houses along one street in a particular subdivision. Considering these data as a population of homeowners on this street, compute the mean, variance, standard deviation, and N N xi i=1 (+1-4) coefficient of variation, using formulas i=1 = N N X - u , and CV = Standard Deviation Mean Verify your i=1 0= calculations using the appropriate Excel function. Show your work in the worksheet and choose the right answers from the following three drop down lists: The mean house age is [Select ] A the variance of square feet is [Select] A [Select] (choose the correct unit), and the standard deviation of market value is (Select ] [ Select ] 9. Among the three, [Select ] has the greatest relative dispersion (You need to calculate CVs to answer this last question)