Question: Create a macro to carry out linear interpolation using the formula y = y 1 + y 2 - y 1 x 2 - x
Create a macro to carry out linear interpolation using the formula
Use relative addressing. Give the macro a name, a shortcut key, and a description. This macro should be able to be used on various sets of values, at various locations on your worksheet, without changing the coding in the of the macro itself.
Try your macro out with the following set of data, solving for :
tablex
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
