Results 1 to 4 of 4

Thread: Excel Linest() function

  1. #1
    Diamond Member
    Join Date
    Mar 2010
    Location
    Cape Town
    Posts
    6,329
    Thanks
    426
    Thanked 978 Times in 795 Posts

    Excel Linest() function

    Does anybody know how to get the LINEST() function to give the Y intercept of the calculate linear regression. I can get it to give the slope of the line. The help doesn't clarify this very well nor does anything I've found on the net.

  2. #2
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    Hi Adrian,

    I have absolutely no idea what you are talking about, so I cannot help you, but I have always found the Microsoft Office Community site very helpful when I have been stumped with Excel-related challenges.
    Neville Bailey - Sage Pastel Accounting Consultant
    www.accountingsoftwaresupport.co.za
    neville@accountingsoftwaresupport.co.za
    IronTree Online Solutions

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  3. #3
    Diamond Member
    Join Date
    Mar 2010
    Location
    Cape Town
    Posts
    6,329
    Thanks
    426
    Thanked 978 Times in 795 Posts
    I'll take a look, thanks.

  4. #4
    New Member morrisedwards's Avatar
    Join Date
    Apr 2017
    Location
    Singapore
    Posts
    8
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hey ,

    If LINEST() function giving you some errors then maybe because of wrong with the input matrix. Please check the input and it should not be the same.

Similar Threads

  1. Labour law 101: Your internal HR/labour law function: part 2: the training folder
    By Citizen X in forum Labour Relations and Legislation Forum
    Replies: 12
    Last Post: 22-May-12, 08:08 AM
  2. [Question] why does laptop manufacturers swap the function keys with non-vital keys?
    By SilverNodashi in forum Technology Forum
    Replies: 8
    Last Post: 12-Aug-10, 07:37 AM
  3. Thread prefix function added
    By Dave A in forum Administrative issues
    Replies: 1
    Last Post: 09-Apr-08, 10:57 PM

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •