Results 1 to 7 of 7

Thread: Linest (2000)

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

    Linest (2000)

    The attached file calculates heat consumption (Mcf) per customer as a function of heating degree days (HDDs). What I would like to do is print out the Linest information on a separate worksheet, but for some reason I can't seem to get it. Any helpers?
    Thanks.

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

    Re: Linest (2000)

    Have you tried Cut & Paste or Copy & Paste ?

    If that doesn't do what you want, please explain what exactly you want to accomplish.

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

    Re: Linest (2000)

    Thanks for replying Hans.
    What I am trying to accomplish is to print out the various statistics associated with the Linest function, such as b, r-squared, t-factors, degrees of freedom, etc., on a separate spreadsheet.
    Thanks.

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

    Re: Linest (2000)

    But of what? Your RS sheet contains lots of formulas involving LINEST referring to almost one hundred different ranges.

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

    Re: Linest (2000)

    The formula in K150

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

    Re: Linest (2000)

    The formula =LINEST(RS!D$29149,RS!F$29:F149,TRUE,TRUE) entered into A1:B5 on a new sheet as an array formula (confirm with Ctrl+Shift+Enter) will do what you ask.

    See the attached workbook. A1:B5 contains the array formula; D1:E5 explains the meaning of each cell - see the online help on LINEST for more info.

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

    Re: Linest (2000)

    Thanks, Hans. That is exactly what I was looking for. The help section on Linest is very confusing!

Posting Permissions

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