Oracle® OLAP DML Reference 10g Release 1 (10.1) Part Number B10339-02 |
|
|
View PDF |
The REGRESS.REPORT
program produces a standard report of a regression performed using the REGRESS command.
Syntax
REGRESS.REPORT
Examples
Example 20-10 Report for a Simple Regression
Assume that you have performed the simple regression illustrated in Example 20-8, "Simple Regression" . You can now execute REGRESS.REPORT to see the results of the regression.
Regression Analysis =================== Dependent Variable: SALES WEIGHTBY Variable: NONE Regressor Coefficient Std. Error T-ratio -------------------- ------------ ------------ -------- ADVERTISING 0.36 0.16 2.24 PRICE -8.66 1.80 -4.82 EXPENSE 1.05 0.01 79.69 Corrected R-square 1.00 F-Statistic (2, 141) NA Number of observations 144 Standard error of estimate 1,477.16
Example 20-11 Report for a Weighted Regression
Assume that you have performed the simple regression illustrated in Example 20-9, "Weighted Regression" . You can now execute REGRESS.REPORT to see the results of the regression.
Regression Analysis =================== Dependent Variable: SALES WEIGHTBY Variable: RELIABILITY Regressor Coefficient Std. Error T-ratio -------------------- ------------ ------------ -------- ADVERTISING 0.44 0.17 2.64 PRICE -8.03 1.92 -4.19 EXPENSE 1.04 0.01 76.45 Corrected R-square 1.00 F-Statistic (2, 141) NA Number of observations 144 Standard error of estimate 1,373.15