fit a trend line w/o outliers

[David Wang]

Hello,

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

Thanks,
David

 

[Dave Curtis]

Hi David,

Add a helper column which returns either the value or #N/A depending on
whether the value is within or outside of your limits. Add this series to
the chart as well, and add the trendline.

Dave

url:http://www.ureader.com/msg/10295852.aspx