Rakendusstatistika arvutusgraafiline kodutöö (excel fail) (6)

Overview

Sheet1
ül4
ül5
ül6 ja 7
ül 8
ül 9
ül10
ül 11

Sheet 1: Sheet1

45.04
Keskväärtus 45
ül4
ül4, osa 2
1
Dispersioon 1167.8333333333 1164.1233333333
intervalli nr vahemik elemente tõenäosus intervalli keskmine

k Xm ui ni φ(ui) pi ni' (ni-ni')^2/ni' 4
Mediaan 38
1 0-20 9 0.36 9.55
1 20 -0.7077444884 9 0.2296 0.2296 5.74 1.8514982578 6
Haare 97
2 20-40 4 0.16 30.75
2 40 -0.1424533635 4 0.4404 0.2108 5.27 0.3060531309 7
t- statistik -0.7066139062
3 40-60 2 0.08 49
3 60 0.4228377614 2 0.67 0.2296 5.74 2.4368641115 10
μ 50
4 60-80 5 0.2 69.8
4 80 0.9881288864 5 0.8485 0.1785 4.4625 0.0647408964 11
5 80-100 5 0.2 94
5 100 1.5534200113 5 0.9484 0.0999 2.4975 2.50751001 12
1.7108820667
Kokku
25
23.71 7.1666664066 15
20
25
0.4780363352
27
0.4168338365
F(t) fii(t) chi- square
33
1.7108820667
0.2395519723 0.22868 0.0754108029
38
36.4150284984
0.4433609571 0.2038089847 0.0094167936
46
13.848425093
0.6637931826 0.2204322256 0.0894660929
52
1164.1233333333
0.8384552348 0.1746620522 0.003675736
62
34.1192516526
0.9398385874 0.1013833526 0.0959254444
62
0.2738948699
71
74
80
87
94
95
96
98
dispersioon: 1134.7806835

Sheet 2: ül4

Ül 4.1
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
χ²=6,4367
χ²kr (0,10;2) = 4.605
ül 4.2
k xm ni F0 pi ni' (ni-ni')^2/n'i
1 20 9 0.2 0.2 5 3.2
2 40 4 0.4 0.2 5 0.2
3 60 2 0.6 0.2 5 1.8
4 80 5 0.8 0.2 5 0
5 100 5 1 0.2 5 0
kokku
25
25 5.2
χ²=5,2

Sheet 3: ül5

ül 5
Vahemik Xm ni(emp) ni(norm) ni(ühtl) f(norm) f(ühtl)


0
0.0050146329 0.01
45.04 keskväärtus
0-20 20 9 6 5 0.0087777396 0.01
35.38 standardhälve
20-40 40 4 5 5 0.011162094 0.01
40-60 60 2 6 5 0.0103116484 0.01
60-80 80 5 4 5 0.0069203802 0.01
80-100 100 5 2 5 0.0033740479 0.01
kokku
25 23 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 1 0.04 0.01
0.03 0.03 0 0.03
100 2 4 0.08 0.04
0.04 0.04 0 0.04
3 6 0.12 0.06
0.06 0.06 -0.02 0.08
4 7 0.16 0.07
0.09 0.09 -0.05 0.14
5 10 0.2 0.1
0.1 0.1 -0.06 0.16
6 11 0.24 0.11
0.13 0.13 -0.09 0.22
7 12 0.28 0.12
0.16 0.16 -0.12 0.28
8 15 0.32 0.15
0.17 0.17 -0.13 0.3
9 20 0.36 0.2
0.16 0.16 -0.12 0.28
10 25 0.4 0.25
0.15 0.15 -0.11 0.26
11 27 0.44 0.27
0.17 0.17 -0.13 0.3
12 33 0.48 0.33
0.15 0.15 -0.11 0.26
13 38 0.52 0.38
0.14 0.14 -0.1 0.24
14 46 0.56 0.46
0.1 0.1 -0.06 0.16
15 52 0.6 0.52
0.08 0.08 -0.04 0.12
16 62 0.64 0.62
0.02 0.02 0.02 0
17 62 0.68 0.62
0.06 0.06 -0.02 0.08
18 71 0.72 0.71
0.01 0.01 0.03 0.02
19 74 0.76 0.74
0.02 0.02 0.02 0
20 80 0.8 0.8
0 0 0.04 0.04
21 87 0.84 0.87
0.03 0.03 0.07 0.04
22 94 0.88 0.94
0.06 0.06 0.1 0.04
23 95 0.92 0.95
0.03 0.03 0.07 0.04
24 96 0.96 0.96
0 0 0.04 0.04
25 98 1 0.98
0.02 0.02 0.02 0

Sheet 5: ül 8

1 2 3 4 Rühma kesk Rühma disp (yi-y̅)^2
1.- 4. 12 6 11 62 37 1250 64.6416
11.- 14. 52 27 80 25 38.5 364.5 42.7716
21.- 24. 71 15 96 4 37.5 2244.5 56.8516
113 3859 164.2648
1447.125
82.1324
F= 0.0567555671
Fkr= 2.9 4.26

Sheet 6: ül 9

ül 9
Lähterida Märgirida Käänupunktid Järjestatud rida
12
1
6 - k 4
11 +
6
62 + k 7
20 - k 10
62 + k 11
7 - k 12
98 + k 15
10 -
20
1 - k 25
52 + k 27
27 - k 33
80 + k xmed=38
25 - k 46
94 + k 52
46 -
62
38 - k 62
74 +
71
95 + k 74
33 - k 80
71 + k 87
15 - k 94
96 + k 95
4 - k 96
87 + k 98

Sheet 7: ül10

ül 9
ül 9.1
ül 9.3
xi yi
(xi-x̅)^2
b0 1.9354943274
3.1 12.1
0. 0036
4.9 23.9
3.4596
b1 3.9554294976
4.2 16.8
1.3456
ül 9.4
1.9 9.2
1.2996
d 2
1.1 7.8
3.7636
keskmine 3.04 13.96 kokku 9.872
s²ad 5.493462993
F 2.5057064043
F kr 3.6 4.76
ül 9.2
r
s²(b0) 2.4908574516
4.3
s²(b1) 0.2220807286
5.6
∆b1 3.861965648
3.7
∆b0 1.1531595662
ül 9.5
7.2 b0 usaldusvahem. -0.5553631242 ≤ β0 ≤ 3.0886538936 = 0.95
3.2 b1 usaldusvahem. 0.0934638496 ≤ β1 ≤ 7.8173951456 = 0.95
Punktis x=1
4.9
s(y) 1.1673420024
6.6
∆y 2.8564858798
y̅0 5.0714285714
s²(y) 2.1923809524
P 3.0435141202 ≤ μ(yI1) ≤ 8.7564858798 = 0.95
Punktis x=3
s(y) 0.6624435973
∆y 1.6209994827
P 12.1990005173 ≤ μ(yI3) ≤ 15.4409994827 = 0.95
Punktis x=5
s(y) 1.1364952782
∆y 2.7810039457
P 18.9589960543 ≤ μ(yI5) ≤ 24.5210039457 = 0.95
ül 9.6
-1 0 1 3 5
-2.02 1.94 5.9 13.82 21.74
3.04 12.2 18.96
8.76 15.44 24.52

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