Equation of smoothed line between points

M

MMesarch

HI,
I know I can add a trend line and get the equation for it. But the data I
have does not really fit the trendline types offered.
When I just add a line between the points and it is in SMOOTHED mode, is
there any way to get that equations. Or at least to find values on that line
between existing data points. And I realize I could linearly interpolate
between those point, but I would rather have the smoothed line.
THanks for the help.
 
J

Jon Peltier

You realize that the smoothing is not rigorously defined to track the data?
That the smoothed line can extend where the data may never go? It's only
there to beautify the chart.

But if you understand all that and want the smoothed line anyway, you could
read what Brian Murphy has learned about the smoothing, which basically is a
series of bezier curves fitted to the points. His remarks are found about
3/4 of the way down this page:

http://www.xlrotor.com/resources/files.shtml

- Jon
 

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

Area chart with smoothed line 2
equation for smoothed XY Scatter line 2
Calculating or estimating the area between to curves 2
coordinates of a point 3
Different Starting Points on X-Axis 4
Filling in the gaps - smoothing the curve 3
using polynomial trendline equations 2
Excel graphed trendline does not match derived equation 5

Top