MET AD571 Business Analytics Foundations
Assignment 2
商业分析基础代写 Task1:Filter the data to include only residential real estate of your neighborhood. Group it by year and summarize the data to show the average
Task1:
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.
Task2:
Do numbers show for all years? If a year shows N/A, why is that happening?
Task3”
Filter your data to focus on residential real estate with adequate information for your model (remove fields with 0 for price or square feet)
Task4:
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.
Task5:
Compare your selected neighborhood with 2 nearby neighborhoods. List the numbers.
Task6:
Produce a plot that compares the neighborhoods. Explain the plot and the reason you chose that type of plot.
Table of Content 商业分析基础代写
Question1……………………………………………………………………………4
Question2 and Question3…………………………………………………………5
Question4 ………………………………………………………………………….6
Question5 ………………………………………………………………………….7
Question6 ………………………………………………………………………8-9
Question1
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.
As the exist of Not available and infinite data, we cannot get a specific average price.
Question2 商业分析基础代写
Do numbers show for all years? If a year shows N/A, why is that happening?
Answer After run the sum code, there exist 99 Not Available data in years, there serval reasons:
- The year is not recorded.
- The sell has no idea about the built year.
- The data on that missed.
- The recorder did not record it as usual
Question3
Filter your data to focus on residential real estate with adequate information for your model (remove fields with 0 for price or square feet)
Question4 商业分析基础代写
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.
Question 5
Compare your selected neighborhood with 2 nearby neighborhoods. List the numbers.
Question 6 商业分析基础代写
Produce a plot that compares the neighborhoods. Explain the plot and the reason you chose that type of plot.
In this problem, I use a scatter plot to compare the average price of Neighborhood 228 and Neighborhood 229. The reason why I choose this type because it is easy to checkthe price interval in the same year, also it is easy to check if some of these data contains unreasonable data. From this plot, blue represents 229 and red represents 288. In all, the prices of both neighborhoods are on the fluctuant rise, start from almost 160. Overall, we can see that the average price of 229 is a little bit higher than 228 between 2 decades. In 2006, the price of 228 suddenly came to almost 600, which is the highest price of neighborhood 228. In 2010, the price of 229 reached an unreasonable peak at almost 1550. Also, the price of 229 between 2012 and 2013, rose to 600 which is triple times that other years.
