![]() ![]() ![]() The first parameter, NewX is simply the value to interpolate. Its syntax is: FORECAST( NewX, known_y_pair, known_x_pair). In more detail, the FORECAST function performs the actual interpolation using the linear interpolation equation shown above. two calls to the OFFSET function to reference the tabulated x-values and y-values just above and just below the new-x value.two calls to the MATCH function to find the tabulated x-value closest too, but less than the new-x value, and.the FORECAST function to calculate the linear interpolation,.In brief, the equation consists of 3 parts: =FORECAST( NewX,OFFSET( KnownY,MATCH( NewX, KnownX,1)-1,0,2), OFFSET( KnownX,MATCH( NewX, KnownX,1)-1,0,2)) The simple implementation is easiest to understand by dissecting from the outside and working in.
0 Comments
Leave a Reply. |