Mõõtetehnika kodutöö 7 (1)

Overview

Sheet1
Sheet2
Sheet3
Sheet4

Sheet 1: Sheet1

Korrastamata algandmete valim
n valim1 n valim2 n valim3 n valim4 n valim5 n valim6 n valim7 n valim8 n valim9 n valim10
37.3 37.18 37.95 37.02 37.57 37.47 37.58 37.72 37.62 37.91
1 37.3 1 37.18 1 37.95 1 37.02 1 37.57 1 37.47 1 37.58 1 37.72 1 37.62 1 37.91
37.52 37.29 37.36 37.46 37.64 37.27 37.12 37.46 37.7 37.18
2 37.52 1 37.29 1 37.36 1 37.46 1 37.64 1 37.27 1 37.12 1 37.46 1 37.7 1 37.18
37.41 37.36 37.18 37.27 37.6 37.75 37.76 37.87 37.64 37.9
1 37.41 1 37.36 2 37.18 1 37.27 1 37.6 1 37.75 1 37.76 1 37.87 1 37.64 1 37.9
37.2 37.67 37.18 37.17 37.69 37.9 37.42 37.91 37.22 37.72
1 37.2 1 37.67 1 37.5 1 37.17 1 37.69 1 37.9 1 37.42 1 37.91 1 37.22 1 37.72
37.95 37.37 37.5 37.58 37.71 37.93 37.82 37.34 37.31 37.78
1 37.95 1 37.37 1 37.59 1 37.58 1 37.71 1 37.93 1 37.82 1 37.34 1 37.31 1 37.78
37.11 37.39 37.59 37.62 37.45 37.38 37.35 37.76 37.19 37.31
1 37.11 1 37.39 1 37.22 1 37.62 1 37.45 1 37.38 1 37.35 1 37.76 1 37.19 1 37.31
37.74 37.85 37.22 47.05 37.39 37 37.38 37.75 37.55 37.79
1 37.74 1 37.85 1 37.39 1 47.05 1 37.39 1 37 1 37.38 1 37.75 1 37.55 1 37.79
37.17 37.43 37.39 37.82 37.44 37.78 37.23 37.78 37.41 37.69
1 37.17 1 37.43 1 37.49 1 37.82 1 37.44 1 37.78 1 37.23 1 37.78 1 37.41 1 37.69
37.36 37.04 37.49 37.53 37.24 37.11 37.66 37.44 37.98 37.83
1 37.36 1 37.04 1 37.98 1 37.53 1 37.24 1 37.11 1 37.66 1 37.44 1 37.98 1 37.83
37.52 37.99 37.98 37.48 37.27 37.59 37.38 37.57 37.15 37.39
1 37.99
1 37.48 1 37.27 1 37.59 1 37.38 1 37.57 1 37.15 1 37.39
x kaetud
10
10
10
10
10
10
10
10
10
10
nixi ni(xi-xikaetud)^2 nixi ni(xi-xikaetud)^2 nixi ni(xi-xikaetud)^2 nixi ni(xi-xikaetud)^2 nixi ni(xi-xikaetud)^2 nixi ni(xi-xikaetud)^2 nixi ni(xi-xikaetud)^2 nixi ni(xi-xikaetud)^2 nixi ni(xi-xikaetud)^2 nixi ni(xi-xikaetud)^2
Valimite vaheline keskväärtuste kaudu
37.3 0.016384 37.18 0.076729 37.95 0.217156 37.02 1.9044 37.57 0.0049 37.47 0.002304 37.58 0.0121 37.72 0. 0036 37.62 0.020449 37.91 0.0676
jrk keskväärtused dispersioon
75.04 0.016928 37.29 0.027889 37.36 0.015376 37.46 0.8836 37.64 0.0196 37.27 0.061504 37.12 0.1225 37.46 0.04 37.7 0.049729 37.18 0.2209
1 37.43 0.03111696
37.41 0.000324 37.36 0.009409 74.36 0.184832 37.27 1.2769 37.6 0.01 37.75 0.053824 37.76 0.0841 37.87 0.0441 37.64 0.026569 37.9 0.0625
2 37.46 0.02172676
37.2 0.051984 37.67 0.045369 37.5 0.000256 37.17 1.5129 37.69 0.0361 37.9 0.145924 37.42 0.0025 37.91 0.0625 37.22 0.066049 37.72 0.0049
3 37.48 0.01449616
37.95 0.272484 37.37 0.007569 37.59 0.011236 37.58 0.6724 37.71 0.0441 37.93 0.169744 37.82 0.1225 37.34 0.1024 37.31 0.027889 37.78 0.0169
4 38.40 0.63297936
37.11 0.101124 37.39 0.004489 37.22 0.069696 37.62 0.6084 37.45 0.0025 37.38 0.019044 37.35 0.0144 37.76 0.01 37.19 0.082369 37.31 0. 1156
5 37.50 0.01089936
37.74 0.097344 37.85 0.154449 37.39 0.008836 47.05 74.8225 37.39 0.0121 37 0.268324 37.38 0.0081 37.75 0.0081 37.55 0.005329 37.79 0.0196
6 37.52 0.00746496
37.17 0.066564 37.43 0.000729 37.49 0.000036 37.82 0.3364 37.44 0.0036 37.78 0.068644 37.23 0.0576 37.78 0.0144 37.41 0.004489 37.69 0.0016
7 37.47 0.01806336
37.36 0.004624 37.04 0.173889 37.98 0.246016 37.53 0.7569 37.24 0.0676 37.11 0.166464 37.66 0.0361 37.44 0.0484 37.98 0.253009 37.83 0.0324
8 37.66 0.00309136
dispersioon
0
37.99 0.284089 0 0 37.48 0.8464 37.27 0.0529 37.59 0.005184 37.38 0.0081 37.57 0.0081 37.15 0.106929 37.39 0.0676
9 37.48 0.01623076 s2=dispersioonihinnang
0.989589
xkaetud ja dispersioon
37.43 0.062776 37.46 0.08 37.48 0.08 38.40 8.36 37.50 0.03 37.52 0.10 37.47 0.05 37.66 0.03 37.48 0.06 37.65 0.06
10 37.65 0.00207936 s2 s
xi ja disp 37.6044 0.07581484 0.0842387111 0.2902390586
(xi-xkaetud)^2
(xi-xkaetud)^2
(xi-xkaetud)^2
(xi-xkaetud)^2
(xi-xkaetud)^2
(xi-xkaetud)^2
(xi-xkaetud)^2
(xi-xkaetud)^2
(xi-xkaetud)^2
(xi-xkaetud)^2
0.0842387111
0.02
0.08
0.22
1.90
0.00
0.00
0.01
0.00
0.02
0.07
0.01
0.03
0.02
0.88
0.02
0.06
0.12
0.04
0.05
0.22
0.00
0.01
0.09
1.28
0.01
0.05
0.08
0.04
0.03
0.06
0.05
0.05
0.00
1.51
0.04
0.15
0.00
0.06
0.07
0.00




0.27
0.01
0.01
0.67
0.04
0.17
0.12
0.10
0.03
0.02
0.10
0.00
0.07
0.61
0.00
0.02
0.01
0.01
0.08
0.12
0.10
0.15
0.01
74.82
0.01
0.27
0.01
0.01
0.01
0.02






0.07
0.00
0.00
0.34
0.00
0.07
0.06
0.01
0.00
0.00
0.00
0.17
0.25
0.76
0.07
0.17
0.04
0.05
0.25
0.03
dispersiooni hinnang
0.07
0.06
0.07
9.20
0.02
0.11
0.05
0.04
0.06
0.06
s
0.26
0.24
0.27
3.03
0.15
0.33
0.23
0.19
0.24
0.25
F 1.2242100708
1.5147184634
1.1469302174
0.0091592135
3.7812887781
0.7932281204
1.6485070668
2.2733085457
1.4147700702
1.398797786
F kriitiline 1.99
hüpotees=0
hüpotees=0
hüpotees=0
hüpotees=0
hüpotees=1
hüpotees=0
hüpotees=0
hüpotees=1
hüpotees=0
hüpotees=0
2. küsi jaotust
h= 0.124
võtsime alpha=0,05 kuna olulisuse nivooks on 0,05
h1= 0.124 1 37
1 37.19
2 37.31
1 37.42
1 37.5
2 37.62
1 37.74
1 37.87
h2= 0.248 1 37.02
1 37.2
1 37.34
1 37.43
2 37.52
2 37.64
2 37.75
2 37.9
h3= 0.371 1 37.04
2 37.22
1 37.35
2 37.44
1 37.53
1 37.66
2 37.76
2 37.91
h4= 0.495 2 37.11
1 37.23
3 37.36
1 37.45
1 37.55
1 37.67
3 37.78
1 37.93
h5= 0.619 1 37.12
1 37.24
1 37.37
2 37.46
2 37.57
2 37.69
1 37.79
2 37.95
h6= 0.743 1 37.15
3 37.27
3 37.38
1 37.47
2 37.58
1 37.7
2 37.82
2 37.98
h7= 0.866 2 37.17
1 37.29
4 37.39
1 37.48
2 37.59
1 37.71
1 37.83
1 37.99
h8= 0.990 4 37.18
1 37.3
2 37.41
1 37.49
1 37.6
2 37.72
1 37.85
1 47.05
13
11
17
10
12
12
13
12
kriitiline väärtus 0.521
0.576
0.49
0.477
0.546
0.546
0.521
0.546
tegelik väärtus 0.2222222222
0.375
0.375
0.4
0.125
0.125
0.3
0.9912568306
võrdlus ei ole ekse
ei ole ekse
ei ole ekse
ei ole ekse
ei ole ekse
ei ole ekse
ei ole ekse
on ekse
ii
47,05 on ekse
Korrastatud rida ekseta
ja dispersiooni analüüs korrastatud reale
pi xi ni*xi pi xi ni*xi pi xi ni*xi pi xi ni*xi pi xi ni*xi pi xi ni*xi pi xi ni*xi pi xi ni*xi
1 37 37 1 37.15 37.15 3 37.27 111.81 3 37.38 112.14 1 37.5 37.5 2 37.62 75.24 2 37.75 75.5 1 37.87 37.87
1 37.02 37.02 2 37.17 74.34 1 37.29 37.29 4 37.39 149.56 2 37.52 75.04 2 37.64 75.28 2 37.76 75.52 2 37.9 75.8
1 37.04 37.04 4 37.18 148.72 1 37.3 37.3 2 37.41 74.82 1 37.53 37.53 1 37.66 37.66 3 37.78 113.34 2 37.91 75.82
2 37.11 74.22 1 37.19 37.19 2 37.31 74.62 1 37.42 37.42 1 37.55 37.55 1 37.67 37.67 1 37.79 37.79 1 37.93 37.93
1 37.12 37.12 1 37.2 37.2 1 37.34 37.34 1 37.43 37.43 2 37.57 75.14 2 37.69 75.38 2 37.82 75.64 2 37.95 75.9
6 keskväärtus 37.0666666667 2 37.22 74.44 1 37.35 37.35 2 37.44 74.88 2 37.58 75.16 1 37.7 37.7 1 37.83 37.83 2 37.98 75.96
1 37.23 37.23 3 37.36 112.08 1 37.45 37.45 2 37.59 75.18 1 37.71 37.71 1 37.85 37.85 1 37.99 37.99
1 37.24 37.24 1 37.37 37.37 2 37.46 74.92 1 37.6 37.6 2 37.72 75.44 12 keskväärtus 37.7891666667 11 keskväärtus 37.9336363636
13 keskväärtus 37.1930769231 13 keskväärtus 37.32 1 37.47 37.47 12 keskväärtus 37.5583333333 1 37.74 37.74
1 37.48 37.48
13 keskväärtus 37.6784615385
VALE
1 37.49 37.49
ni xi dispersioon
19 keskväärtus 37.4242105263
1 37.07 0.184
dispersioonid
1 37.19 0.091
1 2 3 4 5 6 7 8
1 37.32 0.031
0.24546 0.11933 0.05082 0.01333 0.00002 0.01551 0.06480 0.14029
1 37.42 0.005
Kasutan punktis 4
0.22605 0.21183 0.04221 0.01112 0.00060 0.02090 0.06999 0.16367
1 37.56 0.004
keskväärtuse
0.20743 0.39802 0.03820 0.00730 0.00119 0.02708 0.08097 0.17186
1 37.68 0.033
37.50
0.14857 0.09330 0.03439 0.00569 0.00298 0.03047 0.08676 0.18884
1 37.79 0.086
0.14096 0.08729 0.02416 0.00428 0.00556 0.03785 0.10534 0.20662
1 37.93 0.192
Parandatud sandardhälve
0.15174 0.02115 0.00307 0.00715 0.04184 0.11193 0.23479
keskväärtus 8 37.50 0.090 s2
0.261863
0.07046 0.01835 0.00207 0.00894 0.04603 0.12571 0.24459
s 0.299
0.06525 0.01574 0.00126 0.01093 0.05043
0.00065
0.05981
0.00024
0.00003
0.068572 S2
dispersioon 0.161 0.092 0.019 0.003 0.003 0.025 0.054 0.123 0.2618625718 S
4.
tv, ehk laplacei väärtus tabelist
1.984
dispersiooni intervalli hinnang
dispersiooni hinnang s2
Keskväärtuse intervalli hinnang
standardhälbe intervalli hinnang
hii2 0,05 122. 1077 k= 98 0.068572
37.44 väiksem kui 37.50 väiksem kui 37.55
hii2 0,95 76. 1638
alumine 0.0550338327 väiksem kui 0.068572 väiksem kui 0.0882316436 ülemine
standardhälbe intervall hinnang
q= 0.143
Mediaani hinnang
u1 71.7574756452
0.224416224 väiksem kui 0.261863 väiksemkui 0.2993089195
37.48 = keskelementide poolsumma
u2 127.1806354328
saan koefitsendi c väärtuseks kui katseid on 99
c= 1.9845 =tv
parandatud standardhälve
0.2618625718
36.488 väiksem kui 37.480 väiksem kui 38.472
5. Hii kriitiline vabadusaste =5
11.0704976935
s= 0.261863 keskväärtus hinnang 37.50
Vahemikud ni pi xi ui fii(ui) n kaetud (ni-nikatus)^2 /nikatus normdist normsdist
37 - 37,124 6 0.061 37.124 -1.4184692366 0.14588071 6.84 0.103 0.5571 0.0780
37,124 - 37,248 13 0.131 37.248 -0.9449384102 0.25528037 #NAME? #NAME? #NAME? 0.1723
37,248 - 37,371 13 0.131 37.371 -0.4752263809 0.35634405 #NAME? 0.822 #NAME? 0.3173
37,371 - 37,495 19 0.192 37.495 -0.0016955545 0.39894171 #NAME? #NAME? #NAME? 0.4993
37,495 - 37,619 12 0.121 37.619 0.4718352718 0.35691672 #NAME? #NAME? #NAME? 0.6815
37,619 - 37,743 13 0.131 37.743 0.9453660982 0.25517720 #NAME? #NAME? #NAME? 0.8278
37,743 - 37,866 12 0.121 37.866 1.4150781275 0.14658327 #NAME? #NAME? #NAME? 0.9215
37,866 - 37,990 11 0.111 37.990 1.8886089539 0.06704707 #NAME? #NAME? #NAME? 0.9705
99
26
26 suurem kui 11.0704976935 hii kriitiline
7.1
keskväärtus 37.495
Nimimõõde 37
xmin 37.000 7.2
xmax 37.990
ülemine hälve 37.990 7.3 kuna 0,495+0,495 0.99 mm siis saan:
hälbed: -0.4954 valin pluss/ miinus 0.495 alumine hälve 37.000 IT 15 1000 mikromeetrit
0.4946
Detaili piirmõõtmed on:
38.0000 ja 37.0000
8
Mõõtemääramatused
es=0
Ülemine hälve 38
täpsus 0.01 veapiir 0.005
Ure= 0.0028867513
IT 15
Umi 0.0025
Ub= 0.0038188131
ei= - 1,0 alumine hälve 37
Ua 0.0263181787
9
jrk 1 2 3 4 5 6 7 8 9 10
xi -0.693603514 -0.131317138 -0.719177247 0.093841553 -1.492370606 -0.200317381 -0.891510009 -0.942382812 1.028869629 -0.170288086
zi 37.3138152023 37.4610569588 37.3071183988 37.5200175927 37.1046479974 37.4429883777 37.2619908986 37.2486692155 37.7648664493 37.4508519261

Sheet 2: Sheet2

37.3 37.18 37.95 37.02 37.57 37.47 37.58 37.72 37.62 37.91 37.52 37.29 37.36 37.46 37.64 37.27 37.12 37.46 37.7 37.18 37.41 37.36 37.18 37.27 37.6 37.75 37.76 37.87 37.64 37.9 37.2 37.67 37.18 37.17 37.69 37.9 37.42 37.91 37.22 37.72 37.95 37.37 37.5 37.58 37.71 37.93 37.82 37.34 37.31 37.78 37.11 37.39 37.59 37.62 37.45 37.38 37.35 37.76 37.19 37.31 37.74 37.85 37.22
37.39 37 37.38 37.75 37.55 37.79 37.17 37.43 37.39 37.82 37.44 37.78 37.23 37.78 37.41 37.69 37.36 37.04 37.49 37.53 37.24 37.11 37.66 37.44 37.98 37.83 37.52 37.99 37.98 37.48 37.27 37.59 37.38 37.57 37.15 37.39
0.2580123986
47.05

Sheet 3: Sheet3

pi xi ni*xi pi xi ni*xi pi xi ni*xi pi xi ni*xi pi xi ni*xi pi xi ni*xi pi xi ni*xi pi xi ni*xi 1 37 37 1 37.15 37.15 3 37.27 111.81 3 37.38 112.14 1 37.5 37.5 2 37.62 75.24 2 37.75 75.5 1 37.87 37.87 1 37.02 37.02 2 37.17 74.34 1 37.29 37.29 4 37.39 149.56 2 37.52 75.04 2 37.64 75.28 2 37.76 75.52 2 37.9 75.8 1 37.04 37.04 4 37.18 148.72 1 37.3 37.3 2 37.41 74.82 1 37.53 37.53 1 37.66 37.66 3 37.78 113.34 2 37.91 75.82 2 37.11 74.22 1 37.19 37.19 2 37.31 74.62 1 37.42 37.42 1 37.55 37.55 1 37.67 37.67 1 37.79 37.79 1 37.93 37.93 1 37.12 37.12 1 37.2 37.2 1 37.34 37.34 1 37.43 37.43 2 37.57 75.14 2 37.69 75.38 2 37.82 75.64 2 37.95 75.9 6 keskväärtus 37.0666666667 2 37.22 74.44 1 37.35 37.35 2 37.44 74.88 2 37.58 75.16 1 37.7 37.7 1 37.83 37.83 2 37.98 75.96
1 37.23 37.23 3 37.36 112.08 1 37.45 37.45 2 37.59 75.18 1 37.71 37.71 1 37.85 37.85 1 37.99 37.99
1 37.24 37.24 1 37.37 37.37 2 37.46 74.92 1 37.6 37.6 2 37.72 75.44 12 keskväärtus 37.7891666667 11 keskväärtus 37.9336363636
13 keskväärtus 37.1930769231 13 keskväärtus 37.32 1 37.47 37.47 12 keskväärtus 37.5583333333 1 37.74 37.74
0.0540370243
0.0310529502
0.0362284419
1 37.48 37.48
13 keskväärtus 37.6784615385
1 37.49 37.49
19 keskväärtus 37.4242105263
0.0360050502
0.0358568583
0.0390512484
0.0372890894
0.0434796066
0.0391250337
0.0015307683

Sheet 4: Sheet4

Jrk nr 1 2 3 4 5 6 7 8 9 10 1 0.521331787 0.215515137 0.028930664 0.717956543 0.407470703 0.651855469 0.270690918 0.612426758 0.625030518 0.570220947 2 0.921691895 0.879455566 0.513824463 0.165161133 0.151916504 0.634857178 0.568511963 0.230621338 0.463104248 0.427398682 3 0.656555176 0.220245361 0.325378418 0.801452637 0.075286865 0.309844971 0.549835205 0.048126221 0.556671143 0.244293213 4 0.428710938 0.252410889 0.716552734 0.741668701 0.518157959 0.269775391 0.691894531 0.604217529 0.90914917 0.664794922 5 0.328125 0.335601807 0.691894531 0.525695801 0.001281738 0.364501953 0.376403809 0.335357666 0.082519531 0.17980957 6 0.044281006 0.017059326 0.939971924 0.404052734 0.264587402 0.869171143 0.384918213 0.167816162 0.978942871 0.634857178 7 0.966461182 0.268981934 0.31161499 0.444366455 0.392822266 0.351379395 0.491027832 0.420349121 0.213531494 0.780792236 8 0.546112061 0.856323242 0.434448242 0.697174072 0.58505249 0.327606201 0.32421875 0.430297852 0.718231201 0.776062012 9 0.594390869 0.869018555 0.096405029 0.117797852 0.78302002 0.395599365 0.230834961 0.546417236 0.138824463 0.092132568 10 0.110809326 0.594268799 0.288146973 0.91784668 0.849182129 0.90637207 0.209869385 0.913787842 0.892608643 0.935058594 11 0.008911133 0.36630249 0.872772217 0.034515381 0.218902588 0.615966797 0.923736572 0.703125 0.624969482 0.442657471 12 0.179016113 0.993499756 0.060882568 0.526153564 0.25994873 0.102752686 0.086547852 0.045074463 0.825286865 0.081634521 sum 5.306396486 5.868682862 5.280822753 6.093841553 4.507629394 5.799682619 5.108489991 5.057617188 7.028869629 5.829711914 sum-6 -0.693603514 -0.131317138 -0.719177247 0.093841553 -1.492370606 -0.200317381 -0.891510009 -0.942382812 1.028869629 -0.170288086
jrk 1 2 3 4 5 6 7 8 9 10 zi 37.3138152023 37.4610569588 37.3071183988 37.5200175927 37.1046479974 37.4429883777 37.2619908986 37.2486692155 37.7648664493 37.4508519261 Tabel 2