Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Trending

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    29
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Is there a way to do a best fit line when I have 10 data points that are all over the place??

    if so how

    help

    thanks

    -curator

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Brampton
    Posts
    328
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Use LINEST worksheet function.

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    29
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How do I do that exactly??

    thanks

    -Curator

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    Brampton
    Posts
    328
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Syntax for this function:
    LINEST(known_y's,known_x's)
    Although there are two extra arguments, in your case you can disregard them. Has to be entered as an array formula. Because the array formula will return two results (slope and intercept), select a range of two cells, type the array formula and press CTRL+SHIFT+ENTER.
    Ex. LINEST({1,3,4,4,7},{2,3,4,5,7}) will return m=1.09 and b=-0.79, hence the best fit line:
    y = 1.09 x - 0.79
    If you have ten points, the y's and x's arrays will contain ten elements each.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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