-
On the Logistic Regression dialog box, click OUTPUT.
Logistic Regression > OUTPUT
-
On this screen, select:
- Store the variables table of this analysis in the database — Store the model variables table of this analysis in the database.
- Database Name — Name of the database to create the output table in.
- Output Table Name — Name of the output table.
- Advertise Output — “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 — Specify when the Advertise Output option is selected or when the Always Advertise option is selected on the Connection Properties dialog box. 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 produces the following output table.
Logistic Regression - OUTPUT Column Name B Coefficient Standard Error Wald Statistic T Statistic P-Value Odds Ratio Lower Upper Partial R Standardized Coefficient years_with_bank -0.0981 0.0442 4.9149 -2.2169 0.0269 0.9065 0.8312 0.9886 -0.0530 -0.1447 avg_sv_tran_cnt -1.1920 0.2133 31.2295 -5.5883 3.2252 0.3035 0.1998 0.4611 -0.1680 -0.9144 avg_sv_tran_amt 0.0307 0.0038 64.7038 8.0438 3.5527 1.0312 1.0235 1.0389 0.2460 2.0617 ckacct 0.4656 0.2365 3.8760 1.9687 0.0493 1.5930 1.0020 2.5326 0.0425 0.1273 avg_ck_tran_cnt -0.0227 0.0096 5.6087 -2.3682 0.0181 0.9774 0.9592 0.9960 -0.0590 -0.1791 married -0.6224 0.2333 7.1152 -2.6674 0.0078 0.5366 0.3396 0.8478 -0.0702 -0.1714 (Constant) -1.1864 0.2732 18.8462 -4.3412 1.6144 avg_sv_bal 0.0031 0.0005 31.1686 5.5828 3.3236 1.0031 1.0020 1.0040 0.1678 2.6258 If Database Name is twm_results and Output Table Name is test, the output table is defined as:
CREATE SET TABLE twm_results.test ( "Column Name" VARCHAR(30) CHARACTER SET UNICODE NOT CASESPECIFIC, "B Coefficient" FLOAT, "Standard Error" FLOAT, "Wald Statistic" FLOAT, "T Statistic" FLOAT, "P-Value" FLOAT, "Odds Ratio" FLOAT, "Lower" FLOAT, "Upper" FLOAT, "Partial R" FLOAT, "Standardized Coefficient" FLOAT) UNIQUE PRIMARY INDEX ( "Column Name" );