LINEST() function returns error.
 

I am running for the first time a multiple regression analysis. After
selecting the Y's and then at the same time the X's from left to right-two
columns, when I click "okay" I get the message: "Regression - LINEST ()
function returns error. Please check input ranges again." What can I do to
avoid this error?
--
Albert
Vancouver, Canada

LINEST() function returns error.
 

Show us the data (or part of it) and your formula
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Albert" wrote in message
...
I am running for the first time a multiple regression analysis. After
selecting the Y's and then at the same time the X's from left to right-two
columns, when I click "okay" I get the message: "Regression - LINEST ()
function returns error. Please check input ranges again." What can I do to
avoid this error?
--
Albert
Vancouver, Canada