Formula Help on Interpolation
So, I've searched and searched through what seems to be thousands of threads on here and the net, with little understanding of what it is that I have to enter or do to Interpolate... So I'm a very, and I mean very basic user of excel, so breaking a response down would be great!! Heck pictures would be the absolute best lol, but not asking for that.... just a little guidance. So,
What I'm trying to do is select values within my cells that I have pasted into excel from information collected from a vehicle to calibrate the Mass Airflow Sensor *MAF*. This information has to be not only smooth, but interpolation would create a great linear graph rather than me using the calculator on my phone anymore to figure it out... which is fine if my goal is out of this world.
So an example would be if i want to interpolate the numbers from H2 to M2 what would I use as a formula to do so, and put those values into the cells H2 through M2, maybe have the numbers change color so i notice a change as well? I apologize if this seems like a really hard request, it does to me lol.
Instructions/Examples/Modification to my document would be highly appreciated.... I figure if i can do it on paper with my cell, and excel document should be able to one up me. Oh I'm using Windows 7 Premium, Microsoft Excel 2007, and a HP G72 laptop if that makes any difference.
|