Consulting

Results 1 to 5 of 5

Thread: Linest() <> Chart Trendline Formula

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Tutor MINCUS1308's Avatar
    Joined
    Jun 2014
    Location
    UNDER MY DESK
    Posts
    254

    Linest() <> Chart Trendline Formula

    I have used the index function to look at the first coefficient of a 3rd degree polynomial.
    The data on the graph is the same as what is referenced in the formula.
    The formula returned the value 0.0026 the graph trend line shows 0.0004.

    The function is as follows:
    =INDEX(LINEST((G5:G16)^{1,2,3},,TRUE,FALSE),1)

    What is it that I have done wrong?

    Untitled.jpg
    - I HAVE NO IDEA WHAT I'M DOING

  2. #2
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,844
    A file to play with please…
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

  3. #3
    VBAX Tutor MINCUS1308's Avatar
    Joined
    Jun 2014
    Location
    UNDER MY DESK
    Posts
    254
    Sorry for the delayed response.
    Here is the file: Data2-upload.xlsx
    - I HAVE NO IDEA WHAT I'M DOING

  4. #4
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,844
    try:
    =INDEX(LINEST(G5:G16,ROW($A$1:$A$12)^{1,2,3},TRUE,FALSE),1)
    or:
    =INDEX(LINEST(G5:G16,{1;2;3;4;5;6;7;8;9;10;11;12}^{1,2,3},TRUE,FALSE),1)
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

  5. #5
    VBAX Tutor MINCUS1308's Avatar
    Joined
    Jun 2014
    Location
    UNDER MY DESK
    Posts
    254
    Welp, as with most things excel related - I have no idea why but both of those work flawlessly.
    Thank you p45cal
    - I HAVE NO IDEA WHAT I'M DOING

Posting Permissions

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