managerial report(Canarsie)

Prepare a managerial report, starting with an executive summary; expected length up to 4 pages APA format, excluding cover page, table of content, and appendixes.

( I attach the data for the zip. If you know how to use the RStudio it is the best. Or you can use the excel.)

My neighborhood is Canarsie.

    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. (you need include the follow points.)

1.    Perform time series analysis on the total dollar amount of residential real estate sales on your neighborhood. Use sales beginning in the year 2009 to develop your model. Develop a forecast for the next 8 quarters of sales.
2.    Use a multiple regression model to come up with another forecast for the next 8 quarters of sales. Include time and seasonality. Use sales beginning in the year 2009 to develop your model.
3.    Use a multiple regression model to determine the sale of a given residential property in your neighborhood. Include:
a.    Sale Date
b.    Year built
c.    Building type (categorical)
d.    Gross Square Feet
e.    Number of Units
4.    According to your model from (3), what are the most and least useful predictors of the amount of a sale?
5.    Are there any redundant independent variables in your model from (3)? How can you tell?
6.    According to your model from (3), which properties were the biggest bargains and which were the most overpriced? How might you account for these disparities?