+ Reply to Thread
Results 1 to 2 of 2

Trending line Overlapping regression line

  1. #1
    Registered User
    Join Date
    04-26-2019
    Location
    Wichita,Usa
    MS-Off Ver
    2016
    Posts
    1

    Trending line Overlapping regression line

    I'm doing a data reduction project for excel and I need to draw a chart using given data. But the regression line should overlap the trending line.These data has taken from a machine which send out some fault data in the first few seconds and last few seconds when it runs.
    Capture.PNG
    What I needs to do is select the range for a graph neglecting those false data.Is this possible to do using macro?
    Capture2.PNG

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: Trending line Overlapping regression line

    As far as I know, there is no way to have Excel's chart trendline regression ignore a part of a data series. If you want to use the chart trendline feature to perform the regression, you will need some way (by macro or by spreadsheet formula or whatever strategy you like) to remove the false data from the data series.

    I find that I prefer to perform regressions in the spreadsheet using the LINEST() function rather than the chart trendline feature. It might be easier to control what points are included in the regression in the spreadsheet rather than the chart.

    It is difficult to give specific suggestions without knowing how your data are arranged or how you would identify false data. If your data are in a nice list and it is relatively easy to identify the false data, a simple filter might be the easiest way to hide/ignore the false data.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How do I plot a Regression Line on Chart?
    By Jim15 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-04-2017, 06:09 PM
  2. Replies: 6
    Last Post: 09-30-2016, 10:32 AM
  3. line dropping to avoid overlapping
    By tomi_robo in forum Excel General
    Replies: 0
    Last Post: 07-23-2012, 06:31 AM
  4. Estimating a line of regression
    By triads in forum Excel General
    Replies: 6
    Last Post: 04-27-2009, 08:43 AM
  5. weighting a regression line
    By raindancer in forum Excel General
    Replies: 0
    Last Post: 05-14-2008, 03:19 PM
  6. Equation regression line
    By nsv in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-24-2006, 07:26 AM
  7. One regression line
    By Prba in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-24-2006, 12:20 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1