# Linear Regression - OUTPUT - Teradata Warehouse Miner

## Teradata Warehouse Miner User Guide - Volume 3Analytic Functions

Product
Release Number
5.4.5
Published
February 2018
Language
English (United States)
Last Update
2018-05-04
dita:mapPath
yuy1504291362546.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2302
Product Category
Software
1. On the Linear Regression dialog box, click OUTPUT.
Linear Regression > OUTPUT

2. On this screen, select:
• Store the variables table of this analysis in the database — Check this box to store the model variables table of this analysis in the database.
• Database Name — The name of the database to create the output table in.
• Output Table Name — The name of the output table.
• Advertise Output — The Advertise Output option “advertises” output by inserting information into one or more of the Advertise Output metadata tables according to the type of analysis and the options selected in the analysis.
• Advertise Note — An Advertise Note may be specified if desired when the Advertise Output option is selected or when the Always Advertise option is selected on the Connection Properties dialog. It is a free-form text field of up to 30 characters that may be used to categorize or describe the output.

By way of an example, the tutorial example creates the following output table.

Column Name B Coefficient Standard Error T Statistic P-Value Lower Upper Standard Coefficient Incremental R-Squared SqMultiCorrCoef(1-Tolerance)
nbr_children 0.8994 0.3718 2.4187 0.0158 0.1694 1.6294 0.0331 0.8787 0.1312
years_with_bank 0.2941 0.1441 2.0404 0.0417 0.0111 0.5771 0.0263 0.8794 0.0168
avg_sv_tran_cnt -0.7746 0.2777 -2.7887 0.0054 -1.3198 -0.2293 -0.036 0.8779 0.0207
avg_cc_bal -0.0174 0.0004 -41.3942 0 -0.0182 -0.0166 -0.6382 0.7556 0.3135
ckacct 10.2793 0.8162 12.5947 0 8.677 11.8815 0.1703 0.8732 0.1073
income 0.0005 0 24.5414 0 0.0005 0.0005 0.3777 0.8462 0.311
married -4.3056 0.8039 -5.3558 0 -5.8838 -2.7273 -0.0718 0.8766 0.0933
(Constant) -6.464 0.9749 -6.6301 0 -8.378 -4.55 0 0

If Database Name is twm_results and Output Table Name is test, the output table is defined as:

```CREATE SET TABLE twm_results.test2
(
"Column Name" VARCHAR(30) CHARACTER SET UNICODE NOT CASESPECIFIC,
"B Coefficient" FLOAT,
"Standard Error" FLOAT,
"T Statistic" FLOAT,
"P-Value" FLOAT,
"Lower" FLOAT,
"Upper" FLOAT,
"Standard Coefficient" FLOAT,
"Incremental R-Squared" FLOAT,
"SqMultiCorrCoef(1-Tolerance)" FLOAT)
UNIQUE PRIMARY INDEX ( "Column Name" );```