• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. T

    Straight Line Through Most Common Points

    Thanks Luke, that works well. A small thing, I believe you had a typo in the formula, should be row 3 that's referred to, not row 4. Montrey, the problem with going straight to a trend line is that it includes all points, even the extreme ones. For my use I needed a trend line that reflected...
  2. T

    Straight Line Through Most Common Points

    Is there a Formula that given a number of points Excel will plot a straight line where the majority of points fit or nearly fit the line, i.e. excludes the extreme points. Example: X: 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 Y: 93, 82, 80, 81, 68, 79, 78, 90, 77, 68 The straight line would be drawn...
Back
Top