Examples | Kolmogorov-Smirnov Tests | Vantage Analytics Library - Examples - Vantage Analytics Library

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

Kolmogorov-Smirnov Test with groupby Parameter

call td_analyze (
  'kstest',
  'database = val_source;
   tablename = customer_analysis;
   columnofinterest = income;
   teststyle = ks;
   groupby = years_with_bank;
   statsdatabase = val_user;'
);

Lilliefors Test with groupby Parameter

call td_analyze (
  'kstest',
  'database = val_source;
   tablename = customer_analysis;
   columnofinterest = income;
   teststyle = l;
   groupby = years_with_bank;
   statsdatabase = val_user;'
);

Shapiro-Wilk Test with groupby Parameter

call td_analyze (
  'kstest',
  'database = val_source;
   tablename = customer_analysis;
   columnofinterest = income;
   teststyle = sw;
   groupby = years_with_bank;
   statsdatabase = val_user;'
);

D'Agostino and Pearson Test with groupby Parameter

call td_analyze (
  'kstest',
  'database = val_source;
   tablename = customer_analysis;
   columnofinterest = income;
   teststyle = p;
   groupby = years_with_bank;
   statsdatabase = val_user;'
);

Smirnov Test with groupby Parameter

call td_analyze (
  'kstest',
  'database = val_source;
   tablename = customer_analysis;
   columnofinterest = income;
   teststyle = s;
   groupby = years_with_bank;
   statsdatabase = val_user;
   columns = gender;'
);

Kolmogorov-Smirnov Test with Output Table and No groupby Parameter

call td_analyze (
  'kstest',
  'database = val_source;
   tablename = customer_analysis;
   columnofinterest = income;
   teststyle = ks;
   statsdatabase = val_user;
   outputdatabase = val_results;
   outputtablename = ks_out1;'
);