It returns null values in the specified cell. You can also interpolate the graph using the special ND function. Method 3: Graph interpolation with a function It is relevant if the table on which the graph is based does not specify the corresponding function value for one of the arguments, as in the image below.Īs you can see, the graph has been corrected, and the gap has been removed using interpolation. The interpolation procedure can also be used when plotting a function. Method 2: interpolating a graph using its settings The easiest way to do this is with the operator FORECAST. We need to find the corresponding function for the argument 28 These data are placed in the table below. For example, let's take an array of arguments and their corresponding function values, the ratio of which can be described by a linear equation. Method 1: Interpolation for tabular dataįirst of all, consider the use of interpolation for data that is located in a table. This is the main difference between this procedure and extrapolation. And to find the corresponding value for the argument 30 - no longer. For example, if we have a set of arguments 15, 21 and 29, then when finding a function for argument 25, we can use interpolation. The main condition under which interpolation can be applied is that the desired value must be inside the data array, and not go beyond its limit. Let's take a look at each of these methods. In Excel, this method can be used both for tabular data and for plotting graphs. In mathematics, this is called interpolation. There is a situation when you need to find intermediate results in an array of known values.
0 kommentar(er)
