Microsoft KB Archive/214102

= XL2000: Regression Tool Error if There Are More Than 16 X Ranges =

Article ID: 214102

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q214102





SYMPTOMS
In Microsoft Excel 2000, if you attempt to specify more than 16 X ranges, you may receive the following error message

Regression - Input X Range cannot contain more than 16 variables (columns).

or, you receive the #REF! error value in the Regression output.



CAUSE
This behavior occurs because the Regression analysis tool, included in the Analysis ToolPak add-in macro, has an X-range limit of 16.



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.

Additional query words: toolpack tool pack pak dialog box atp LINEST LOGEST TREND GROWTH XL2000

Keywords: kbprb KB214102

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.