Fitting a line through 3D points

[#1]

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!!

[#2]

Cool!  Any chance you could show the steps you did to make that graph?

[#3]

1. Stacked the Predicted Z and the Different Predicted Z columns using the    Tables=>Stacked   platform
2. Opened  the 3D Scatterplot platform
3. Selected the X, Y and  Data columns as the Y Columns
4. Selected the Label column as the Color Column
5. Clicked on OK

[#4]

AH, thanks JIM!!