Microsoft KB Archive/94631

= Regression Tool Error If More Than 16 X Ranges =

Article ID: 94631

Article Last Modified on 8/15/2005

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 95 Standard Edition
 * Microsoft Excel 5.0 Standard Edition
 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q94631





SYMPTOMS
In Microsoft Excel, the Regression analysis tool, included in the Analysis ToolPak add-in macro, has an X-range limit of 16. If you attempt to specify more than 16 X ranges, you will receive one of the following errors:

Excel 5.0, 7.0, Excel 97, and Microsoft Excel 98 Macintosh Edition
Regression - Input X Range cannot contain more than 16 variables (columns).

Excel 4.0 or 4.0a
a #REF! error value in the Regression output



MORE INFORMATION
The Regression analysis tool uses the LINEST function to perform linear regression calculations. Because LINEST has an X-range limit of 16, the Regression analysis tool has the same limitation.

