How to calculate the best fit plane?

[afrikan]

Hello.
I have a problem an I am trying to find a solution.
I have a big points cloud and I need to find the best fit plane to obtain all the new coordinates of these points. Afterwards I will be able to continue with the job...
Anyone can help me, please?
I will give an example...
I have these points:

998.6917 1002.2716 9.8657
998.8134 1002.0391 9.8647
998.3142 1002.0231 9.8657
998.476 1001.8167 9.8649
997.9906 1001.7074 9.8658
998.1843 1001.5326 9.8649


and I know that the result will be:


-880544,1656 -1107503,9099 0,7636
-880299,1939 -1107598,0155 -0,3072
-880340,8087 -1107100,2957 0,6163
-880117,1436 -1107237,2410 -0,2390
-880064,4898 -1106742,4810 0,5512
-879868,5394 -1106914,7544 -0,3876

What I want to know is how to get that result.

Thank you very much in advance!

[MrShorty]

I don't fully understand what you are doing, or how you went from the given input array to the given output array.

The usual approach to calculating the "best fit plane" is to use the LINEST() function http://office.microsoft.com/en-us/ex...005209155.aspx to return the coefficients of the equation (y=m1x1+m2x2+b). Once you have the coefficients of the equation, then you can calculate different points on the plane.

If that doesn't help, try explaining in more detail how you go from the input matrix to the output matrix.

[afrikan]

Hello MrShorty, thanks for the link.
The input array has some points coordinates (X,Y,Z). We are talking about a circle in this case.
I have obtained all these points, measuring with no compensator at all (in terms of verticality).
Because of that, I need to find the best fit plane and obtain the new coordinates for all the points (output array).
I have the results as you can see, but I prefer to know how to do the process.

PD: Both arrays are examples, not the complete cloud.

[MrShorty]

I still cannot follow the process you are using to get from the first set to the second set, but it still seems like the basic idea I gave above should still apply -- Use =LINEST() to return the coefficients of the best fit plane, then use those results to perform whatever translation or transformation to get the final results.