Excel 2007 - Can I add to a Line of Best Fit

R

RFJ

I've got a scattergraph and developed a line of best fit. (For info, it's a
4 order polynomial.)

What I'd like to do is show additional lines on the chart +/- 20% around the
calculated lobf - basically so I can see what points are outside that range.

Is there a way I can do it. Ideally a generic solution would be the best as
the next lobf could as easily be exponential.

TIA

Rob
 
D

Del Cotter

I've got a scattergraph and developed a line of best fit. (For info, it's a
4 order polynomial.)

What I'd like to do is show additional lines on the chart +/- 20% around the
calculated lobf - basically so I can see what points are outside that range.

You say you "developed" it. Was this actually in the spreadsheet cells,
or just using the trendline chart feature?

If the former, then create a range of cells that references the first
range and multiplies it by 1.2, and another range that does the same,
except multiplying by 0.8.
 
J

Jerry W. Lewis

You can get the polynomial coefficients with LINEST(), or directly calculate
points on the polynomial curve with TREND().

Jerry
 

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

Top