Hi,
I hope this is in the right part of the forum. I'm working on a problem at the moment where I am measuring an angle across 180 degrees using an inclinometer, however for my application I consider this -90 to 0 to +90.
From working out the mechanical position of my inclinometer, I am going to get an error between my sensor and the true angle reading. However, what i'm struggling with is mathematically finding a sensible way to correct for this error.
See my data below. The "True" column is my known angle, my "Inclinometer" column is the output I am going to get when it is mounted.
I've tried using Excel to plot various equations but cannot get them to work. I'm assuming plotting polynomials etc. are not the right approach for this application.
Can anybody offer suggestions on what to look at? Please note, this isn't homework, thanks!
Thanks,

I hope this is in the right part of the forum. I'm working on a problem at the moment where I am measuring an angle across 180 degrees using an inclinometer, however for my application I consider this -90 to 0 to +90.
From working out the mechanical position of my inclinometer, I am going to get an error between my sensor and the true angle reading. However, what i'm struggling with is mathematically finding a sensible way to correct for this error.
See my data below. The "True" column is my known angle, my "Inclinometer" column is the output I am going to get when it is mounted.
I've tried using Excel to plot various equations but cannot get them to work. I'm assuming plotting polynomials etc. are not the right approach for this application.
Can anybody offer suggestions on what to look at? Please note, this isn't homework, thanks!
Thanks,
