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?