Programming Homework Help

Assignment 2: 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.

https://www.sendspace.com/file/qnlrh9Here is the link

Please select just one of the bullet points listed below.

• The different sources mined for descriptive analytics data and their respective benefits.
• Discuss the descriptive statistical measure of your your choice, and its significance in descriptive analytics. (Mention a use case or an Example)
• When do we need to use standardization? Why? (Use Examples)
• Choose a topic from lecture 5 other that the above.