Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. XL2000: Regression Tool Error if There Are More Than 16 X Ranges

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

View products that this article applies to.

This article was previously published under Q214102

↑ Back to the top

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.

↑ Back to the top

Cause

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

↑ 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

Keywords: KB214102, kbprb

↑ Back to the top

Article Info
Article ID : 214102
Revision : 5
Created on : 11/5/2003
Published on : 11/5/2003
Exists online : False
Views : 388