Overview
Sheet1
ül4
ül5
ül6 ja 7
ül 8
ül 9
ül11
ül 11
ül10
Sheet 1: Sheet1
46.2
46.2
Keskväärtus 46.2
ül4 0.44343
ül4, osa 2
99
Dispersioon 867.9166666667
intervalli nr vahemik elemente tõenäosus intervalli keskmine
0.82243
k Xm ui ni φ(ui) pi ni' (ni-ni')^2/ni' 32
Mediaan 38
1 0-20 5 0.2 6.8
1 20 -0.88934148 5 0.2296 0.2296 5.74 0.0954006969 10
Haare 99
2 20-40 6 0.24 30.33
2 40 -0.210454854 6 0.4404 0.2108 5.27 0.1011195446 96
t-statistik -0.6449422946
3 40-60 6 0.24 47.17
3 60 0.4684317719 6 0.67 0.2296 5.74 0.0117770035 2
μ 50
4 60-80 5 0.2 73.4
4 80 1.1473183978 5 0.8485 0.1785 4.4625 0.0647408964 79
5 80-100 3 0.12 96.33
5 100 1.8262050238 3 0.9484 0.0999 2.4975 0.1011036036 46
1.7108820799
25 1
Kokku
25
23.71 0.3741417449 31
29.4604254325
68
46
47
0.4780363352
28
0.4168338365
F(t) fii(t) chi-
square 75
2.0638985616
0.1869097926 0.22868 0.0035969145
29
36.4150285018
0.4166563419 0.2297465493 0.0004576054
32
13.8484250272
0.6802620741 0.2636057322 0.0021138789
7
S2 867.9166666667
0.8743749735 0.1941128994 0.0001785453
47
s 29.4604254325
0.9660903075 0.091715334 0.0087228852
75
0.0150698292
15
0
53
2
94
7
42
10
0
15
30
28
70
29
48
30
31
dispersiooni hinnang: 866.41
32
32
42
46
47
47
48
53
68
70
75
75
79
94
96
99
Sheet 2: ül4
Ül 4.1
k Xm ui ni φ(ui) pi ni' (ni-ni')^2/ni'
1 20 -0.88934148 5 0.1867 0.1867 4.6675 0.0236863953
2 40 -0.210454854 6 0.4168 0.2301 5.7525 0.010648631
3 60 0.4684317719 6 0.6808 0.264 6.6 0.0545454545
4 80 1.1473183978 5 0.9306 0.2498 6.245 0.248202562
5 100 1.8262050238 3 0.9664 0.0358 0.895 4.9508659218
Kokku
25
24.16 5.2879489647
χ²=5,288
χ²kr (0,10;2) = 4.605
k Xm ni F0(m) pi ni' (ni-ni')^2/ni'
ül 4.2
1 20 5 0.3559635789 0.3559635789 8.8990894729 1.7083656439
2 40 6 0.5852170883 0.2292535094 5.731337735 0.012593816
3 60 6 0.732864698 0.1476476097 3.6911902429 1.4441419011
4 80 5 0.8279551362 0.0950904381 2.3772609536 2.8935654268
5 100 3 0.8891968416 0.0612417055 1.5310426365 1.4093897089
k Xm ni F0 pi ni' (ni-ni')^2/ni' 7.4680564966
1 20 5 0.2 0.2 5 0
2 40 6 0.4 0.2 5 0.2
k Xm ni F0(m) pi ni' (ni-ni')^2/ni'
3 60 6 0.6 0.2 5 0.2
1 20 5 0.356 0.356 8.899 1.708
4 80 5 0.8 0.2 5 0
2 40 6 0.585 0.229 5.731 0.013
5 100 3 1 0.2 5 0.8
3 60 6 0.733 0.148 3.691 1.444
kokku 25 25 1.2 4 80 5 0.828 0.095 2.377 2.894
5 100 3 0.889 0.061 1.531 1.468
χ²=1,2
kokku
22.229 7.527
1
Sheet 3: ül5
ül 5 Vahemik Xm ni(emp) ni(norm) ni(ühtl) f(norm) f(ühtl) f(exp)
0
0.0039594837 0.01 0.022 46.2 keskväärtus
0-20 20 5 5 5 0.0091186266 0.01 0.0141688013 29.46 standardhälve
20-40 40 6 6 5 0.013245233 0.01 0.0091252241
40-60 60 6 7 5 0.0121347007 0.01 0.0058769766
60-80 80 5 6 5 0.0070119342 0.01 0.003784987
80-100 100 3 1 5 0.0025555589 0.01 0.0024376695
kokku
25 25 25
k Xm ui ni φ(ui) pi ni' (ni-ni')^2/ni'
1 20 -0.7077444884 9 0.
2389 0.2389 5.9725 1.5346598995
2 40 -0.1424533635 4 0.4443 0.2054 5.135 0.2508714703
3 60 0.4228377614 2 0.6628 0.2185 5.4625 2.1947654462
4 80 0.9881288864 5 0.8389 0.
1761 4.4025 0.0810917093
5 100 1.5534200113 5 0.9406 0.1017 2.5425 2.3753416912
Kokku
25
23.515 6.4367302166
Sheet 4: ül6 ja 7
empiiriline ühtlane
ül 7
ül 6
0 1 0 0.04 0
0.04 0.04 0 0.04
100 2 2 0.08 0.02
0.06 0.06 -0.02 0.08
3 7 0.12 0.07
0.05 0.05 -0.01 0.06
4 10 0.16 0.1
0.06 0.06 -0.02 0.08
5 15 0.2 0.15
0.05 0.05 -0.01 0.06
6 28 0.24 0.28
0.04 0.04 0.08 0.04
7 29 0.28 0.29
0.01 0.01 0.05 0.04
8 30 0.32 0.3
0.02 0.02 0.02 0
9 31 0.36 0.31
0.05 0.05 -0.01 0.06
10 32 0.4 0.32
0.08 0.08 -0.04 0.12
11 32 0.44 0.32
0.12 0.12 -0.08 0.2
12 42 0.48 0.42
0.06 0.06 -0.02 0.08
13 46 0.52 0.46
0.06 0.06 -0.02 0.08
14 47 0.56 0.47
0.09 0.09 -0.05 0.14
15 47 0.6 0.47
0.13 0.13 -0.09 0.22
16 48 0.64 0.48
0.16 0.16 -0.12 0.28
17 53 0.68 0.53
0.15 0.15 -0.11 0.26
18 68 0.72 0.68
0.04 0.04 0 0.04
19 70 0.76 0.7
0.06 0.06 -0.02 0.08
20 75 0.8 0.75
0.05 0.05 -0.01 0.06
21 75 0.84 0.75
0.09 0.09 -0.05 0.14
22 79 0.88 0.79
0.09 0.09 -0.05 0.14
23 94 0.92 0.94
0.02 0.02 0.06 0.04
24 96 0.96 0.96
0 0 0.04 0.04
25 99 1 0.99
0.01 0.01 0.03 0.02
Sheet 5: ül 8
Column1 1 2 3 4 5 Rühma kesk Rühma disp (yi-y̅)^2
1.-5. 99 32 10 96 2 50.5 4704.5 18.49
6.-10. 79 46 31 68 47 63 512 282.24
11.-15. 28 75 29 32 7 17.5 220.5 823.69
16.-20. 47 75 15 53 94 70.5 1104.5 590.49
21.-25. 42 0 30 70 48 45 18 1.44
246.5 6559.5 1716.35
1311.9
429.0875
F=
Fkr= 0.3270733288
2.9
Sheet 6: ül 9
ül 9
Lähterida Märgirida Käänupunktid Järjestatud rida
99 +
0
32 - k 2
10 -
7
96 + k 10
2 - k 15
79 + k 28
46
k 29
31 -
30
68 + k 31
47 +
32
Lmax=3 Ns= 15
28 - k 32
Lmax 3.3
4.4299948467
75 + k 42
3.3
29 - k
xmed=46 8.2
32 -
47
6.6
7 -
47
8.2
47 + k 48
11.4
75 +
53
15 - k 68
53 + k 70
94 +
75
42 - k 75
0 -
79
30 -
94
70 + k 96
48 +
99
Sheet 7: ül11
ül 9
ül 9.1 ül 9.3
xi yi
(xi-x̅)^2
b0 -3.0871571615
4.3 4.6
1.4884
2.8 0.7
0.0784
b1 2.0282977797
2.2 0.4
0.7744
ül 9.4
4.9 8.8
3.3124
d 2
1.2 1.3
3.5344
keskmine 3.08 3.16 kokku 9.188
s²ad 4.4042141924
-3.0871571615
F 2.1208094025
F kr 3.6 4.76
ül 9.2
r
s²(b0) 2.5594442026
3.6
s²(b1) 0.2260194457
5.6
∆b1 3.9147749656
4.8
∆b0 1.1633405653
ül 9.5
3.2 b0 usaldusvahem. -5.6466013641 ≤ β0 ≤ -1.9238165962 = 0.95
4.3 b1 usaldusvahem. -1.8864771859 ≤ β1 ≤ 5.9430727453 = 0.95
Punktis x=1
7.1
s(y) 1.180
6.4
∆y 2.888
y̅0 5
s²(y) 2.0766666667
P 2.23 ≤ μ(yI1) ≤ 8.01 = 0.95
Punktis x=3
s(y) 0.646
∆y 1.580
0 1.60 3.96
P 7.60 ≤ μ(yI3) ≤ 10.76 = 0.95
-1 2.04 5.00
Punktis x=5
s(y) 1.117
∆y 2.734
P 10.51 ≤ μ(yI5) ≤ 15.97 = 0.95
ül 9.6
-1 0 1 3 5
1 3 5 9 13
2 8 11
8 11 16
Sheet 8: ül 11
ül10
xi yi (xi-x̅)^2 3.1 12.1 0.
0036 4.9 23.9 3.4596
4.2 16.8 1.3456
1.9 9.2 1.2996
1.1 7.8 3.7636
3.04 13.96 9.872
keskmine keskmine Kokku
Sheet 9: ül10
i Xi Yi Xi-Xkesk Yi-Ykesk (Xi-Xkesk)2 (Yi-Ykesk)2 (Xi-Xkesk)*(Yi-Ykesk) XiYi
1 4.3 4.6 7.38 1.44 54.46 2.07 112.94 19.78
2 2.8 0.7 5.88 -2.46 34.57 6.05 209.23 1.96
3 2.2 0.4 5.28 -2.76 27.88 7.62 212.37 0.88
4 4.9 8.8 7.98 5.64 63.68 31.81 2025.65 43.12
5 1.2 1.3 4.28 -1.86 18.32 3.46 63.37 1.56
Summa 15.4 15.8 0 0 198.92 51.01 30.802 129.01
Keskmine 3.08 3.16
Vx=198,92 Vy=51,01
18.636
r= 0.86
10.6272
d= 0.74
-14.4648
100.73 0.19
-14.5728
2.93
45.0072
1.83
-7.9608
t=r*√(N-2)/(1-rˆ2)=0,86*√(5-2)/(1-0,74)=˃Tp=˃H1
* z-statistik (Zp=1,6449)
z=0,5*(√(N-3))*ln((1+r)/(1-r))=0,5*(√(5-3))*ln((1+0,93)/(1-0,93))=2,35˃Zp=˃H1
Kõik kommentaarid