XL: Regression Tool Error If More Than 16 X Ranges

• Microsoft Excel for Windows, versions 4.0, 4.0a, 5.0, 5.0c
• Microsoft Excel for Windows 95, versions 7.0, 7.0a
• Microsoft Excel 97 for Windows
• Microsoft Excel for the Macintosh, versions 4.0, 5.0, 5.0a
• Microsoft Excel 98 Macintosh Edition

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.

REFERENCES

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

Additional query words: toolpack tool pack pak dialog box atp LINEST LOGEST TREND GROWTH 4.00a 5.0 8.00 97 98 XL98 XL97 XL7 XL5 XL4

Keywords          : kbualink97 xladdins 
Version           : WINDOWS:4.0,5.0,5.0c,7.0,97; MACINTOSH:4.0,5.0,5.0a,98
Platform          : MACINTOSH WINDOWS 
Issue type        : kbprb 

Last Reviewed: March 31, 1999