Regression Tool Error If More Than 16 X Ranges

Retired KB Content Disclaimer

View products that this article applies to.

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:

Back to the top

Excel 5.0, 7.0, Excel 97, and Microsoft Excel 98 Macintosh Edition

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

Back to the top

Excel 4.0 or 4.0a

a #REF! error value in the Regression output

Back to the top

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.

Back to the top

REFERENCES

"Microsoft Excel User's Guide 2," version 4.0, pages 41-45

Back to the top

APPLIES TO

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

Back to the top

kbprb kbualink97 KB94631

Back to the top

Retired KB Content Disclaimer

This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Back to the top