1.1 - 8.10 - Odds Ratio and Confidence Intervals - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)

You can exponentiate the coefficients (the estimate column in the output table coefficient estimates) and interpret them as odds ratios (ORs). To perform this type of computation, you can run the following SQL queries on the output of the GLM function.

-- odds ratios only
SELECT predictor, category,
  EXP(estimate) AS odds_ratio
  FROM glm_output;
-- odds ratios and 95% CI
SELECT predictor, category,
  EXP(estimate) AS odds_ratio,
  EXP(estimate - 1.96 * std_err) AS lower_bound,
  EXP(estimate + 1.96 * std_err) AS upper_bound
FROM glm_output;