Rakendusstatistika AGT-1 Excel fail (0)

Overview

Osa A
Jaotustihedus
Histogramm ül 4
ÜL 5
ÜL 6
Aegrida
Aegrida diagramm
Osa B
Regressioonimudel

Sheet 1: Osa A

N N ( variatsioonrida ) Keskväärtus Dispersioon Standardhälve Mediaan Haare
Studenti t(0,95;24) Poollaius Alumine piir Ülemine piir X- statistik (0,05;24) X-statistik(0,95;24) Alumine piir Ülemine piir
12 1 45.12 1165 .0266666667 34.1324869687 38 97
1.711 11.6801370407 33.4398629593 56.8001370407 13.848 36.415 767.8330358369 2019.1103408435
6 4
-0.7148614756
34.9508
11 6
ÜL 4
ÜL 3 ( valemist )
62 7
Vahemikud Tõenäosus/laius Väärtusi vahemikus Tõenäosus
21 10
0-20 0.016 8 0.32
62 11
21-40 0.01 5 0.2
7 12
41-60 0.004 2 0.08
0, x˂1
98 15
61-80 0.008 4 0.16 F(25)x i/25, x(i)˂x˂x(i+1)
10 21
81-100 0.012 6 0.24
1, x˃98
1 25
Kolmogorov-Smirnov
ÜL 8
52 27
Normaaljaotus
Empiiriline Hüpoteetiline
Empiiriline Hüpoteetiline Punkt
Rühmakesk dispersioon üldkeskm rühmasis disp rühmadevah disp F-stat F(kr) 27 33
Vahemikud Tõenäosus/laius Väärtusi vahemikus
0 x≤0 0.04 0.01 1 12 6 11 62 21 22.4 519.3 45.12 1158.86 239.172 0.2063855858 2.8661 81 38
0-20 0.01148 5.74
x/100 0≤x≤100 0.08 0.04 2 62 7 98 10 1 35.6 1815.3
25 46
21-40 0.01054 5.27
1 x≥100 0.12 0.06 3 52 27 81 25 94 55.8 971.7
94 52
41-60 0.01148 5.74
d+ d-
0.16 0.07 4 46 38 74 95 33 57.2 697.7
46 62
61-80 0.008805 4.4025
0.03 0.01 0.03
0.20 0.1 5 71 15 96 4 87 54.6 1790.3
38 62
81-100 0.007695 3.8475
0.04 0 0.04
0.24 0.11 6
74 71
0.06 0.02 0.06
0.28 0.12 7
95 74
Ühtlane jaotus
0.09 0.05 0.09
0.32 0.15 8
33 81
Vahemikud Tõenäosus/laius Väärtusi vahemikus
0.1 0.06 0.1
0.36 0.21 9
71 87
0-20 0.01 5
0.13 0.09 0.13
0.40 0.25 10
15 94
21-40 0.01 5
0.16 0.12 0.16
0.44 0.27 11
96 95
41-60 0.01 5
0.17 0.13 0.17
0.48 0.33 12
4 96
61-80 0.01 5
0.15 0.11 0.15
0.52 0.38 13
87 98
81-100 0.01 5
0.15 0.11 0.15
0.56 0.46 14
0.17 0.13 0.17
0.60 0.52 15
0.15 0.11 0.15
0.64 0.62 16
ÜL 4.1
0.14 0.1 0.14
0.68 0.62 17
t*(m) -1E-081 -0.7359557486 -0.1500037195 0.4359483097 1.0219003389 1.607852368
0.1 0.06 0.1
0.72 0.71 18
F(t) (tabelist) 0 0.2296 0.4404 0.67 0.8461 1
0.08 0.04 0.08
0.76 0.74 19
p(m) 0.2296 0.2108 0.2296 0. 1761 0.1539 1
0.02 0.02 0.02
0.80 0.81 20
n'(m) 5.74 5.27 5.74 4.4025 3.8475 25
0.06 0.02 0.06
0.84 0.87 21
n(m)-n'(m)RUUT/n'(m) 0.89 0.01 2.44 0.04 1.2 4.58 chi ruut 0.01 0.03 0.01
0.88 0.94 22
0.02 0.02 0.02
0.92 0.95 23
ÜL 4.2
4.605 tabelist chi ruut 0.01 0.05 0.01
0.96 0.96 24
p(m) 0.2 0.2 0.2 0.2 0.2
0.03 0.07 0.03
1.00 0.98 25
n'(m) 5 5 5 5 5
0.06 0.1 0.06
n(m)-n'(m)RUUT/n'(m) 1.8 0 1.8 0.2 0.2 4 chi ruut 0.03 0.07 0.03
0 0.04 0
0.02 0.02 0.02
max 0.17
D(N) 0.17

Sheet 2: Jaotustihedus

N i/N Empiiriline x y Ühtlane x y
Jaotustihedus (norm)
Histogramm
Norm histogramm
Ühtlane histogramm
Ühtlane jaotustihedus 0 0
0 0
-1 0
x y
x y
x y
x y
-1 0 1 0.04
1 0
0 0
-1
-1 0
-1 0
-1
0 0 4 0.08
1 0.04
1 0.01
0 0.0048785451
0 0
0 0
0
0 0.01 6 0.12
4 0.04
2 0.02
0 0.0048785451
0 0.016
0 0.00681
0 0.01
1 0.01 7 0.16
4 0.08
3 0.03
1 0.0050690153
1 0.016
1 0.00681
1 0.01
2 0.01 10 0.2
6 0.08
4 0.04
2 0.0052624031
2 0.016
2 0.00681
2 0.01
3 0.01 11 0.24
6 0.12
5 0.05
3 0.0054584815
3 0.016
3 0.00681
3 0.01
4 0.01 12 0.28
7 0.12
6 0.06
4 0.0056570081
4 0.016
4 0.00681
4 0.01
5 0.01 15 0.32
7 0.16
7 0.07
5 0.005857725
5 0.016
5 0.00681
5 0.01
6 0.01 21 0.36
10 0.16
8 0.08
6 0.0060603594
6 0.016
6 0.00681
6 0.01
7 0.01 25 0.4
10 0.2
9 0.09
7 0.0062646239
7 0.016
7 0.00681
7 0.01
8 0.01 27 0.44
11 0.2
10 0.1
8 0.0064702171
8 0.016
8 0.00681
8 0.01
9 0.01 33 0.48
11 0.24
11 0.11
9 0.006676824
9 0.016
9 0.00681
9 0.01
10 0.01 38 0.52
12 0.24
12 0.12
10 0.0068841167
10 0.016
10 0.00681
10 0.01
11 0.01 46 0.56
12 0.28
13 0.13
11 0.0070917553
11 0.016
11 0.00681
11 0.01
12 0.01 52 0.6
15 0.28
14 0.14
12 0.0072993886
12 0.016
12 0.00681
12 0.01
13 0.01 62 0.64
15 0.32
15 0.15
13 0.007506655
13 0.016
13 0.00681
13 0.01
14 0.01 62 0.68
21 0.32
16 0.16
14 0.0077131832
14 0.016
14 0.00681
14 0.01
15 0.01 71 0.72
21 0.36
17 0.17
15 0.0079185937
15 0.016
15 0.00681
15 0.01
16 0.01 74 0.76
25 0.36
18 0.18
16 0.0081224996
16 0.016
16 0.00681
16 0.01
17 0.01 81 0.8
25 0.4
19 0.19
17 0.0083245077
17 0.016
17 0.00681
17 0.01
18 0.01 87 0.84
27 0.4
20 0.2
18 0.0085242199
18 0.016
18 0.00681
18 0.01
19 0.01 94 0.88
27 0.44
21 0.21
19 0.0087212343
19 0.016
19 0.00681
19 0.01
20 0.01 95 0.92
33 0.44
22 0.22
20 0.0089151465
20 0.016
20 0.00681
20 0.01
21 0.01 96 0.96
33 0.48
23 0.23
21 0.0091055512
21 0.01
21 0.01054
21 0.01
22 0.01 98 1
38 0.48
24 0.24
22 0.0092920432
22 0.01
22 0.01054
22 0.01
23 0.01
38 0.52
25 0.25
23 0.0094742191
23 0.01
23 0.01054
23 0.01
24 0.01
46 0.52
26 0.26
24 0.0096516786
24 0.01
24 0.01054
24 0.01
25 0.01
46 0.56
27 0.27
25 0.0098240259
25 0.01
25 0.01054
25 0.01
26 0.01
52 0.56
28 0.28
26 0.0099908715
26 0.01
26 0.01054
26 0.01
27 0.01
52 0.6
29 0.29
27 0.0101518331
27 0.01
27 0.01054
27 0.01
28 0.01
62 0.6
30 0.3
28 0.0103065376
28 0.01
28 0.01054
28 0.01
29 0.01
62 0.64
31 0.31
29 0.010454622
29 0.01
29 0.01054
29 0.01
30 0.01
62 0.64
32 0.32
30 0.0105957354
30 0.01
30 0.01054
30 0.01
31 0.01
62 0.68
33 0.33
31 0.0107295398
31 0.01
31 0.01054
31 0.01
32 0.01
71 0.68
34 0.34
32 0.0108557119
32 0.01
32 0.01054
32 0.01
33 0.01
71 0.72
35 0.35
33 0.0109739442
33 0.01
33 0.01054
33 0.01
34 0.01
74 0.72
36 0.36
34 0.0110839462
34 0.01
34 0.01054
34 0.01
35 0.01
74 0.76
37 0.37
35 0.0111854457
35 0.01
35 0.01054
35 0.01
36 0.01
81 0.76
38 0.38
36 0.0112781899
36 0.01
36 0.01054
36 0.01
37 0.01
81 0.8
39 0.39
37 0.0113619464
37 0.01
37 0.01054
37 0.01
38 0.01
87 0.8
40 0.4
38 0.0114365042
38 0.01
38 0.01054
38 0.01
39 0.01
87 0.84
41 0.41
39 0.0115016745
39 0.01
39 0.01054
39 0.01
40 0.01
94 0.84
42 0.42
40 0.0115572918
40 0.01
40 0.01054
40 0.01
41 0.01
94 0.88
43 0.43
41 0.0116032141
41 0.004
41 0.01148
41 0.01
42 0.01
95 0.88
44 0.44
42 0.0116393239
42 0.004
42 0.01148
42 0.01
43 0.01
95 0.92
45 0.45
43 0.0116655288
43 0.004
43 0.01148
43 0.01
44 0.01
96 0.92
46 0.46
44 0.0116817613
44 0.004
44 0.01148
44 0.01
45 0.01
96 0.96
47 0.47
45 0.0116879797
45 0.004
45 0.01148
45 0.01
46 0.01
98 0.96
48 0.48
46 0.011684168
46 0.004
46 0.01148
46 0.01
47 0.01
98 1
49 0.49
47 0.0116703361
47 0.004
47 0.01148
47 0.01
48 0.01
100 1
50 0.5
48 0.0116465194
48 0.004
48 0.01148
48 0.01
49 0.01
51 0.51
49 0.0116127792
49 0.004
49 0.01148
49 0.01
50 0.01
52 0.52
50 0.0115692021
50 0.004
50 0.01148
50 0.01
51 0.01
53 0.53
51 0.0115158997
51 0.004
51 0.01148
51 0.01
52 0.01
54 0.54
52 0.0114530079
52 0.004
52 0.01148
52 0.01
53 0.01
55 0.55
53 0.0113806867
53 0.004
53 0.01148
53 0.01
54 0.01
56 0.56
54 0.0112991195
54 0.004
54 0.01148
54 0.01
55 0.01
57 0.57
55 0.0112085119
55 0.004
55 0.01148
55 0.01
56 0.01
58 0.58
56 0.0111090914
56 0.004
56 0.01148
56 0.01
57 0.01
59 0.59
57 0.0110011059
57 0.004
57 0.01148
57 0.01
58 0.01
60 0.6
58 0.010884823
58 0.004
58 0.01148
58 0.01
59 0.01
61 0.61
59 0.010760529
59 0.004
59 0.01148
59 0.01
60 0.01
62 0.62
60 0.0106285274
60 0.004
60 0.01148
60 0.01
61 0.01
63 0.63
61 0.0104891379
61 0.008
61 0.008805
61 0.01
62 0.01
64 0.64
62 0.010342695
62 0.008
62 0.008805
62 0.01
63 0.01
65 0.65
63 0.0101895467
63 0.008
63 0.008805
63 0.01
64 0.01
66 0.66
64 0.0100300531
64 0.008
64 0.008805
64 0.01
65 0.01
67 0.67
65 0.0098645852
65 0.008
65 0.008805
65 0.01
66 0.01
68 0.68
66 0.0096935229
66 0.008
66 0.008805
66 0.01
67 0.01
69 0.69
67 0.0095172545
67 0.008
67 0.008805
67 0.01
68 0.01
70 0.7
68 0.0093361742
68 0.008
68 0.008805
68 0.01
69 0.01
71 0.71
69 0.0091506814
69 0.008
69 0.008805
69 0.01
70 0.01
72 0.72
70 0.0089611788
70 0.008
70 0.008805
70 0.01
71 0.01
73 0.73
71 0.0087680714
71 0.008
71 0.008805
71 0.01
72 0.01
74 0.74
72 0.0085717646
72 0.008
72 0.008805
72 0.01
73 0.01
75 0.75
73 0.0083726631
73 0.008
73 0.008805
73 0.01
74 0.01
76 0.76
74 0.0081711695
74 0.008
74 0.008805
74 0.01
75 0.01
77 0.77
75 0.0079676831
75 0.008
75 0.008805
75 0.01
76 0.01
78 0.78
76 0.0077625981
76 0.008
76 0.008805
76 0.01
77 0.01
79 0.79
77 0.0075563032
77 0.008
77 0.008805
77 0.01
78 0.01
80 0.8
78 0.0073491799
78 0.008
78 0.008805
78 0.01
79 0.01
81 0.81
79 0.0071416013
79 0.008
79 0.008805
79 0.01
80 0.01
82 0.82
80 0.0069339315
80 0.008
80 0.008805
80 0.01
81 0.01
83 0.83
81 0.0067265243
81 0.012
81 0.00501
81 0.01
82 0.01
84 0.84
82 0.0065197225
82 0.012
82 0.00501
82 0.01
83 0.01
85 0.85
83 0.0063138568
83 0.012
83 0.00501
83 0.01
84 0.01
86 0.86
84 0.0061092454
84 0.012
84 0.00501
84 0.01
85 0.01
87 0.87
85 0.005906193
85 0.012
85 0.00501
85 0.01
86 0.01
88 0.88
86 0.0057049904
86 0.012
86 0.00501
86 0.01
87 0.01
89 0.89
87 0.0055059141
87 0.012
87 0.00501
87 0.01
88 0.01
90 0.9
88 0.0053092254
88 0.012
88 0.00501
88 0.01
89 0.01
91 0.91
89 0.0051151706
89 0.012
89 0.00501
89 0.01
90 0.01
92 0.92
90 0.0049239803
90 0.012
90 0.00501
90 0.01
91 0.01
93 0.93
91 0.0047358693
91 0.012
91 0.00501
91 0.01
92 0.01
94 0.94
92 0.0045510367
92 0.012
92 0.00501
92 0.01
93 0.01
95 0.95
93 0.0043696655
93 0.012
93 0.00501
93 0.01
94 0.01
96 0.96
94 0.0041919227
94 0.012
94 0.00501
94 0.01
95 0.01
97 0.97
95 0.0040179596
95 0.012
95 0.00501
95 0.01
96 0.01
98 0.98
96 0.0038479117
96 0.012
96 0.00501
96 0.01
97 0.01
99 0.99
97 0.0036818987
97 0.012
97 0.00501
97 0.01
98 0.01
100 1
98 0.0035200255
98 0.012
98 0.00501
98 0.01
99 0.01
101 1
99 0.0033623816
99 0.012
99 0.00501
99 0.01
100 0.01
100 0.0032090422
100 0.012
100 0.00501
100 0.01
100 0
100 0.0032090422
100 0
100 0
100
101 0
101
101 0
101 0
101

Sheet 3: Histogramm ül 4

Sheet 4: ÜL 5

Sheet 5: ÜL 6

Sheet 6: Aegrida

12 -
x(med) 38
P 19 6 - K
L(max) 4
p(kr) 11.3538950704 11 -
Ns 18
62 + K
L(max)kr 7.9132020286
21 - K
Ns(kr) 8.1990001041
62 + K
7 - K
98 + K
10 -
1 - K
52 + K
27 - K
81 + K
25 - K
94 + K
46 +
38
K
74 +
95 + K
33 - K
71 + K
15 - K
96 + K
4 - K
87 +

Sheet 7: Aegrida diagramm

Sheet 8: Osa B

B1
B2 y-y0(kesk)RUUT
x 3.1 4.9 4.2 1.9 1.1
4.3 0.5951020408 b1 b0 t(0,975,6) dispersioon b1 dispersioon b0 y 12.1 23.9 16.8 9.2 7.8
5.6 0.2793877551 3.9554294976 1.9354943274 2.447 0.2220807286 2.4908574516
3.7 1.8808163265
7.2 4.5308163265 delta b1 delta b0 disp(ad) F F(kr)(0,95;3,6) i x y x-x(kesk) y-y(kesk) x-x(kesk)RUUT y-y(kesk)RUUT Vahede korrutis x*y xRUUT
3.2 3.502244898 1.1531595662 3.861965648 5.493462993 2.5057064043 4.757 1 3.1 12.1 0.06 -1.86 0.0036 3.4596 -0.1116 37.51 9.61
4.9 0.0293877551
2 4.9 23.9 1.86 9.94 3.4596 98.8036 18.4884 117.11 24.01
6.6 2.3365306122 s(y)RUUT 2.1923809524
3 4.2 16.8 1.16 2.84 1.3456 8.0656 3.2944 70.56 17.64 y0(kesk) 5.0714285714 13.1542857143
4 1.9 9.2 -1.14 -4.76 1.2996 22.6576 5.4264 17.48 3.61
5 1.1 7.8 -1.94 -6.16 3.7636 37.9456 11.9504 8.58 1.21 y(xi) y-y(xi)RUUT
y(1) 5.890923825
summa 15.2 69.8
9.872 170.932 39.048 251.24 56.08 14.1973257699 4.3987753849
y(3) 13.8017828201
3.04 13.96
21.3170988655 6.6713782707
y(5) 21.7126418152
x(kesk) y(kesk)
18.5482982172 3.0565466562
s(y1/x) 1.1673420024
tabelist
9.4508103728 0.0629058431
delta(y1/x) 2.8564858798
r 0.950570942 0.950570942
6.2864667747 2.290782824
s(y3/x) 0.6624435973
d 0.9035851158
16.4803889789 summa delta(y3/x) 1.6209994827
t 5.3024077279
3.182
s(y5/x) 1.1364952782
z 2.5988570808
1.96
delta(y5/x) 2.7810039457
x y usaldus
3.1 14.1973257699
4.9 21.3170988655
4.2 18.5482982172
1.9 9.4508103728
1.1 6.2864667747
1 5.890923825 3.0344379452 8.7474097047
3 13.8017828201 12.1807833374 15.4227823028
5 21.7126418152 18.9316378695 24.4936457609

Sheet 9: Regressioonimudel