ConfusionMatrix Output - Teradata Vantage

Machine Learning Engine Analytic Function Reference
Product
Teradata Vantage
Release Number
9.02
9.01
2.0
1.3
Published
February 2022
Language
English (United States)
Last Update
2022-02-10
dita:mapPath
rnn1580259159235.ditamap
dita:ditavalPath
ybt1582220416951.ditaval
dita:id
B700-4003
lifecycle
previous
Product Category
Teradata Vantage™

Output Message Schema

Column Data Type Description
message VARCHAR Reports whether function succeeded and output result to output tables.

CountTable Schema

This table is a confusion matrix (also called a contingency table).

Column Data Type Description
observation VARCHAR Unique value of observed_column in input table.
predicted_class VARCHAR [Column appears once for each specified class.] Number of times that items in observed_column were classified as predicted_class.

StatTable Schema

This table has overall statistics.

Column Data Type Description
key VARCHAR Statistic name from this list:
  • Accuracy
  • 95% CI
  • Null Error Rate
  • P-Value [Acc > NIR]
  • Kappa
  • McNemar Test P-Value

For formulas function uses for Kappa and Null Error Rate, see ConfusionMatrix Output.
value VARCHAR Statistic value.

AccuracyTable Schema

Column Data Type Description
measure VARCHAR Each row contains one of these statistic names:
  • Sensitivity
  • Specificity
  • Pos Pred Value
  • Neg Pred Value
  • Prevalence
  • Detection Rate
  • Detection Prevalence
  • Balanced Accuracy

For formulas function uses for these statistics, see ConfusionMatrix Output.
predicted_class VARCHAR Values of statistics for class.

With Classes syntax element, column appears once for each specified class. Without Classes syntax element, column appears once for each unique observed_column value.