Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit

MET AD 571 Assignment 2

Data Manipulation

7 points

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

1. Import your data into R-Studio via BU Server or provided CSV Files for PC.

2. Use R Studio to compute the average price of 1 square foot of residential real estate in your neighborhood for each year.

3. Filter your data to focus on residential real estate with adequate information for your model (remove fields with 0 and other unrealistic values for SALE_PRICE or GROSS_SQUARE_FEET).

4. Use R Studio to compute the average price of 1 square foot of residential real estate in your neighborhood for each year for the filtered data.

5. Compare your selected neighborhood with nearby neighborhoods.

6. Write 1-2 pages summarizing your findings. For example, what has happened to the price per square foot in your neighborhood?