GULF Real Estate Properties-Statistical Report

profilenarranitin9
ProjectTwoSampleWorkbook1.xlsx
Home>Business & Finance homework help>Accounting homework help>GULF Real Estate Properties-Statistical Report

Project two sample

Gulf View Condominiums No Gulf View Condominiums Question 1-5:
List Price Sale Price Days to Sell List Price Sale Price Days to Sell Gulf View Sale Price ($) Gulf View List Price ($) Gulf View Days to Sell
495.0 475.0 130 217.0 217.0 182 Mean Mean Mean
379.0 350.0 71 148.0 135.5 338 Standard Error Standard Error Standard Error
529.0 519.0 85 186.5 179.0 122 Median Median Median
552.5 534.5 95 239.0 230.0 150 Mode Mode Mode
334.9 334.9 119 279.0 267.5 169 Standard Deviation Standard Deviation Standard Deviation
550.0 505.0 92 215.0 214.0 58 Sample Variance Sample Variance Sample Variance
169.9 165.0 197 279.0 259.0 110 Kurtosis Kurtosis Kurtosis
210.0 210.0 56 179.9 176.5 130 Skewness Skewness Skewness
975.0 945.0 73 149.9 144.9 149 Range Range Range
314.0 314.0 126 235.0 230.0 114 Minimum Minimum Minimum
315.0 305.0 88 199.8 192.0 120 Maximum Maximum Maximum
885.0 800.0 282 210.0 195.0 61 Sum Sum Sum
975.0 975.0 100 226.0 212.0 146 Count Count Count
469.0 445.0 56 149.9 146.5 137 Confidence Level(95.0%) Confidence Level(95.0%) Confidence Level(95.0%)
329.0 305.0 49 160.0 160.0 281 Lower Limit Lower Limit Lower Limit
365.0 330.0 48 322.0 292.5 63 Upper Limit Upper Limit Upper Limit
332.0 312.0 88 187.5 179.0 48 95% CI Gulf View Sale Price 95% CI Gulf View List Price 95% CI Gulf View Days to Sell
520.0 495.0 161 247.0 227.0 52
425.0 405.0 149
675.0 669.0 142 No Gulf View Sale Price ($) No Gulf View Sale Price ($) No Gulf View Days to Sell
409.0 400.0 28 Mean Mean Mean
649.0 649.0 29 Standard Error Standard Error Standard Error
319.0 305.0 140 Median Median Median
425.0 410.0 85 Mode Mode Mode
359.0 340.0 107 Standard Deviation Standard Deviation Standard Deviation
469.0 449.0 72 Sample Variance Sample Variance Sample Variance
895.0 875.0 129 Kurtosis Kurtosis Kurtosis
439.0 430.0 160 Skewness Skewness Skewness
435.0 400.0 206 Range Range Range
235.0 227.0 91 Minimum Minimum Minimum
638.0 618.0 100 Maximum Maximum Maximum
629.0 600.0 97 Sum Sum Sum
329.0 309.0 114 Count Count Count
595.0 555.0 45 Confidence Level(95.0%) Confidence Level(95.0%) Confidence Level(95.0%)
339.0 315.0 150 Lower Limit Lower Limit Lower Limit
215.0 200.0 48 Upper Limit Upper Limit Upper Limit
395.0 375.0 135 95% CI No Gulf View Sale Price 95% CI No Gulf View Sale Price 95% CI Np Gulf View Days to Sell
449.0 425.0 53
499.0 465.0 86 Question #6
439.0 428.5 158 Sample Sizes (Gulf View Selling Price) Sample Sizes (No Gulf View Selling Price)
Z (95% CI): 1.96 Z (95% CI): 1.96 Sample size n:
E 40 E 15
σ 192.5178 σ From the output above n= (z*σ/E)^2
n 89 n Your Answer!
Question #7
Estimation
Sample data show: Gulf view
Gulf view Estimated Selling Price and Number of Days
Sales price (Average) $454.22 List Price 589000
List Price (Average) $474.01 Selling Price 564415
Percetage Below List Price (Average) 4.17% Number of days 106
Sample data show: Estimation
No Gulf view No Gulf view
Sales price (Average) From the output above Estimated Selling Price and Number of Days
List Price (Average) From the output above List Price 285000
Percetage Below List Price (Average) ERROR:#VALUE! Selling Price ERROR:#VALUE!
Number of days