Managerial Report

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.
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:
Sale Date
Year built
Building type (categorical)
Gross Square Feet
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?