It all depends on what your analysis is trying to answer. That is, what are
the questions????

For example, a "hot market" could mean different things. The first question
that comes to mind when identifying a hot market is "How Long was the
property listed?".

So, to answer this question you will need:

Date listed
Date Sold

Which of course will allow you to compute another column "Days On Market".
With this new data, you should be able to group properties by this analysis
to discover areas within your market that seem to sell quickly.

You could also throw in many other parameters:

Water Front (totally different market within your market)
Listing Price vs. Sale Price (added to length of time listed will give you a
better trend of what it takes to sell)
Proximity analysis (are properties selling because of proximity to certain
features within your market?)

....and the list goes on. It's only limited to what questions you can come
up with.

james

"Bobbi Terry" wrote:

I have gathered the 2007 month by month home sales in our area and have a
separate worksheet for each month sorted by "year built". That said, how do I
analysis what I have? What function can I find to determine what is
selling...Hot market? Thank you so Much in Advance for your help!!