Array Function LINEST

[Luis Verme]

Hi:
I'm using the function LINEST in a linear regression. It's a 4th grade
equation.
In cells A2:A8 I have the X values 0,1,2,3,4,5,7,8 and in cells E2:E8 the Y
values 1000, 993, 1072, 1405, 2232, 3865, 6688. (this is an example of
Bernard Liengme's book).

I select cells A14:E14 and when I type "=LINEST(E2:E8, A2:A8^{1,2,3,4})" and
then Ctrl+Shift+Enter I get the error #VALUE!.
In A2:A8^{1,2,3,4} I try to raise all values in A2:A8 to the 1,2,3,4 power.

I'm using Excel XP

Any suggestions?

Thanks in advance

Luis Verme

 

[Peo Sjoblom]

Works fine for me...

 

[Ron Rosenfeld]

Hi:
I'm using the function LINEST in a linear regression. It's a 4th grade
equation.
In cells A2:A8 I have the X values 0,1,2,3,4,5,7,8 and in cells E2:E8 the Y
values 1000, 993, 1072, 1405, 2232, 3865, 6688. (this is an example of
Bernard Liengme's book).

I select cells A14:E14 and when I type "=LINEST(E2:E8, A2:A8^{1,2,3,4})" and
then Ctrl+Shift+Enter I get the error #VALUE!.
In A2:A8^{1,2,3,4} I try to raise all values in A2:A8 to the 1,2,3,4 power.

I'm using Excel XP

Any suggestions?

Thanks in advance

Luis Verme

Possibly one of your Y values (in E2:E8) is text.


--ron

 

[Jerry W. Lewis]

It is not clear how you put 8 x-values into 7 cells. Assuming that this
was a misprint, and that =COUNT(A2:A8) and =COUNT(E2:E8) both return 7,
then LINEST should be able to handle this.

Jerry