Home excel Interpolating data points in Excel

Interpolating data points in Excel




Hello everyone!

There is a table with the starting points (X and Y), according to which we build the graph.

Then we take samples, and get only the Y value

It is necessary to calculate the values ​​of X on the original graph for the new values ​​of Y. Please tell me how this can be done? Thanks

Answer 1

And if the graph is plotted on the contrary, along the x-axis – mV, along the y-axis -%. Then we get the dependence% (mV), we can show the equation (for example, I took a polynomial trend, degree 4) and substituting the mV you need into this equation to get%

This is if you copy the interpolation equation. If you need it completely automatically, then you can do the same through the search for a solution (but the add-in “search for a solution” must be enabled and determine the interpolation formula)

Programmers, Start Your Engines!

Why spend time searching for the correct question and then entering your answer when you can find it in a second? That's what CompuTicket is all about! Here you'll find thousands of questions and answers from hundreds of computer languages.

Recent questions