Hi,
I am using FORECAST function in Excel to estimate values using linear interpolation. My input data is as follows
0.04 0.50% 0.08 0.65% 0.25 0.80% 0.50 1.05% 1.00 1.40% 2.00 1.80% 3.00 2.10% 5.00 2.50% 10.00 3.05% 15.00 3.50% 20.00 4.00% 30.00 4.50%
Now I estimate the values at below points
0.50 1.00 1.50 2.00 2.50 3.00
However using FORECAST() function I get below estimates
0.50 1.27% 1.00 1.34% 1.50 1.40% 2.00 1.47% 2.50 1.53% 3.00 1.60%
This looks strange to me. Because, as per the input data, the values corresponding to x = 1 is 1.40%. However FORECAST() function estimates 1.34%. This also differs from corresponding estimates from VBA'a LINTERP() function which gives estimate as 1.40%.
Am I doing any mistake correctly using FORECAST() function?
Any pointer will be very helpful.
Thanks for your time.