Interpolation in Excel
You are given the X, Y Coordinates of 2 points, (99.5,39.5) and (201.1,45.7) and asked to find the Y coordinate of an intermediate point with an X coordinate of 115.7. How will you solve this problem? The answer is Interpolation! Interpolation is the method of estimating ‘unknown values’ that fall between ‘known values’. In this…