I keep getting: #NAME?

[Pezgordo]

I am trying to copy a coefficient formula from a book into an Excel spreadsheet. The coefficient is: y= a + bx

Below I placed the x column into column A in my Excel spreadsheet and column y into column B in my Excel spreadsheet, rows 1-10

x y
2 7
1 10
0 -3
0 6
-1 5
4 15
3 12
-2 -7
-1 -2
-1 3

In C1 I typed the follwoing formula (per the book):

=linst(b1:b10,a1:a10,true,tru)

It is supposed to return 3.04, but I keep getting #NAME?

Any ideas what I am doing wrong?

 

[Jonmo1]

First guess is that tru is a typo in the book.
It should probably be true

 

[Pezgordo]

First guess is that tru is a typo in the book.
It should probably be true

I suspected that and tried "true", but still got the same response: #NAME?

 

[dave3009]

Is it the other typo

=LINEST(B1:B10,A1:A10,TRUE,TRUE)

 

[Pezgordo]

Thanks guys, you both were right, they both were typos.

=LINEST(B1:B10,A1:A10,TRUE,TRUE)

This is correct.

Thank you again.