Duplicate Columns in Regression Summary Output Table (178614)
The information in this article applies to:
- Microsoft Excel 97 for Windows
- Microsoft Excel for Windows 95
- Microsoft Excel for Windows 5.0
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q178614 SYMPTOMS
If you use the Regression Data Analysis tool to perform a linear
regression analysis, the output table created by the Regression tool may
contain duplicate columns, as in the following example:
Lower 95% Upper 95% Lower 95.0% Upper 95.0%
5 5 5 5
-1 -1 -1 -1
CAUSE
This behavior is by design of the Regression tool. - The first two columns, Lower 95% and Upper 95%, are always displayed
in the output table. These columns display the Intercept and X
Variable for the lower 95% and upper 95%.
- The last two columns (Lower 95.0% and Upper 95.0%, in this example)
are also always displayed in the output table. These columns display
the Intercept and X Variable for the Confidence Level specified in the
Regression dialog box.
If the Confidence Level check box is not checked, the confidence level
used is 95.0%; if the Confidence Level check box is checked, the value
entered into the edit box is used.
Modification Type: | Minor | Last Reviewed: | 8/17/2005 |
---|
Keywords: | kbprb KB178614 |
---|
|