How to Do Nonlinear Interpolation Using Trendline in Excel

When the data is not linear, the first thing we have to do is to find out the function's behavior. Using the Trendline, Excel can fit exponential, logarithmic, and polynomial equations to the data.
In this video, we'll show you how to interpolate nonlinear data; as you can see, we have the corresponding value to the numbers 17 and 19 in our table; now, let's find y when x=18.1.

Subscribe for more Excel tips and tricks.

[michelefantini]

What if trend line equation doesn't match with the trend line that is suppose to rapresent? in some case if u plot a graph based on the quation of the TL you would expect that they should match. unfortunately sometimes they don't match

[happening]

Pl tell how to do non linear extrapolation