Rakendusstatistika arvutusgraafiline AGT (0)

Overview

Sheet1
Sheet2
ul6
ul8
ul9
osa b
10ul

Sheet 1: Sheet1

OSA A
Tabel1
Xi ni ni*xi ni*(xi)2 ni(xi-Xk)2
9
37 1 37 1369 263.74
15
54 3 162 26244 1.73
18
intervalli nr vahemik elemente tõenäosus intervalli keskmine
94 2 188 35344 3322.76
19
1 0-20 4 0.16 15.25
4.1
4.2
32 1 32 1024.00 2809.00
30
2 20-40 4 0.16 33
Intervall ni
Xm ui uiФ pi
Intervall pi ni n’i X^2 Fo 19 1 19 361 1172.38
32
3 40-60 8 0.32 48.63
m ni' (ni-ni')^2/ni'
0.7485 4 18.7125
33 1 33 1089 409.66
33
4 60-80 2 0.08 65.5
0-20 4 0.16 0.00 -2.00 0.11 0.11 2.64 0.7006
69 1 69 4761 248.38
37
5 80-100 7 0.28 88.29
20-40 4 0.16 20.00 -1.20 0.31 0.21 5.1625 0.2618
51 1 51 2601 5.02
41
25
40-60 8 0.32 40.00 -0.57 0.60 0.29 7.165 0.0973
0-20 0.2 89 1 89 7921 1278 .78
43
60-80 2 0.08 60.00 0.05 0.84 0.24 6.065 2.7245
20-40 0.5118 4 12.795 0.4 43 2 86 7396 209.72
43
80-100 7 0.28 80.00 0.67 0.96 0.12 2.9875 5.3892
40-60 0.35 8 8.75 0.6 18 1 18 324 1241.86
49
 ∑ 25.00 1.00 100.00 1.30 0.10 0.9608 24.0200 9. 1734
60-80 0.2393 2 5.9825 0.8 88 1 88 7744 1208.26
51
80-100 0.1637 7 4.0925 1 9 1 9 81 1957.18
54
4.3
 ∑
25
30 1 30 900 540.10
54
k xm ni F0 pi ni' (ni-ni')2/ni’
62 1 62 3844 76.74
54
1 20 4 0.2 0.2 5 0.2
41 1 41 1681 149.82
62
2 40 4 0.4 0.2 5 0.2
81 1 81 6561 770.62
69
3 60 8 0.6 0.2 5 1.8
54
81
4 80 2 0.8 0.2 5 1.8
49 1 49 2401 17.98
85
5 100 7 1 0.2 5 0.8
54
87
Kokku
25
0 4.8
15 1 15 225 1462.30
88
94
89
χ² = 4,8
85 1 85 7225 1008.70
94
Et hüpotees vastu võetaks peab χ²kr>χ². Seega hüpoteesi vastu ei võeta ning võib järeldada, et üldkogumi jaotus ei ole normaaljaotus
43
94
87 1 87 7569 7569.00
25 1331
keskX 53.24
DX 705.69
Me 51.00
haare L 85.00
s 26.56
Sc 27.1126123787
Dn=sqn*sup

Sheet 2: Sheet2

0.57 20
2.355 40
4.1825 60
4.895 80
-5.7175 100
Xm ui ni φ(ui) pi ni' (ni-ni')^2/ni'
20 -1.2515060241 4 0.11 0.11 2.64 0.7006060606 keskv 53.24
40 -0.4984939759 4 0.31 0.21 5.1625 0.2617736077 standart 26.56
60 0.2545180723 8 0.60 0.29 7.165 0.0973098395
80 1.0075301205 2 0.84 0.24 6.065 2.7245218467
100 1.7605421687 7 0.96 0.12 2.9875 5.3891736402
Kokku
25
24.02 9.1733849947
5.00
xm Vahemik ni (emp) pi n(norm) n(üht) F(norm) F(üht) F(exp)
0
0.002014486 0.01 0.019
20 0-20 4 0.16 3 5 0.0068639066 0.01 0.0129933668
40 20-40 4 0.16 5 5 0.0132654419 0.01 0.0088856621
60 40-60 8 0.32 7 5 0.0145417045 0.01 0.0060765614
80 60-80 2 0.08 6 5 0.0090417429 0.01 0.0041555259
100 80-100 7 0.28 3 5 0.0031888363 0.01 0.0028418038
kokku 25 1 24 25

Sheet 3: ul6

empiiriline ühtlane
ül.7
1 9 0.04 0.09
0.05 0.05 0
Empiirilise ja ühtlase jaotuse jaotusfunktsiooni maksimaalne erinevus: DN=0,17
0.1 2 15 0.08 0.15
0.07 0.07 0.11 0.04
DN=max[Femp(Xi)- F0(Xi)]
3 18 0.12 0.18
0.06 0.06 0.1 0.04
Et hüpotees vastu võetaks, peab DN≤Dkr, siin on 0,17

Sheet 5: ul9

Lähterida Märgirida Käänupunktid Järjestatud rida
37 -
9
9 54 -
15
15 94 + K 18
18 32 - K 19
19 19 -
30
30 33 -
32
32 69 + K 33
33 51 - K 37
37 89 + K 41
51
41 43 - K 43
43 18 -
43
43 88 + K 49
49 9 - K 51
51 30 -
54
54 62
K 54
54 41 -
54
54 81 + K 62
62 54 - K 69
69 49 -
81
81 54 -
85
85 15 -
87
87 94 + K 88
88 85 +
89
89 43 - K 94
94 87 + K 94
94

Sheet 6: osa b

8-Jan
xi yi
(xi-x̅)^2
9.3
1.1 7.2
3.5344
b0 1.3604048759
b1=3,955>3,861 Mudeli liikme b1 võib lugeda oluliseks
2.8 8.9
7.84
b0=1,935>1,153 Mudeli liikme b0 võib lugeda oluliseks
2.2 6.8
4.84
b1 3.2548976926
5.1 19.3
26.01
ül 9.4
3.7 13.1
13.69
d 2
keskmine 2.98 11.06 kokku 55.9144
s²ad 4.1436765346
F 1.9040964382
F kr 3.6
9-Feb
r
s²(b0) 0.4171449488
3.4
s²(b1) 0.0389200363
3.2
∆b1 1.5804380021
6.4
∆b0 0.482748116
4.2
b0usald. 0.9432599271 ≤ β0 ≤ 1.8431529919 0.95
7.1
b1usald. 1.6744596905 ≤ β1 ≤ 4.8353356948 0.95
Punktis x=1
5.5
s(y) 0.7666943364
4.9
∆y 1.8761010411
y̅0 4.9571428571
s²(y) 2.1761904762
P 2.7392015274 ≤ μ(yI1) ≤ 6.4914036097 = 0.95
-1 0 1 3 5
-1 1 3 7 11
Punktis x=3
s(y) 0.6597375715
2.74 6.49 12.74
∆y 1.6143778375
9.51 15.75 19.52
P 9.5107201164 ≤ μ(yI3) ≤ 12.7394757913 = 0.95
Punktis x=5
s(y) 0.7707447121
∆y 1.8860123105
P 15.7488810286 ≤ μ(yI5) ≤ 19.5209056497 = 0.95

Sheet 7: 10ul

xi yi (xi-x̅)^2 (yi-y)^2 (xi-x̅) (yi-y) (xi-x̅)(yi-y) xi*yi
1.1 7.2 3.5344 14.8996 -1.88 -3.86 7.2568 7.92
2.8 8.9 0.0324 4.6656 -0.18 -2.16 0. 3888 24.92
2.2 6.8 0. 6084 18.1476 -0.78 -4.26 3.3228 14.96
5.1 19.3 4.4944 67.8976 2.12 8.24 17.4688 98.43
3.7 13.1 0. 5184 4. 1616 0.72 2.04 1.4688 48.47
2.98 11.06 9.188 109.772 2.22044604925031E-015 -1.77635683940025E-015 29.906 194.7
r= 0.9416771824
31.7582294217 0.5869344841
d= 0.8867559159
4.8467979187
2.4786313041
z=0,5*(√(N-3))*ln((1+r)/(1-r))=0,5*(√(5-3))*ln((1+0,75)/(1-0,75))=2,35˃Z