Extrapolation refers to predicting values that sit outside of the provided data range, given the assumption that the trend between points continues as it did inside the range. The mathematical expression for Linear Extrapolation is given below. How to Extrapolate Data in Excel: 5 Handy Ways We ...
On the other hand, the TREND function is an array formula to figure out how many y values go with how many x values. Forecast Sheet only works when you have a constant difference between known values. Extrapolation isn’t very reliable because we can’t be sure that the trend of the ...