![]() ![]() ![]() However, if you need even greater accuracy, you may want to consider a more advanced method such as cubic splines. In most cases linear interpolation in Excel will provide results that are sufficiently accurate. Linear interpolation assumes that the change in y for a given change in x is linear. To 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |