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?

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?

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" <[email protected]> wrote in message
news:[email protected]...
> 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?