I was trying to interpolate numbers by using Forecast, but it is not the linear interpolation result I need. I am wondering is there a way to do it. Following is Forecast help example. By using Forecast, the result is 10.6, but if using interpolation, Known Y (7,9) Known X (28,31), the result should be 8.333.
- Known Y KnownX
- 6 20
- 7 28
- 9 31
- 15 38
- 21 40
Formula Description (Result) : =FORECAST(30,A2:A6,B2:B6) Predicts a value for y given an x value of 30 (10.60725). Thank you very much in advance.
Bookmarks