Results 1 to 4 of 4

Thread: Excel Linest() function

  1. #1
    Diamond Member adrianh's Avatar
    Join Date
    Mar 2010
    Location
    Cape Town
    Posts
    5,089
    Thanks
    336
    Thanked 808 Times in 642 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.
    How easily someone is offended is directly proportional to how stupid they are.
    ~GS Elevator

  2. #2
    Platinum Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Morningside, Durban
    Posts
    2,377
    Thanks
    35
    Thanked 393 Times in 340 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 - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    View Neville Bailey Photography

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

  3. #3
    Diamond Member adrianh's Avatar
    Join Date
    Mar 2010
    Location
    Cape Town
    Posts
    5,089
    Thanks
    336
    Thanked 808 Times in 642 Posts
    I'll take a look, thanks.
    How easily someone is offended is directly proportional to how stupid they are.
    ~GS Elevator

  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 Vanash Naick 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
  •