I have large dataset showing homes sold for many years.
I am doing some analysis on the numbers and would like to generate some graphs in Excel that show trends.
What sort of plots reveal good information for home values in the area?
The fields available to me are address, sale date, sale price, year built, and square footage.
I could plot sale price vs sale date to see recent prices, but it only makes sense to look at similar square footage and year built.
Are there any rules of thumbs about how to bound these? For example, if I want to buy a house that’s 1800 square feet and built in 1990….should I compare to houses in the area between 1750 and 1850 square feet built between 1985 and 1990? Or should I open up the search wider?