Title | Gulf+Real+Estate+Properties |
---|---|
Course | Data Analysis For Managers |
Institution | Florida Atlantic University |
Pages | 3 |
File Size | 113.2 KB |
File Type | |
Total Downloads | 13 |
Total Views | 149 |
Case study...
1. Descriptive statistics to summarize each of the three variables for the forty Gulf View condominiums List Price
Sales Price
Days to Sell
Mean Standard Error Median Mode Standard Deviation
474007.5 31194.293 437000 975000
Mean Standard Error Median Mode Standard 197290.03 Deviation
454222.5 30439.72954 417500 305000
Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count Confidence Level(95.0%)
3.892E+10 1.0113289 1.0958146 805100 169900 975000 18960300 40
37063085378 1.183621479 1.159387914 810000 165000 975000 18168900 40
63096.412
Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count Confidence Level(95.0%)
192517.7534
61570.16398
Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count Confidence Level(95.0%)
106 8.256078 96 85 52.21602 2726.513 2.022026 1.077642 254 28 282 4240 40 16.69949
2. Descriptive statistics to summarize each of the three variables for the eighteen No-Gulf View condominiums
List Price Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count Confidence Level(95.0%)
Sales Price 212805.6 11536.51 212500 279000 48945.28 2.4E+09 -0.08524 0.543955 174000 148000 322000 3830500 18 24339.92
Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count Confidence Level(95.0%)
Days to Sell 203188.9 10345.38 203500 179000 43891.72 1.93E+09 -0.46407 0.304181 157000 135500 292500 3657400 18 21826.84
Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count Confidence Level(95.0%)
135 17.98402 126 #N/A 76.29972 5821.647 2.215301 1.360547 290 48 338 2430 18 37.94296
3. Comparisons The mean sale price of gulf view condominiums is greater than that of non gulf view condominiums. The mean number of days to sell gulf view condominiums is less tha that of non gulf view condominiums. The variation in the sale prices of gulf view condominiums are more than that of non gulf view condominiums. The variation in the number of days to sell of gulf view condominiums are more than that of non gulf view condominiums.
4. GULF VIEW CONDOMINIUMS 95% confidence interval for population mean sales price is 45422.50±61570.16 =(392652.34,515792.66) 95% confidence interval for population mean days to sell is 106±16.70 =(89.30,122.70)
5. NON GULF VIEW CONDOMINIUMS
95% confidence interval for population mean sales price is 203188.90±21826.84 = (181362.05,225015.73) 95% confidence interval for population mean days to sell is 135±37.94 = (97.06,172.94)
6. GULF VIEW CONDOMINIUMS Confidence level = 95% z= 1.96 s=192517.75 E=Z*s/√n = 40000 n = (1.96*192517.75/40000)^2 = 88.99 The minimum sample size is 90
GULF VIEW CONDOMINIUMS Confidence level = 95% z= 1.96 s=43891.72 E=Z*s/√n = 15000 n = (1.96*43891.72/15000)^2 = 32.89 The minimum sample size is 33...