fit a trend line w/o outliers

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
 
B

Bernie Deitrick

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
 
Top