excel最小二乘法计算平面度工式分析

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^2

XiYj 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(MI

NVERSE(B

11:D13),

F11:F13)

MMULT(MI

NVERSE(B

11:D13),

F11:F13)

MMULT(MI

NVERSE(B

11:D13),

F11:F13)