Statistics

profileEpic Writer Phd
descriptive_statistics_-1.xlsx

Sheet1

Home Prices in $(X) Home Prices in $(X) (X-232,400)^2 ARRANGED FROM SMALLEST(HOME PICES($))
150,000 6789760000 134,000
165,000 4542760000 150,000
230,000 5760000 165,000
134,000 9682560000 178,000
300,000 4569760000 230,000
325,000 8574760000 245,000
178,000 2959360000 285,000
245,000 158760000 300,000
285,000 2766760000 312,000
312,000 6336160000 325,000
Total 2,324,000 46,386,400,000
Mean= sum of home prices/10 = $2,324,000/10 = $232,400
variance ={(sumof (x-mean of x)^2)/(n-1)}= $46,386,400,000/(10-1)=$5154044444
Standard deviation= sqrt.{(sumof (x-mean of x)^2)/(n-1)}= sqrt(variance)=sqrt($5154044444)= $71791.67392
Mode ; There is no mode
Median ; (11/2)th value = 5.5th value, Median= ($ 230,000+$245000)/2= $237,500
Range= Maximum - Minimum= $325,000 - $134,000 = $191,000