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!!

Sort ascending by months on market?

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!!

May want to combine your separate sheets into one big data area something
like this:
A B C
Month Year Blt Price

Then you can use a pivot table to look at it different ways. There is a
pivot wizard that asks what range your data is in, and asks you to layout the
resulting pivot table (suggest making a new sheet each time so you can go
back and try again). Takes a little practice to get the best results but
could be set to show you charts, counts, sales totals according to whatever
criteria you want. Hope this helps.

"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!!

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!!