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)