6/3/2023 0 Comments Forcasting in excel for macTo interpolate between x- and y-values in a large data set (more than 2 pairs of values), use either XLOOKUP or INDEX and MATCH to extract a pair of x- and y-values to interpolate between. 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.
0 Comments
Leave a Reply. |