LINEST function returns zeros

[dmad81]

Using Excel 2010, and the fx wizard button, I select the Ys, Xs, True, and True, then CLK OK and the formula =LINEST(J41:J47,I41:I47,TRUE,TRUE) appears in the cell. Then I select a 2 x 5 cell range starting with the formula cell at the upper left of this selected range. Then I press F2, then CTRL+SHIFT+ENTER and the LINEST formula returns a 2 x 5 array of zeros?! See below.
Any help would be appreciated. Thanks!

Known Known
Ys Xs
0 0.39
25 7.50
40 12.00
45 13.50
50 15.00
55 16.50
61 18.00

0.000000 0.000000
0.000000 0.000000
0.000000 0.000000
0.000000 0.000000
0.000000 0.000000

[vandan_tanna]

I couldn't repeat the issue.

When I follow your method, I get Snap2.jpg


is your calculation method set to manual (Excel options --> Formula --> Workbook calculation)?

[dmad81]

No, it was set to Automatic. I set it to Manual, selected a 2 x 5 range of cells, then F2, ctrl+shift+enter and got values this time, but different from yours. See below.


3.428680 -1.173852
0.024920 0.326803
0.999736 0.371522
18931.060157 5.000000
2613.024144 0.690142

[shg]

VT reversed the Y and X values

[vandan_tanna]

ooops.

Thanks for catching that shg.

[dmad81]

Your right. Thanks!