10/17/2005 4:20 AM UTC
Feature request - ESBDB2wayChiSquare
Joe Hendricks
Scenario:
Conducting an online survey (which
at some point probably covers every
shop with a website out there) and
storing the results in a table.
Let's say its an Intraweb app, with one
public page for the survey and an admin-only
page to play with results.
One record per surveyed visitor.
OK, let's say among the questions were
- how likely to buy
('not at all' to 'highly likely' scored 1 to 5)
- satisfaction with BrandX
('not at all' to 'highly satisfied' scored 1 to 5)
(plus many other questions)
OK, 100 surveyed so far, so admin surfs to their analysis
page, and then instruct your component to give a chi square
coefficient on the 2 fields 'likely_to_buy' and 'satisfaction_with_brandX', after entering the split filter
for each field (ie satisfied=3, likely to buy=3, etc required.
your component filters the table twice (or runs 2 sql's),
using the entered criteria for the 4 box cross tab.
satisfied >= 3 | likely >= 3
satisfied < 3 | likely < 3
the component generates the computed square but also compares it against expected, translating the result somehow. admin thought one pattern looked good, but your component shows no correlation...
off the top of my head here...
JoeH