(Answered):Excel Functioning 1 . . . .

Question Description

Data obtained from a county auditor in the Excel file Home Market Valueprovide information about the age, square footage, and current marketvalue of houses along one street in a particular subdivision.Considering these data as a population of homeowners on this street,compute the mean, variance, and standard deviation for each of thesevariables using a spreadsheet and formulas (4.1), (4.4), and (4.6). Verify your calculations using the appropriate Excel function.

In the Excel file Facebook Survey,find the average and median hours online/week and number of friends inthe sample using the appropriate Excel functions. Compute the midrangeand compare all measures of location.

Compute