excel最小二乘法计算平面度工式分析(5点)

所选测量点坐标值

XY514.253.1108.922.1214.1822.413.264.5343.58ZXi^2Yj^2XiYjXiZij

10.019.9810.039.9210.0249.961141.5025501.77560.8736

644.2286

1141.503560.873664.53644.2286560.8736501.772443.58435.076664.5343.58549.96Xi^2XiYjsumxXiZijXiYjYj^2sumyYjZijsumxsumycountxsumz

XYZE19.7516.80.0108E220.356.20.0143E392.3516.80.0007E481.756.20.0019H1-131.17968.8-81.5H10200.28989.8-80.82H11168.61895.1-81.21H12274.05899.2-81.12H13360.171102-79.99

H14366.93932.5-81H15402.011056-80.04H21.061119-81.56

a=-0.001814

b=-0.003097

c=10.042408

0.0032398#REF!

0.01010.01080.00870.00950.01020.00890.0090.00910.00930.00940.00940.00880.00910.00910.00810.00870.00860.0088H3H4H5H6H7H838.3623.812.6483.2295.65229.71060979.7883.9999.9940.51133-81.44-81.56-81.76-81.29-81.43-80.34

0.009YjZij

Zij*

fij

9.989360.0206410.02374-0.043749.9967020.0332989.958362-0.038369.991840.02816435.0766

平面度

0.077034

MMULT(MINVERSE(B11:D13),F11:F13)MMULT(MINVERSE(B11:D13),F11:F13)MMULT(MINVERSE(B11:D13),F11:F13)

0.0136-0.00040.00220.00040.01430.00070.00190.00070.0095-0.00310.00170.00310.0101-0.00030.00140.00030.0106-0.0020.0010.0020.01-0.00250.00150.00250.0096-0.00210.00170.00210.0121-0.0020.00150.0020.01-0.00240.00120.00240.0109-0.00230.0010.00230.0111-0.00180.00070.00180.0113-0.00170.00110.00170.0111-0.00240.00080.00240.0114-0.00260.00120.00260.0107-0.00230.00130.00230.0113-0.0020.00150.0020.0114-0.00210.00150.00210.0112-0.00260.00120.0026xsx0.0112-0.00230.00140.0023y