Excel Interpolation Function
Double Interpolation Function
MNR - Multivariable nonlinear regression
HTML Table Scraper
Get Your Own Macro
Water Vapor Pressure Function
is a method of constructing new data points within the range of a discrete set of known data points.
The above table includes different values of function Y at discrete values of X. The function Y= 2095.9 at X= 10 and 2726.8 at X= 20. To find the value of Y function at X= 15 which isn't found at the table, we should use interpolation function.
Unfortunately, Excel doesn't include an interpolation function which can be used directly and dragged like average, minimum and maximum functions. But Excel4Engineers.com always has the solution, Excel4Engineers.com provides new function which can be uploaded to Excel as Add Ins.This Excel interpolation function can be used and dragged normally as any Excel function.
You can use either our free or paid interpolation function. Also, we will provide you with help file includes instructions about using and uploading these functions.
The following video indicates how to use this function.