The Statistical Test metadata tables must be loaded into the database where Analytics Library is installed.
Binomial Test Producing Unpersisted Result Set
Parameters thresholdprobabilty, binomialprobability, singletail, and exactmatches have default values.
call td_analyze ( 'binomialtest', 'database = val_source; tablename = customer_analysis; firstcolumn = avg_sv_bal; secondcolumn = avg_ck_bal; statsdatabase = val_user;' );
Binomial Test Producing Result Table, with groupby Parameter
call td_analyze ( 'binomialtest', 'database = val_source; tablename = customer_analysis; firstcolumn = avg_sv_bal; secondcolumn = avg_ck_bal; groupby = gender; outputdatabase = val_results; outputtablename = binomial_example2; statsdatabase = val_user;' );
Sign Test Producing Unpersisted Result Set
Parameters thresholdprobabilty and singletail have default values.
call td_analyze ( 'binomialtest', 'database = val_source; tablename = customer_analysis; firstcolumn = avg_sv_bal; teststyle = sign; statsdatabase = val_user;' );
Sign Test Producing Producing Result Table, with groupby Parameter
call td_analyze ( 'binomialtest', 'database = val_source; tablename = customer_analysis; firstcolumn = avg_sv_bal; groupby = gender; outputdatabase = val_results; outputtablename = binomial_example4; teststyle = sign; statsdatabase = val_user;' );