linest function

M

Mitch

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?
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Linest function for polynomial regression on horizontal range 0
linest use in vba 1
multiple polynomial regression in Excel 4
LINEST containing selection 0
Linest 0
UDF Challenge for Curve Fit Function 3
using linest excel function from msaccess with multidimensional ar 4
Running LinEst() from VBA 1

Top