LINEST Function Returning Only One Value (Q99639)

[Tad Travis]

Trying to produce a multiple regression equation with 2
independent variables.
LINEST function reads:
LINEST(C2:C11,A2:B11,TRUE,TRUE), where x1,x2=A2:B11 and
y=C2:C11.
Excel only returns one slope, the slope for x2. The slope
for x1 is not returned, nor are the additional statistics.

I've searched online help and found the explanation
referenced in the subject line of this message. MS's
workaround is not appropriate for this problem. I tried
to create an array solution area for the LINEST, as
recommended, but only produced an array of #VALUE! errors.

Any thoughts or suggestions? Thanks

[Conrad Carlberg]

Hi Tad,

If you are doing the following, you're doing it properly:

1. Select an empty range of cells, three columns by five rows.
2. Type this:
=LINEST(C2:C11,A2:B11,TRUE,TRUE)
and hold down Ctrl and Shift as you press Enter, to array-enter the formula.

If you're doing that and you still get #VALUE!, then there's probably a
problem with your underlying data -- one or more text values, for example.

C^2
Conrad Carlberg
"Tad Travis" <tadtr...@yahoo.com> wrote in message
news:228701c1c9ec$875983e0$36ef2ecf@tkmsftngxa12...

[Tad Travis]

Conrad,
Many thanks, it worked. Got the y-intercept and second
slope like I wanted. Following the MS directions, I had
originally produced a 20x5 array. Thanks for the
clarification.
Tad

>.
>

[Tad Travis]

Conrad,
Many thanks, it worked. Got the y-intercept and second
slope like I wanted. Following the MS directions, I had
originally produced a 20x5 array. Thanks for the
clarification.
Tad
>-----Original Message-----

>.
>

[Tad Travis]

Conrad,
Many thanks, it worked. Got the y-intercept and second
slope like I wanted. Following the MS directions, I had
originally produced a 20x5 array. Thanks for the
clarification.
Tad
>-----Original Message-----

>.
>