Results 1 to 4 of 4

Thread: Linest (2000)

  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Linest (2000)

    Can someone point me to where I might find how to get the properties of the Linest function? For example, R-squared, adjusted R-squared, etc.
    Thanks.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Linest (2000)

    Is analysis toolpack required in later editons for Linest? It is not required in XL97...

    Steve

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Linest (2000)

    No, you're correct. I was confused because I had trouble finding LINEST in the online help for Excel 2002. I will correct my reply.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Linest (2000)

    Edited by HansV to correct mistake - thanks to Steve for pointing it out!

    1. Press the function wizard button (fx)
    2. Locate and select the LINEST function (in All or in Statistical)
    3. Press F1

Posting Permissions

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