Data manipulation Submit a document where you answer the following questions along with the R script you used. This does not have to be a managerial report.
Import your data into R-Studio.
1. Filter the data to include only residential real estate of your neighborhood. Group it by year, and summarize the data to show the average price of 1 square foot of real estate. List the results.
2. Do numbers show for all years? If a year shows N/A, why is that happening?
3. Filter your data to focus on residential real estate with adequate information for your model (remove fields with 0 for price or square feet)
4. Group the filtered data by year, and summarize the data to show the average price of 1 square foot of real estate. List the results.
5. Compare your selected neighborhood with 2 nearby neighborhoods. List the numbers.
6. Produce a plot that compares the neighborhoods. Explain the plot and the reason you chose that type of plot.