Examples | Parametric Tests | Vantage Analytics Library - Examples - Vantage Analytics Library

The Statistical Test metadata tables must be loaded into the database where Analytics Library is installed.

T-Test Producing Unpersisted Result Set

Parameters teststyle and thresholdprobabilty have default values.

call td_analyze (
  'parametrictest',
  'database = val_source;
   tablename = customer_analysis;
   firstcolumn = avg_cc_bal;
   secondcolumn = avg_sv_bal;
   paired = true;
   equalvariance = true;
   groupby = age, gender;
   statsdatabase = val_user;'
);

One-Way F-Test Producing Unpersisted Result Set

call td_analyze (
  'parametrictest',
  'teststyle = fnway;
   database = val_source;
   tablename = customer;
   columnofinterest = income;
   columns = gender;
   groupby = years_with_bank, nbr_children;
   thresholdprobability = 0.01;
   statsdatabase = val_user;'
);

Two-Way F-Test with Unequal Cell Counts Producing Unpersisted Result Set

call td_analyze (
  'parametrictest',
  'teststyle = f2way;
   database = val_source;
   tablename = customer;
   columnofinterest = income;
   firstcolumn = years_with_bank;
   secondcolumn = marital_status;
   thresholdprobability = 0.05;
   firstcolumnvalues = 0,1,2,3,4,5,6,7;
   secondcolumnvalues = 1,2,3,4;
   statsdatabase = val_user;'
);