However, when the number of x-values and y-values is greater than 2, the result of the FORECAST function will NOT be an interpolated y-value. When there are only two data points, the result of linear regression is the same as linear interpolation. ![]() The FORECAST function works by using linear regression to estimate the value of y that corresponds to the input value x. There isn’t a linear interpolation function in Excel, but the FORECAST function can be used for linear interpolation when there are just two pairs of x- and y-values. ![]() If there are more than 2 pairs, the calculation is more complex. This simple method works when there are only two pairs of x- and y-values. In the example below, the formula to interpolate and find the y-value that corresponds to an x-value of 1.4 is: To perform linear interpolation in Excel, use the FORECAST function to interpolate between two pairs of x- and y-values directly.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |