I have a non-linear calibration curve that I am trying to deal with. What is the easiest way in Excel 2007 to do this? I am including an example of what I need to do. In the example I have a linear equation - this is what the data needs to correspond to. The nonlinear curve is the calibration curve. (This is only an example, my actual calibration curve has hundereds of points, so please keep that in mind when responding).
Basically, I need something of a curve fit, or look up table. When I use my sensor and get, let's say, I put 10 pounds on the sensor, but I only get a reading of 7. I need that 7 value to translate to 10 - a linear fit so to speak. So how do I take this non-linear calibration curve, and get the data to correspond to what the readings should be (linear) - I need to know if I put 10 pounds on the scale and get 7 as an output, that it is actually 10, not 7. Thanks for any help!
Bookmarks