Xi^2Yj^2XiYj XiZij
H8
H7
H6
H5
sum204.2460.016815720.77641.42348.30.13084 15720.772348.3204.20.13084a=-0.000137 2348.3641.36460.16352b=-0.000264
204.24640.0168c=0.0142431 Xi^2XiYj sumx
XiZij
XiYj Yj^2sumy YjZij0.0001888
sumx sumy countx sumz#REF!
H1-131.17968.8-81.5
H10200.28989.8-80.82
H11168.61895.1-81.21
H12274.05899.2-81.12
H13360.171102-79.99
H14366.93932.5-81
H15402.011056-80.04
H2 1.061119-81.56
H338.361060-81.44
H423.81979.7-81.56
H5 2.64883.9-81.76
H683.22999.9-81.29
H795.65940.5-81.43
H8229.71133-80.34
所选测量点坐标值
YjZij Zij*fij
0.0084670.000233 Array
0.009813-0.00031
-0.00287-0.00023
0.0013870.000313
0.16352
平面度0.000626
MMULT(MINVERSE(B11:D13),F11:F13) MMULT(MINVERSE(B11:D13),F11:F13)
MMULT(MINVERSE(B11:D13),F11:F13)