Re: Newbie question on EQUAL_AREAS and cases

Tech-Archive recommends: Fix windows errors by optimizing your registry

Some more searching on the group gave the answer to the equal_areas
question:

I'll re-post a previous post by Jamie MacLennan:
======================================================

If your data mining model was named MyModel the query would be


SELECT DISTINCT price, RangeMin(price), RangeMax(price) FROM MyModel


This is because the decision tree model does not support prediction of
continuous numbers. When a contrinuous column is selected to be
predicted
is it automatically DISCRETIZED. This means that an algorithm is run
to
break the continuous numbers into a set of distinct ranges, or buckets.
For
example, an Age column may be broken up into buckets like
0-18,19-30,31-45,45-65,65+ depending on the distribution of ages.


The value 129916.5 was returned because it was the midpoint of one of
the
automatically detected ranges. The query above will provide the
midpoint,
min, and max of the ranges for each range the model found.


--
Jamie MacLennan
SQL Server Data Mining

.