Hey everyone,
I have a list of 3D points (x,y,z) that I need to fit a line to. I've tried fitting three different models, each one using the balance of the columns to predict a since output (so like Y(x,z)) but using the three outputs is not giving me a line. The best I can do is using Y(z) and X(z) and then using the values of z for the final predicted best fit (x,y,z). However, I'm not happy about not having a predicted Z value. I also tried using the row number Z(row#) as a way to predict a z value but this may only work in this instance as z is a movement along a part and thus the variation in it is tied to the variation in the inspection head movement between inspection points.
Using the three OLS models y(z), X(z), Z(row#)
See attached for the data to play along with and thanks for any ideas!!
