linest function
 

I am attempting to use the linest function on Excel Standard Edition without
success. The formula being used is:
=linest(y-value_range,x-value_range,,true) then Ctrl+Shift+Enter. I believe
that I should get a 2 col by 5 row table with the coefficients of the linear
regression from this. All I am getting is a 2X5 table #Name errors. Does
anyone have a suggestion for solving the problem?

linest function
 

They are #Value errors NOT #Name errors!

"Mitch" wrote:

I am attempting to use the linest function on Excel Standard Edition without
success. The formula being used is:
=linest(y-value_range,x-value_range,,true) then Ctrl+Shift+Enter. I believe
that I should get a 2 col by 5 row table with the coefficients of the linear
regression from this. All I am getting is a 2X5 table #Name errors. Does
anyone have a suggestion for solving the problem?

linest function
 

Sounds like some (or one) value is not numeric.
Use =ISNUMBER() in some blank are of the worksheet to test your x and y
values
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Mitch" wrote in message
...
They are #Value errors NOT #Name errors!

"Mitch" wrote:

I am attempting to use the linest function on Excel Standard Edition
without
success. The formula being used is:
=linest(y-value_range,x-value_range,,true) then Ctrl+Shift+Enter. I
believe
that I should get a 2 col by 5 row table with the coefficients of the
linear
regression from this. All I am getting is a 2X5 table #Name errors.
Does
anyone have a suggestion for solving the problem?