spreadsheet and these formulas. Verty your caleulations a populaton of homeowners on this street, compute the mean, variance, and standard deviation for each of the variables using a berien your calculations using the appropriate Excel function Click here lo viow the data. Click here to view the formulas. Idently the number of data values for the house age data. Home Market Value Data The number of data values is (Type a whole number.) Cempute the mean of the house age data. The population mean of the house age data is (Round to two decimal places as needed) Computh the deviation from the mean for the frst house's age of 32 year. The devason trom the thean is (Round to two decimal phaces as needed.) Computn the vaniance of the house age data. The populason variarce of the houte age data is (Round to two decienal places as needed.) Compute the standard deviation of the house age data. The population standard deviation of the house tre data is (Hound to two decimal places as needed) Conquile the mican of the square feet data. The population mean of the square leet data is (Round in fwo decimal places as neesed) Corpquat the deriaton from the neas for the fret house' square footase of 2,123 square feet. The deviason frum the mean is (Pourd 10 tav decimal places as needed.) Compute the variance of the square feet dats The pequlation variance of the spaare teat date is (Hown be tho decienal blaces as neefed. ) Formulas If a population consists of N observations x1,x2,,xN, the population mean is calculated as =Ni=1Nxi. The formula for the variance of a population is 2=Ni=1N(xi)2 where xi is the value of the ith item, N is the number of items in the population, and is the population mean. For a population, the standard deviation is computed as =Ni=1N(xi)2 where xi is the value of the ith item, N is the number of items in the population, and is the population mean