This week we will also start our 2nd project (Project two under the Project? tab), making a managerial report about Gulf Real Estate Properties. Gulf Real Estate Properties, Inc.,
This week we will also start our 2nd project (Project two under the “Project” tab), making a managerial report about Gulf Real Estate Properties. Gulf Real Estate Properties, Inc., is a real estate firm located in southwest Florida. The company monitors condominium sales by collecting data on location, list price, sale price, and number of days it takes to sell each unit. The sample data provided recent sales for 40 Gulf View condominiums and 18 No Gulf View condominiums. We will discuss any specific statistical results that would help a real estate agent understand the condominium market.
Your paper should be thorough and concise! It should be at least 2-3 pages in length. You may only include some statistical result tables, no charts necessary in this report. Please remember to put your written report title and your name on your cover page and page numbers on each page of your paper. .Please attach your Excel workbook along with your paper. ( Both the paper report and Excel File should be submitted)
Please find the attached File:
1)GULFprop-Use this file for DATA
2)Project two sample work book-Use this file for the format, All the RED font are my notes and Yellow highlight are the cells with the formula.
3)Project 2 Instructions-Please follow the same instructions
4)Statistical Paper report: Samples how to write Statistical Report
5)Video shared by Professor how to write this assignment-Please use this video its very important
https://drive.google.com/file/d/1QTBXArxUtASojdiPUHf-BarmY7DE1HMa/view?usp=sharing
Data
| Gulf View Condominiums | No Gulf View Condominiums | ||||
| List Price | Sale Price | Days to Sell | List Price | Sale Price | Days to Sell |
| 495.0 | 475.0 | 130 | 217.0 | 217.0 | 182 |
| 379.0 | 350.0 | 71 | 148.0 | 135.5 | 338 |
| 529.0 | 519.0 | 85 | 186.5 | 179.0 | 122 |
| 552.5 | 534.5 | 95 | 239.0 | 230.0 | 150 |
| 334.9 | 334.9 | 119 | 279.0 | 267.5 | 169 |
| 550.0 | 505.0 | 92 | 215.0 | 214.0 | 58 |
| 169.9 | 165.0 | 197 | 279.0 | 259.0 | 110 |
| 210.0 | 210.0 | 56 | 179.9 | 176.5 | 130 |
| 975.0 | 945.0 | 73 | 149.9 | 144.9 | 149 |
| 314.0 | 314.0 | 126 | 235.0 | 230.0 | 114 |
| 315.0 | 305.0 | 88 | 199.8 | 192.0 | 120 |
| 885.0 | 800.0 | 282 | 210.0 | 195.0 | 61 |
| 975.0 | 975.0 | 100 | 226.0 | 212.0 | 146 |
| 469.0 | 445.0 | 56 | 149.9 | 146.5 | 137 |
| 329.0 | 305.0 | 49 | 160.0 | 160.0 | 281 |
| 365.0 | 330.0 | 48 | 322.0 | 292.5 | 63 |
| 332.0 | 312.0 | 88 | 187.5 | 179.0 | 48 |
| 520.0 | 495.0 | 161 | 247.0 | 227.0 | 52 |
| 425.0 | 405.0 | 149 | |||
| 675.0 | 669.0 | 142 | |||
| 409.0 | 400.0 | 28 | |||
| 649.0 | 649.0 | 29 | |||
| 319.0 | 305.0 | 140 | |||
| 425.0 | 410.0 | 85 | |||
| 359.0 | 340.0 | 107 | |||
| 469.0 | 449.0 | 72 | |||
| 895.0 | 875.0 | 129 | |||
| 439.0 | 430.0 | 160 | |||
| 435.0 | 400.0 | 206 | |||
| 235.0 | 227.0 | 91 | |||
| 638.0 | 618.0 | 100 | |||
| 629.0 | 600.0 | 97 | |||
| 329.0 | 309.0 | 114 | |||
| 595.0 | 555.0 | 45 | |||
| 339.0 | 315.0 | 150 | |||
| 215.0 | 200.0 | 48 | |||
| 395.0 | 375.0 | 135 | |||
| 449.0 | 425.0 | 53 | |||
| 499.0 | 465.0 | 86 | |||
| 439.0 | 428.5 | 158 |
,
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 |
