Consulting

Results 1 to 5 of 5

Thread: Linest() <> Chart Trendline Formula

  1. #1
    VBAX Tutor MINCUS1308's Avatar
    Joined
    Jun 2014
    Location
    UNDER MY DESK
    Posts
    231

    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 Guru
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    4,008
    A file to play with please…
    p45cal - - - - -This is my signature, it appears after all my posts. Below is not directed at anyone in particular - so don't take offence! - (You might guess why it's there though)
    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
    231
    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 Guru
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    4,008
    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 - - - - -This is my signature, it appears after all my posts. Below is not directed at anyone in particular - so don't take offence! - (You might guess why it's there though)
    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
    231
    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
  •