Rakendusstatistika kodutöö excel (2)

Overview

Leht1
Leht2

Sheet 1: Leht1

25
1 0 0.04
1 0 1 0 2134.4 0.04
0.2 2 2 0.08
2 2 1 2 1953.6 0.0384615385
0.4 3 7 0.12
3 7 1 7 1536.6 0.037037037
0.6 4 10 0.16
4 10 1 10 1310.4 0.0357142857
0.8 5 15 0.2
5 15 1 15 973.4 0.0344827586
6 28 0.24
6 28 1 28 331.2 0.0333333333
7 29 0.28
7 29 1 29 295.8 0.0322580645
8 30 0.32
8 30 1 30 262.4 0.03125
9 31 0.36
9 31 1 31 231.0 0.0303030303
10 32 0.4
10 32 2 64 403.3 0.0588235294
11 32 0.44
11 42 1 42 17.6 0.0285714286
12 42 0.48
12 46 1 46 0.0 0.0277777778
13 46 0.52
13 47 2 94 1.3 0.0540540541
14 47 0.56
14 48 1 48 3.2 0.0263157895
15 47 0.6
15 53 1 53 46.2 0.0238095238
0
16 48 0.64
16 68 1 68 475.2 0.025
2
17 53 0.68
17 70 1 70 566.4 0.0243902439
7
18 68 0.72
18 75 2 150 1658 .9 0.0476190476
10
19 70 0.76
19 79 1 79 1075 .8 0.023255814
15
20 75 0.8
20 94 1 94 2284.8 0.0227272727
28
21 75 0.84
21 96 1 96 2480 .0 0.0222222222
0 0 0
29
22 79 0.88
99 1 99 2787.8 0.0040650407
1 20 0.04
30
23 94 0.92
xkesk 46.20
2 40 0.08
31
24 96 0.96
Sx2 867.9166666667
Intervalli nr Vahemik Elemente Tõenäosus Intervalli keskmine nixi
3 60 0.12
32
25 99 1
Sx 29.4604254325
1 0-20 5 0.2 6.8 34 7761.8 Err:509 Err:509 0.2 80 0.008
32
46.2
Me 46
2 20-40 6 0.24 30.3 182 1510 .5066666667 Err:509 Err:509 0.44 100 0.0176
42
46.2
R 99
3 40-60 6 0.24 47.2 283 5.6066666667 Err:509 Err:509 0.68
0.0272
46
36.415
tα, N-1 1.711
4 60-80 5 0.2 73.4 367 3699.2 Err:509 Err:509 0.88
47
13.843
Xkesk usal 36.1193372898