Prepare a managerial report, starting with an executive summary; expected length up to 3-4 pages APA format, excluding cover page, table of content, and appendixes.
My neighborhood is Canarsie.
1. Provide several descriptive statistics for real estate sales in your neighborhood. Include:
a. The total number of sales in your neighborhood since 2009
b. The mean sale price and gross square footage for residential properties in your neighborhood since 2009
c. A five-number summary for both sale price and gross square footage for residential properties in your neighborhood since 2009
d. The proportion of sales of residential, commercial, mixed, and other properties in your neighborhood since 2009
e. The standard deviation of sale prices for residential properties in your neighborhood since 2009
f. The correlation between sale price and gross square feet for residential properties in your neighborhood since 2009
2. Perform k-means clustering, comparing your neighborhood to other neighborhoods. Choose at least 3 of the following KPIs
a. Median Sale Price for residential properties since 2009
b. Number of sales for residential properties since 2009
c. Standard deviation of sales of residential properties since 2009
d. Proportion of residential sales since 2009
e. Price of 1 gross square foot of residential real estate since 2009
3. Choose one other neighborhood, and test the hypothesis that, starting in 2009, the average residential property costs more, less, or a different amount in your neighborhood (Note: this requires a t-test.)
4. Write 3-4 pages summarizing your findings with a focus on the output, interpretation of the output, and what the insights mean for our decision-making process.