fit a trend line w/o outliers

  • Thread starter Thread starter David Wang
  • Start date Start date
D

David Wang

Hi,

I made a simple scatter plot in Excel and found an outlier. I want to
keep the outlier anyway on the chart while fitting a trend line with
all the data points except the outlier. How should I do it?

Thanks,
David
 
David,

Copy the column of data to another column (or use formulas), delete the outlier point, then fit the
trend line based on the new set of points, but graph the old set.

HTH,
Bernie
MS Excel MVP
 
Back
Top