3) Calculate the variance and the standard deviation for the housing price data

Question

3) Calculate the variance and the standard deviation for the housing price data for each of the towns assuming that the data are from a population.

Arlington 120000 Cambridge 209000 Medford 180000 Arlington 247500 Cambridge 246000 Medford 235000 Arlington 69500 Cambridge 265000 Medford 200000 Arlington 288000 Cambridge 200000 Medford 160000 Arlington 320000 Cambridge 280000 Medford 99500 Arlington 270000 Cambridge 164000 Medford 152000 Arlington 338000 Cambridge 215000 Medford 251000 Arlington 234000 Cambrdige 222000 Medford 270000 Arlington 390000 Cambridge 306000 Medford 272000 Arlington 248000 Cambridge 235000 Medford 245000 Arlington 301000 Cambridge 170000 Medford 79000 Arlington 275000 Cambridge 110000 Medford 315000 Arlingotn 995000 Cambridge 260000 Medford 200000 Arlington 310000 Cambridge 250000 Medford 230000 Arlington 275000 Cambridge 320000 Medford 209000 Cambridge 215000 Medford 127000 Cambridge 191000 Cambridge 448000 Cambridge 1325000 Cambridge 455000 Cambridge 1410000 Cambridge 167000 Cambridge 445000 Cambridge 440000

Explanation / Answer

The calculation is quite difficult to show here.So i am displaying the results.Values have been calculated in Excel

Arlington

Mean=312066.67

Variance=39235095555.56

Standard Deviation=198078.50

Cambridge

Mean=356166.67

Variance=101947888888.89

std dev=319292.795

Medford

Mean=201531.25

Variance=4029858398.43

std dev=63481.17

Related Questions

Navigate

• Browse (All)
• Browse 3
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.