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 coefficient of variation

(What do I fill in formula wise for the remaining yellow?) Thank you!

A 1 Home Market Value 3 5 6 7 8 9 10 * 11 12 13 14 15 16 17 18 19 20 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 42 43 44 45 46 47 48 49 50 House Age 33 32 32 33 32 33 33 32 33 32 32 32 32 33 32 32 32 32 28 27 28 28 28 28 25 27 28 28 27 27 28 27 28 28 27 27 28 27 27 D PLEASE dearly label every cell/column in your work Square Feet Market Value 1,812 $90.000.00 1,914 $104,400.00 1,842 $93.300.00 1,812 $91,000.00 1,836 $101.900.00 2,028 $108.500.00 1,732 $87.600.00 1,860 $96.000.00 1,791 SR9 200.00 1,866 $88.400.00 1,052 $100,800.00 1,620 1,692 2,372 $114.000.00 2,372 $113,200.00 1,666 $87.500.00 2,123 $116.100.00 1,820 $94.700.00 1,731 SAU 100.00 1,666 Tuco 1,520 1,484 1,588 1,598 1,484 1,484 1,520 1,520 1,520 1,484 1,520 $96.700.00 587.500.00 1,701 $94.200.00 1,484 1,468 1,668 1,588 1,784 1,484 $97.100.00 $83.400.00 $79.800.00 $81,500.00 $87,100.00 $82.600.00 $78,800.00 $87.600.00 $82.000.00 $88,100.00 $88,100.00 SHE GIU 0 $76.600.00 $84,400.00 $90,900.00 $81.000.00 591.300.00 $81,300.00 1,520 $100.700.00 1,520 S87,200.00 $96.700.00 1,684 1,581 $120.700.00 SUM COUNT MEAN MEAN Using AVERAGE() House Age E 29.83333333 29.83333333 -SUMA4:A45) -COUNT(A4 A45) -E4/E5 1253 42 =AVERAGE(A4:A45) Square Feet 71.201 42 1896.261905 1,695 =SUM(B4:845) -COUNT(B4 845) -F4/F5 =AVERAGE B4:846) You need to calculate the following manually without using Excel functions: -Mean house age Varlance of square feet PLEASE HIGHLIGHT the result cells. Make sure you label every column and cell in your work. - Standard deviation of market value Then verify your results using Excel functions AVERAGE, VAR.P and STDEV.P You also need to calculate CVs for all three columns. Market Value G $3,866,900.00 42 $92,069.05 $92,069.05 -SUM(C4:045) -COUNT(C4 C45) -G4/G5 O =AVERAGEIC4:C45) SUM VARIANCE STD DEV H House Age Squared Deviation 35.39774004 I Square Feet Squared Deviation 265.8351551 J Market Vak Squared Deviation 1966 44340 =SQRT(E4) K -SORT(F4) A 1 Home Market Value 3 5 6 7 8 9 10 * 11 12 13 14 15 16 17 18 19 20 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 42 43 44 45 46 47 48 49 50 House Age 33 32 32 33 32 33 33 32 33 32 32 32 32 33 32 32 32 32 28 27 28 28 28 28 25 27 28 28 27 27 28 27 28 28 27 27 28 27 27 D PLEASE dearly label every cell/column in your work Square Feet Market Value 1,812 $90.000.00 1,914 $104,400.00 1,842 $93.300.00 1,812 $91,000.00 1,836 $101.900.00 2,028 $108.500.00 1,732 $87.600.00 1,860 $96.000.00 1,791 SR9 200.00 1,866 $88.400.00 1,052 $100,800.00 1,620 1,692 2,372 $114.000.00 2,372 $113,200.00 1,666 $87.500.00 2,123 $116.100.00 1,820 $94.700.00 1,731 SAU 100.00 1,666 Tuco 1,520 1,484 1,588 1,598 1,484 1,484 1,520 1,520 1,520 1,484 1,520 $96.700.00 587.500.00 1,701 $94.200.00 1,484 1,468 1,668 1,588 1,784 1,484 $97.100.00 $83.400.00 $79.800.00 $81,500.00 $87,100.00 $82.600.00 $78,800.00 $87.600.00 $82.000.00 $88,100.00 $88,100.00 SHE GIU 0 $76.600.00 $84,400.00 $90,900.00 $81.000.00 591.300.00 $81,300.00 1,520 $100.700.00 1,520 S87,200.00 $96.700.00 1,684 1,581 $120.700.00 SUM COUNT MEAN MEAN Using AVERAGE() House Age E 29.83333333 29.83333333 -SUMA4:A45) -COUNT(A4 A45) -E4/E5 1253 42 =AVERAGE(A4:A45) Square Feet 71.201 42 1896.261905 1,695 =SUM(B4:845) -COUNT(B4 845) -F4/F5 =AVERAGE B4:846) You need to calculate the following manually without using Excel functions: -Mean house age Varlance of square feet PLEASE HIGHLIGHT the result cells. Make sure you label every column and cell in your work. - Standard deviation of market value Then verify your results using Excel functions AVERAGE, VAR.P and STDEV.P You also need to calculate CVs for all three columns. Market Value G $3,866,900.00 42 $92,069.05 $92,069.05 -SUM(C4:045) -COUNT(C4 C45) -G4/G5 O =AVERAGEIC4:C45) SUM VARIANCE STD DEV H House Age Squared Deviation 35.39774004 I Square Feet Squared Deviation 265.8351551 J Market Vak Squared Deviation 1966 44340 =SQRT(E4) K -SORT(F4)