![]() Previous |
![]() Next |
The INFO (REGRESS) function obtains information produced by an REGRESS statement and stored internally by Oracle OLAP. Through the use of keywords, INFO lets you extract specific pieces of information about the regression you have calculated.
Note: Before using INFO, familiarize yourself with REGRESS.REPORT that produces a standard report of its results, which might give you all the information you need. INFO is useful primarily for creating customized reports or for performing further analysis on the results |
Return Value
The return value depends on the keyword you use, as described in Table: INFO REGRESS Keywords.
Syntax
INFO(REGRESS choice [index])
Parameters
Indicates that you want to obtain information produced by an REGRESS statement.
The specific information you want. The choices available for REGRESS are listed in Table: INFO REGRESS Keywords. Choices marked as indexed require the index argument.
An INTEGER expression that specifies which result you want for a choice that can have several different results. For example, in a regression there may be multiple independent variables. You would use index to specify which independent variable you want information about. When you omit index for a choice that requires it, an error occurs.
INFO REGRESS Keywords
Keyword | Type | Indexed? | Meaning |
---|---|---|---|
AVAILABLE |
BOOL |
No |
Is there a computed regression from which to extract information? |
DEPENDENT |
TEXT |
No |
The name of the dependent variable in the regression. |
NOINTERCEPT |
BOOL |
No |
Was the regression calculated with the intercept suppressed? |
WEIGHTED |
BOOL |
No |
Was the last regression weighted? |
WEIGHT |
TEXT |
No |
The expression used to weight the last regression. |
NUMCOEFS |
INT |
No |
The number of coefficients. |
INDEPENDENT |
TEXT |
Yes |
An independent variable; index specifies which one you want (Intercept to be first unless it was suppressed). |
COEFFICIENT |
DEC |
Yes |
An estimated coefficient; index specifies which one you want. |
STDERROR |
DEC |
Yes |
The standard error of an estimated coefficient; index specifies which one you want. |
TRATIO |
DEC |
Yes |
The t-ratio for an estimated coefficient; index specifies which one you want. |
NUMOBS |
INT |
No |
The number of observations that were used. |
FRATIO |
DEC |
No |
The F-ratio for the regression. |
RBSQ |
DEC |
No |
The corrected R-squared for the regression. |
FORMULA |
TEXT |
No |
The regression formula. |
STDERROREST |
DEC |
No |
The standard error of estimate for the regression |
RESET |
BOOL |
|
Use when you want to reset the original state of AVAILABLE back to |
Usage Notes
Determining Regression Results Availability
When you try to extract information without having performed a regression, INFO produces an error. You can use the keyword AVAILABLE to determine whether any results are currently available. Once a successful regression has run, AVAILABLE remains true even when one or more unsuccessful regressions follow, because the results of the previous successful regression are still available. AVAILABLE remains true until you use RESET to change the AVAILABLE state back to its original value of NO
.
NA Results Due to Index
INFO returns NA
when you use an index that is out of range. For example, when your regression has five independent variables and you request the coefficient of the twelfth one, INFO returns NA
.
Examples