linest function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top