Excel最小二乘法計(jì)算一二三維平面度方法總結(jié)

1、序號(hào)中值上公差下公差上限下限樣品1樣品210.5000.0250.0250.5250.4750.5100.53420.5000.0250.0250.5250.4750.5160.5383 J0.500P 0.0250.0250.5250.475P 0.5080.53640.5000.0250.0250.5250.4750.5090.5255 0.500:0.0250.0250.5250.4750.4980.52660.5000.0250.0250.5250.4750.5050.5297 0.5000.0250.0250.5250.4750.5000.51680.500P 0.0250.0250

2、.5250.4750.5040.52490.5000.0250.0250.5250.4750.5400.520100.500:0.0250.0250.5250.475P 0.5120.524110.5000.0250.0250.5250.4750.5080.528120.5000.0250.0250.5250.4750.5120.520130.5000.0250.0250.5250.4750.5070.518140.5000.0250.0250.5250.4750.5040.517150.500P 0.0250.025 :0.5250.4750.5040.527160.5000.0250.02

3、50.5250.4750.5120.51917 n0.500P 0.0250.025 :0.5250.475P 0.5050.516180.5000.0250.0250.5250.4750.5050.512190.5000.0250.0250.5250.4750.5180.515200.5000.0250.0250.5250.4750.5110.514210.5000.0250.0250.5250.4750.5100.51822 0.500P 0.0250.0250.5250.475P 0.5080.512230.5000.0250.0250.5250.4750.5090.51224”0.50

4、0P 0.0250.0250.5250.4750.5240.503250.5000.0250.0250.5250.4750.5280.510260.5000.0250.0250.5250.4750.5270.512270.5000.0250.0250.5250.4750.5320.512280.5000.0250.0250.5250.4750.5250.507290.500P 0.0250.0250.5250.4750.5250.523300.5000.0250.0250.5250.4750.5260.521310.5000.0250.0250.5250.475P 0.5260.530320.

5、5000.0250.0250.5250.4750.5230.509330.5000.0250.0250.5250.4750.5110.522340.500P 0.0250.0250.5250.4750.5180.509350.5000.0250.0250.5250.4750.5000.508360.5000.0250.0250.5250.475P 0.5070.515370.5000.0250.0250.5250.4750.5060.512此處把序號(hào)看成X,二維時(shí)將序號(hào)變?yōu)榱硪痪S平面度改動(dòng)后 0.00000.05000.00000.0500.0000.0470.030肆辛戸一k0.02970.

6、0170殘差最大平面度=殘差最大-殘差最小殘差最小-0.0176-0.0130TLv V*SLOPE 數(shù)斜率b0.00029908-0.0005111y 口丨 ma-INTERCEP函數(shù)常數(shù)系數(shù)a 0.50758616 0.52840295y 口丨 ma-INTERCEP函數(shù)常數(shù)系數(shù)a 0.50758616 0.52840295斜率醫(yī)相關(guān)系數(shù)r=口口j-1r-1r-1垃肉念對(duì)垃勿円山：-1E-JM可決系數(shù)（擁合優(yōu)度）殘差=實(shí)際值-擬合值10.001683170.0056320.008079860.010910643-0.00031710.008710334-0.0001854-0.001122

7、65-0.01092040.000585616-0.00444660.003380787-0.0098613-0.00918968-0.0058046-0.000173590.02966898-0.0039521100.001555320.0009367611-0.00331570.0049377120.00092925-0.002056913-0.0045284-0.003972814-0.0073714-0.004456915-0.00829810.0064649516-0.0003782-0.000786317-0.0081488-0.003585318-0.0080039-0.0076

8、799190.0047382-0.003195820-0.0025056-0.003980121-0.00353160.0001420722-0.0061783-0.005301123-0.0056395-0.0051147240.00971704-0.0129985250.01259064-0.005377260.01123339-0.0032914270.01606359-0.0030905280.00880859-0.0073855290.008593520.00930244300.009150130.00771823310.008923680.01704320.00601104-0.0

9、02631733-0.00651540.01006322345.1408E-05-0.001605935-0.0176358-0.002766536-0.01166150.0053766237-0.01255030.00251507樣品3樣品4樣品5樣品6樣品7樣品8樣品9樣品100.5060.5500.5320.5340.5450.5310.5360.5400.5100.5440.5390.5300.5480.5380.5470.5420.5020.5400.5250.5200.5330.5240.5380.5360.5000.5420.5240.5230.5380.5290.5310.52

10、70.4970.5430.5240.5280.5350.5330.5270.5270.4980.5370.5170.5170.5280.5210.5230.5210.4950.5390.5130.5080.5220.5140.5180.5170.5030.5360.5230.5150.5280.5190.5190.5190.4970.5430.5320.5300.5410.5280.5210.5300.5080.5450.5340.5290.5340.5330.5220.5210.4990.5380.5180.5210.5250.5230.5170.5190.5020.5320.5150.51

11、20.5230.5180.5170.5200.5030.5340.5110.5170.5160.5160.5160.5150.5010.5380.5230.5230.5240.5240.5160.5210.5080.5490.5290.5290.5370.5320.5210.5270.5060.5390.5170.5340.5260.5300.5170.5270.5070.5320.5140.5240.5150.5250.5070.5130.5050.5260.5050.5110.5120.5190.5060.5080.5130.5280.5110.5140.5140.5220.5130.51

12、70.5130.5280.5170.5260.5170.5240.5120.5190.5110.5400.5230.5320.5170.5330.5170.5240.5190.5240.5040.5110.5080.5190.5080.5110.5150.5100.5030.5070.5070.5100.5030.5070.5070.5190.5090.5150.5100.5110.5060.5100.5180.5230.5170.5190.5200.5180.5100.5140.5130.5200.5160.5240.5220.5190.5130.5150.5150.5150.5140.51

13、00.5120.5120.5120.5050.5150.5050.5050.5070.5070.5110.5090.5040.5300.5110.5130.5150.5200.5140.5200.5090.5250.5200.5180.5190.5230.5130.5210.514:0.5320.5310.5330.5340.5370.5220.5300.5230.5100.4990.5100.5080.5090.4990.5000.4950.5250.5060.5130.5090.5160.5030.5190.5110.5170.5020.5180.5070.5050.4970.5150.4

14、980.5090.4930.5060.4940.5000.4870.5070.4950.5220.5010.5060.4940.4980.4880.5180.5020.5160.4990.5060.5010.5010.4880.5170.4990.0250.0330.0340.0390.0380.0330.0340.0280.01380.02070.02170.02290.02730.01730.02060.0178-0.0114-0.0122-0.0123-0.0159-0.0106-0.0156-0.0129-0.01020.0007 -0.0013174-0.0005011-0.0005

15、681-0.0009111-0.0009379-0.0005031-0.00087460.4973 0.55156512 0.52671356 0.52838339 0.53822959 0.53528427 0.52712131 0.53277630.0077-0.00072510.005570560.00575620.00798625-0.00332670.009162060.00762920.011-0.00508860.012974380.002326460.011442890.005026740.020628390.010629930.0022-0.0072431-0.0006185

16、-0.006721-0.0021589-0.00889850.011912790.005365485E-05-0.0042197-0.0004939-0.00273050.00323253-0.00285080.00587937-0.0022611-0.004-0.00149070.000110230.0022950.001375410.002596670.00201904-0.0018752-0.003-0.0066864-0.0065895-0.0080727-0.0043962-0.0091242-0.0008936-0.0060459-0.007-0.0036837-0.009834-

17、0.0159412-0.0098608-0.0145233-0.0059925-0.01012893E-05-0.004873-0.0001815-0.0083697-0.0027938-0.0087207-0.0041136-0.0065816-0.0060.00306450.009969420.006730420.0110440.00121203-0.001170.004666020.00350.006166710.011974790.006477620.005292580.00754249-0.0004645-0.0028599-0.0060.00086428-0.0031731-0.0

18、011867-0.003323-0.002114-0.0043018-0.0043585-0.004-0.0034113-0.0055242-0.0099219-0.0041679-0.006341-0.0037744-0.0027563-0.003-0.0001522-0.0087473-0.0039402-0.0105709-0.0069138-0.0049149-0.0068436-0.0050.004658290.002805540.00283111-0.00110370.0015884-0.00403610.00010350.00050.016895940.010255890.009

19、331260.012634210.01112130.001508260.00695098-0.0020.00843169-0.00150920.015017040.001973430.0101561-0.00233380.0081012-0.0020.00272909-0.00425730.00495284-0.00784190.00539949-0.0115709-0.0048975-0.005-0.0019463-0.0123081-0.0069824-0.01008650.00067283-0.0120435-0.00939490.0030.00191274-0.0065312-0.00

20、31007-0.00708970.00420007-0.00448420.000917790.00280.003023222.1174E-050.0089707-0.00312250.0076021-0.00540510.00366462-7E-040.015961020.006671830.01527075-0.00168410.017334780.000238720.010011920.00710.00114494-0.0113157-0.004904-0.00999870.00461989-0.0077017-0.00242630.0026-0.0112992-0.0120933-0.0

21、083106-0.0101171-0.0038519-0.0129165-0.0061084-0.006-0.0005887-0.00564080.00016089-0.0062499-0.0018498-0.0086377-0.00166080.00360.004448940.002509730.004460970.004488750.00608323-0.00419380.00318656-0.0010.002308260.002286880.010042230.007086920.00821076-0.00133350.00499801-4E-04-0.00069420.00083927

22、-0.003522-0.00162930.00215436-0.0010709-0.0037004-0.001-0.0097698-0.0073117-0.0053573-0.00557440.0016277-0.0039432-0.00459750.0132-0.00236780.000593340.002990330.007773210.006257460.00746130.001977340.00780.008342750.005845870.007461680.011640030.005659610.009240190.007524450.01380.020680410.0216964

23、90.022861860.027278750.015592180.018883980.01777125-0.009-0.0105158-0.0009481-0.002108-0.0003845-0.0065044-0.0107134-0.01021040.0056-0.00231140.00265199-0.00077550.00774344-0.00112560.008473480.00661982-0.003-0.00438980.00844816-0.0020017-0.0024674-0.00637470.00536722-0.0052468-0.011-0.0121862-0.003

24、4167-0.0140882-0.006094-0.0155609-0.0025849-0.00712080.0006-0.0034465-0.0029331-0.0135585-0.0071751-0.01359530.009336180.00081574-0.006-0.0035432-0.0017983-0.0063446-0.003102-0.01298260.00848361-0.0018591樣品11樣品12樣品13樣品14樣品15樣品16樣品170.5120.5450.5190.5320.5150.5190.5130.5200.5390.5210.5400.5170.5270.5

25、140.5130.5280.5110.5330.5170.5170.5000.5100.5320.5070.5300.5110.5160.5050.5070.537:0.5150.5320.5040.5170.5090.5050.5200.5010.5170.5090.5120.4970.5020.5110.5010.5130.5030.5100.4970.5040.518P 0.505 0.5220.505 0.5000.5030.5100.5330.5160.5340.5050.5230.5110.5160.530:0.5260.535:0.5120.5220.5150.5060.5170

26、.5140.5280.5080.5190.5030.5070.5180.5090.5140.5040.5120.5030.5060.5110.5120.5140.5050.5140.5080.5110.5160.5170.5200.5080.5170.5100.5190.530P 0.5250.529P 0.508 0.5260.5190.5150.5240.5340.5300.5140.5240.5240.5100.516P 0.5140.516:0.5130.5150.5130.5100.5020.5140.5120.5090.5150.5070.5070.5130.5220.5140.5

27、160.5170.5140.5150.5170.5200.51610.5150.5210.5170.5210.5250.5350.5260.5100.5300.5240.5110.510P 0.5170.510P 0.5070.5150.5080.5110.5010.5110.5030.5130.5110.5140.5130.512r 0.514:0.509:0.510:0.5180.5150.5140.5140.5250.5150.5120.5190.5180.5190.5190.5210.5130.5140.5190.5240.5110.5060.5160.5060.5160.5130.5

28、190.5130.5050.5090.5040.5200.5150.5180.5240.512r 0.5100.5130.5280.5200.5280.5280.5190.5210.5170.5210.5250.531r 0.5370.5270.5300.529:0.525:0.5330.543”0.5040.504I 0.5070.5060.5000.4990.5200.5170.5050.5090.5080.5230.5150.5260.5130.5050.5030.5030.5150.5090.5220.5070.4930.4970.5000.5000.4990.5180.5130.49

29、90.4960.5020.5190.5070.5150.5110.4970.4980.4990.5100.5020.5150.0340.0360.0370.0350.0280.0370.0320.02210.02030.02130.02170.01400.01890.0213-0.0120-0.0158-0.0154-0.0137-0.0144-0.0178-0.01050.00022247 -0.0008495-0.0001567-0.00079660.00018386 -0.00019450.000598010.00353907 -0.00228620.00051706 0.0026869

30、1-0.0030209 0.008506650.50847187 0.002839760.01114299-0.0049081-0.0084904-0.0065825-0.00036910.00549622-0.0044609 -0.0045143-0.0057766-0.0004691 0.00694464 0.00281963 -0.0023379 -0.0023905 -0.0060531 0.00185518 0.00826815 -0.0020995 -0.0024451 -0.0012376-2.387E-05 0.00521577 -0.0038425 -0.0018955 0.

31、00936852 0.01277596 0.02209005 -0.0119907 0.0011211 -0.0030318 -0.0091442-0.0035483 -0.00536190.532566510.013214050.00806422-0.0075991-0.0157764-0.00805610.007977050.00569388-0.0065409 -0.0042622 -0.010685 -0.0042647 0.01026845 0.00519911 -0.0023355 -0.015557 -0.003680.001540820.01017387 -0.0041451

32、-0.0117006 -0.0004801 0.00265327 0.00842929 -0.0038054 -0.00332690.004390730.011511380.02034461 -0.0009334 0.00016099 0.00128994 -0.0093581 -0.0033325 -0.00398010.517141560.00236703 0.0037483 -0.0055759 -0.0098178 -0.0010754 -0.0154043 -0.0148411 -0.0107162 0.00065904 0.01049365 -0.0015672 -0.005979

33、 -0.0032284 0.00169586 0.00987104 0.01956848 -0.0005923 -0.0001045 0.00734556 0.00617077 0.02134564 0.00346953 -0.0023877 0.00053809 0.01201265 0.0082643 0.0034035 -0.0036079 -0.0028755 0.00825028 0.01802478 -0.0047108 -0.0028394 -0.0087415 -0.0147886 -0.0153134 -0.01306170.532457170.000419150.00879

34、034 0.00270482 0.00065249 0.00331614 -0.0110284 -0.0137424 -0.0045469 0.0084928 0.01051631 0.0038698 -0.009032 -0.0082162 -0.0012207 0.00861884 0.00988556 -0.0025606 -0.0064625 -0.0028465 -0.0007511 0.00978858 -0.0053651 -0.0106897 -0.0044943 0.0024456 0.00106116 -0.0046848 -0.0059867 0.00383654 0.0

35、0873191 0.0216715 -0.0009408 0.00191456 -0.002634 -0.0049189 -0.0022548 -0.00433970.508368980.006793540.00808786 0.00771399 0.00237765 -0.0048823 -0.0009204 -0.006528 -0.0051608 -0.0047402 0.0016855 -0.0028022 -0.0065365 -0.0055161 -0.0027494 -0.0030284 0.00302183 0.0012339 -0.0024004 0.00392003 0.0

36、0248678 -0.0025923 -0.0052321 0.00041872 -0.0027145 -0.0007936 0.00112748 0.00233941 0.00610507 0.01403066 0.00679742 0.01061765 -0.0142875 0.00807413 0.00039312 -0.01437620.003603-0.00556690.51967416-0.0004557 0.00806009 -0.0021392 -0.0028404 -0.0015434 -0.0063561 -0.0081675 -0.0178052 0.00512848 0

37、.00448286 0.00183803 -0.0058353 -0.0030615 -0.000399 0.00893474 0.00713181 -0.0014131 -0.0007865 0.00128737 0.00474987 0.01418349 -6.873E-05 -0.004632 0.00323039 0.00386413 0.00423783 -0.001607 0.00111952 0.0063743 0.01083655 0.01887029-0.0147411 0.00164614 -0.0040212 -0.0139293 -0.0054328 -0.010740

38、80.5032575 殘差0.0091757 0.00982864 -0.0053457 -0.0001691 0.00263021 -0.0102411 -0.0105222 -0.0048526 0.00245671 0.0058324 -0.0070718 -0.0077374 -0.0026225 -0.0014528 0.00705582 0.0112382 -0.000466 -0.007332 -0.0005173 0.00145231 0.00776237 -0.0081191 -0.0027313 -0.0028612 -0.0004517 0.00526665 -0.000

39、1376 -0.0022034 0.0077681 0.00983823 0.02134795 -0.0023333 0.00319462 -0.0012385 -0.0065705 -0.0095184 -0.0103522樣品18樣品19樣品20樣品21樣品22樣品23樣品24P 0.5270.527P 0.543 :0.502P 0.537 :0.5330.5260.5320.5330.5380.5070.5480.5320.5290.5150.5250.5280.5010.5310.5170.5240.5210.5250.5440.5020.5320.5230.5200.5200.52

40、4:0.5320.4990.5350.5220.5210.5120.5150.5260.4960.5300.5200.5130.5050.5100.5440.4930.5180.5090.4990.5110.517P 0.535 0.498P 0.522 0.5130.5070.5190.5200.5420.5020.5400.5300.521P 0.5270.527P 0.5230.509:0.5370.5300.5240.5150.5190.5310.5110.5290.5150.5170.5050.5170.5430.494:0.517:0.5130.5090.5150.5090.540

41、0.5030.5170.5080.5100.5170.5190.5430.5060.5240.5190.517:0.5270.527P 0.541 0.508P 0.537 :0.5310.5260.5280.5210.5340.5150.5350.5320.5200.5150.510P 0.5340.506P 0.520 丁0.5200.5110.5110.5020.5260.5000.5140.5110.5090.5170.506P 0.5180.5120.5120.5180.5110.5200.5130.5210.5090.5210.5300.5180.5260.5200.5320.52

42、30.5270.5350.5250.5060.504P 0.5210.5100.5070.5090.5040.5110.4990.5010.5100.5120.5140.5110.5180.504:0.498:0.506:0.519:0.5190.5150.5190.5110.5090.5150.5290.5330.5170.5190.5090.5080.5140.5290.5230.5270.5160.5020.4950.5110.5140.5190.5180.5140.4940.4900.5150.5110.5130.5070.5200.504P 0.4980.521r 0.519 :0.

43、5180.5190.5320.5060.4970.5290.5240.5240.523r 0.5330.516r 0.513 :0.5360.5400.5450.5360.5080.489I 0.4790.5120.5170.5150.5150.5090.4920.4900.5270.5170.5120.5140.5120.4890.4840.5160.5160.5120.5120.5040.4840.4830.5110.5130.5160.5090.5000.4760.4790.5010.5070.5090.5040.5090.4800.4840.5050.5090.5090.5090.03

44、20.0340.0360.0380.0380.0400.0410.01840.01960.01830.02090.02340.02670.0218-0.0138-0.0141-0.0178-0.0170-0.0144-0.0134-0.0192-0.0002047-0.001114-0.0017880.00053576 -0.0005751-0.0001772-0.000140.52052734 0.53051436 0.55138021 0.4988849 0.53431558 0.52365252 0.51879080.00632205 -0.00201030.01191775 0.005

45、05577-0.0049459 0.00129324 0.0003305 -0.0072355 -0.0137685 -0.0082895 0.00011113 0.00838325 -0.0037082 -0.0127779 -0.0029369 -0.000358 0.00914279 0.01078861 -0.0023031-0.0019001-0.0011122-0.0014391-0.0087732-0.0130852-0.0042154-0.00070780.007898730.00081936-2.147E-05-0.00702730.003942760.013650410.0

46、0820305-0.0018764-0.00617290.000468440.003847240.01004812-0.0095377-0.00447320.002805570.00390647-0.0082173-0.00302310.004446940.01275456-0.0017669-0.0055272-0.00025720.008250430.004249480.00075821 -0.0008116 0.00495846 0.01733712 0.01843861 -0.0054963 -0.0046621-0.0016281-0.0090086-0.0132063-0.0037

47、8680.007543190.00126398 -0.0053766 0.00543115 0.00930111 0.01960864 -0.0057994 -0.0015338-0.0038628-0.0076108-0.0141393-0.0088873-0.0070062 -0.0097014 -0.0178177 -0.0006201 -0.0103818 -0.0147508 0.00477632 -0.0021423 0.00661032 -0.0103174 -0.0011939 0.01290163 0.01150255 0.01618374 0.01643706 0.0114

48、0688 0.01323104 0.00632582 0.00062687 0.00490876 0.01826222 0.00913998 -0.0092375 -0.0108559 0.00249716 0.00269755 -0.0084787 -0.0112835 -0.0012111 -0.0003292 0.01752356 -0.015144 -0.0024131 -0.0069968 -0.0058497 -0.007874 -0.00142640.00274044 0.0075026 0.00077633 0.00126755 -0.0026356 -0.0065029 -0.0097842 -0.0054609 -0.0015245 0.00523516 0.00662705 -0.0115681 -0.0029453 -0.0008219 0.00061445 0.00789285 -0.0021153 -0.0089104 0.0030125