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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

fit a trend line w/o outliers 1
how do I identify statistical outliers with excel? 7
Trend line with negatives Excel 2007 0
Flat Trend Line 2
Closing Chart Line 2
No "Growth Trend" choice on shortcut menu 2
How To: Easy Box Plot 5
Non Linear Scatter plot, need to find y value 3

Top