Actually, there is only one box for the independent variables.
To specify multiple independent variables simply specify the larger
range. For example, if the values for the three indepdendent variables
are in A2:C23, specify that as the range for the 'Input X Range'.
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article ,
says...
Hi,
I need to use linear regression to make a prediction using 3 independet
valuables.
I went to tools-data analysis--and chose "regression" in the pop-up window.
But, after I got a window for regression, I see only two text boxes to
insert independent variables though I uses 3 variables.
Does anybody know how I can get a data analysis tool which is used for more
than 2 independent valuables?