Newbie question on EQUAL_AREAS and cases

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



I've created a view joining (in essence) customers with sales. I am
then trying to predict sales amount (continuous) by customer attribute
inputs. I selected DISCRETIZED(EQUAL_AREAS,4) for the predicted
variable (sales amount).

What I don't understand is what "value" is telling me in the model. I
can understand the number of cases associated with "node total" under
value, as well as the number of cases associated with "missing".
However, the other values are numbers like "832.125", with an
associated case total of 593. Now to get that case total, the sales
amount had to be between 175 and 1,490. So in short, what the heck are
the actual sales ranges associated with these "equal buckets".

Also, as to the definition of "case", I understand that in my example
the case is a "customer" with a key of customer_id. But in the data
mining model, the number associated with "cases" for the "all" category
is a distinct count of all the input variables and the predicted
variable. So even though I define the case to be customer_id, the data
mining output makes the case count much higher and equal to again, the
distinct count of all the variables in the model.

Thanks.

--Bob Harford
Data Warehousing Architect
AlphaInsight Corp. / Falls Church, VA

.



Relevant Pages

  • Re: [fw-wiz] How to Save The World
    ... _EXACTLY_ that kind of garbage. ... people who don't understand a sales cycle. ... stuff only "convinces" a customer who's already convinced (one way ... by hundreds of list members emailing me, "yeah, I buy stuff from ...
    (Firewall-Wizards)
  • Re: Creating Crosstab Reports from Crosstab Queries
    ... TRANSFORM Sum([Sales By Customer By Product-Summary].UCSAAM) AS Amount ... [Total Sales Amount] ... 1)Total Sales amount for each Customer ...
    (microsoft.public.access.reports)
  • Re: Can I use an old license on a new computer?
    ... I haven't done a lot of computer shopping in a couple years, but I don't recall it ever being suggested in either advertising or face to face interaction with a sales person that I purchase a Gateway because they provide a true oem installation cd with their computer. ... I would think that it would be to gateway's distinct marketing and sales advantage to tout such an important customer satisfaction consideration and to advertise such to anyone that would be within eyesight or earshot. ...
    (microsoft.public.windowsxp.general)
  • Customer Applications Scientist *HPLC*
    ... Western Region Customer Applications Scientist ... The Western Region Customer Applications Scientist will support the ... will demonstrate Eksigent's HPLC systems in the Eksigent laboratory ... Act as the technical expert for the sales team in presenting ...
    (sci.chem.analytical)
  • Re: Auction Terms
    ... I've worked in sales for many years. ... customer feel valued. ... Even today, as a Quality Engineer, I still use sales ... > You think as any reasonable seller Bob, ...
    (rec.collecting.coins)