Arvutusgraafiline rakendusstatistika kodutöö exel (1)

Overview

OSA A
OSA B

Sheet 1: OSA A

Kasvavalt järjestatud xi/100
i xi
N 25
xi F0(xi) di+ di- di
m nm pm
4 5 9 11 12 17 24 29 33 33 36 43 51 53 54 55 55 56 56 69 71 71 80 84 92 1 71
Keskväärtus 44.12
722.5344 4 0.04 0 0.04 0.04
0-20 6 0.24 58
9.6666666667 8156.5920870748
2 43
Dispersioon 673.4433333333
1.2544 5 0.05 0.03 0.01 0.03
20-40 5 0.2 155
31 1207.0140408163
3 56
Standardhälve 25.9507867575
141.1344 9 0.09 0.03 0.01 0.03
40-60 8 0.32 483.4285714286
60.4285714286 1543.7743020408
71 43 56 17 56 9 29 24 33 4 53 51 80 36 54 84 33 69 55 92 11 12 5 71 55 4 17
Mediaan 51 51
735.4944 11 0.11 0.05 0.01 0.05
60-80 4 0.16 291
72.75 2748.4555183674
5 56
Haare 88
141.1344 12 0.12 0.08 0.04 0.08
80-100 2 0.08 176
88 3438.337044898
6 9
1233.4144 17 0.17 0.07 0.03 0.07
46.5371428571
σ ̂ 712.2572080499
7 29
228.6144 24 0.24 0.04 0 0.04
8 24
α 0.1
404.8144 29 0.29 0.03 0.01 0.03
Normaaljaotus t F(t) Ф(t) hii-ruut
9 33
t1-α/2 0.95
123.6544 33 0.33 0.03 0.01 0.03
20 -0.93 0.18 0.18 0.023
10 4
f (vabadusaste) 24
1609.6144 33 0.33 0.07 0.03 0.07
40 -0.16 0.44 0.26 0.014
11 53
78.8544 36 0.36 0.08 0.04 0.08
60 0.61 0.73 0.29 0.003
12 51
t1-α/2(f) (t kvantiil ) 1.7109
47.3344 43 0.43 0.05 0.01 0.05
80 1.38 0.92 0.19 0.004
13 80
Δμ (poollaius) 8.8798
1287 .3744 51 0.51 0.01 0.03 0.03
100 2.15 0.98 0.07 0.002
14 36
65.9344 53 0.53 0.03 0.01 0.03
0.046
15 54
Keskväärtuse usaldusvah.
97.6144 54 0.54 0.06 0.02 0.06
16 84
alumine ülemine
1590.4144 55 0.55 0.09 0.05 0.09
H0:F(x,θ) F0(x,θ)
17 33
35.2402 52.9998
123.6544 55 0.55 0.13 0.09 0.13
χ21-α 0.9
18 69
619.0144 56 0.56 0.16 0.12 0.16
k (intervallide arv) 5
19 55
χ2α/2 0.05
118.3744 56 0.56 0.2 0.16 0.2
h (hinnatavate param. arv) 2 hinnatavad parameetrid on μ ja σ
Normaaljaotus
Eksponentjaotus
Ühtlane jaotus
Empiiriline jaotus
20 92
χ21-α/2 0.95
2292.4944 69 0.69 0.11 0.07 0.11
f (vabadusaste) 2
x Ф(x) - vasak telg f(x) - parem telg
x Ф(x) - vasak telg f(x) - parem telg
x Ф(x) - vasak telg f(x) - parem telg
x F(x) F ühtlane (x)
21 11
1096 .9344 71 0.71 0.13 0.09 0.13
χ21-α(f) 4.605
0
0. 0036
0
0.023
0
0.010
0 0.00 0.00
22 12
hii-ruut kvantiilid
1031.6944 71 0.71 0.17 0.13 0.17
kriitiline kvantiili väärtus χ2 > 4,605
1
0.0039
1
0.022
1
0.010
0 0.00 0.01
23 5
χ2α/2(f) 13.848
1530 .3744 80 0.8 0.12 0.08 0.12
H0 hüpotees vastuvõetud, sest 0,046 2
0.0041
2
0.022
2
0.010
0 0.00 0.02
24 71
χ21-α/2(f) 36.415
722.5344 84 0.84 0.12 0.08 0.12
3
0.0044
3
0.021
3
0.010
0 0.00 0.03
25 55
118.3744 92 0.92 0.08 0.04 0.08
4
0.0047
4
0.021
4
0.010
1 0.04 0.04
Dispersiooni usaldusvah.
DN 0.2
Eksponentjaotus F(t) Ф(t) hii-ruut
5
0.0049
5
0.020
5
0.010
1 0.04 0.05
alumine ülemine
Dkrit = 0,238, hüpotees võetakse vastu, kui Dkrit > DN
20 0.36 0.36 0.043
6
0.0052
6
0.020
6
0.010
2 0.08 0.06
443.8457 1167.146158
hüpotees võetakse vastu, sest 0,2 40 0.60 0.23 0.004
7
0.0055
7
0.019
7
0.010
2 0.08 0.07
60 0.74 0.15 0.203
8
0.0058
8
0.019
8
0.010
2 0.08 0.08
80 0.84 0.09 0.047
9
0.0062
9
0.018
9
0.010
2 0.08 0.09
H0:μ 50 kriitiline piirkond │t│>1,7109
100 0.90 0.06 0.007
10 0.18 0.0065
10 0.36 0.018
10 0.20 0.010
3 0.12 0.10
t- statistik -1.1329 H0 hüpotees vastuvõetud, sest │-1,1329│ 0.304
11
0.0068
11
0.018
11
0.010
3 0.12 0.11
12
0.0071
12
0.017
12
0.010
3 0.12 0.12
H0:σ2 800 kriitiline piirkond χ2 36,415
H0:F(x,θ) F0(x,θ)
13
0.0075
13
0.017
13
0.010
4 0.16 0.13
hii-statistik 20. 2033 H0 hüpotees vastuvõetud, sest 13,848 Lambda 0.0227
14
0.0078
14
0.017
14
0.010
5 0.20 0.14
χ21-α 0.9
15
0.0082
15
0.016
15
0.010
5 0.20 0.15
k (intervallide arv) 5
16
0.0085
16
0.016
16
0.010
5 0.20 0.16
Katse
h (hinnatavate parameetrite arv) 1 hinnatav parameeter λ
17
0.0089
17
0.015
17
0.010
6 0.24 0.17
i 1 2 3 4
Mui S2i
f (vabadusaste) 3
18
0.0093
18
0.015
18
0.010
6 0.24 0.18
1 71 43 56 17
47 524 21.0069444444
χ21-α(f) 6.251
19
0.0096
19
0.015
19
0.010
6 0.24 0.19
2 53 51 80 36
55 335 164.6944444444
kriitiline kvantiili väärtus χ2 > 6,251
20
0.0100
20
0.014
20
0.010
6 0.24 0.20
3 11 12 5 71
25 960 303.3402777778
H0 hüpotees vastuvõetud, sest 0,304 21
0.0103
21
0.014
21
0.010
6 0.24 0.21
22
0.0107
22
0.014
22
0.010
6 0.24 0.22
23
0.0110
23
0.013
23
0.010
6 0.24 0.23
Ühtlane jaotus Ф(t) hii-ruut
24
0.0114
24
0.013
24
0.010
7 0.28 0.24
588.0625 14.0625 85.5625 885.0625
20 0.20 0.008
25
0.0117
25
0.013
25
0.010
7 0.28 0.25
4 16 625 361
40 0.20 0.000
26
0. 0120
26
0.013
26
0.010
7 0.28 0.26
189.0625 162.5625 390.0625 2139.0625
60 0.20 0.072
27
0.0124
27
0.012
27
0.010
7 0.28 0.27
80 0.20 0.008
28
0.0127
28
0.012
28
0.010
7 0.28 0.28
100 0.20 0.072
29
0.0130
29
0.012
29
0.010
8 0.32 0.29
0.160
30 0.26 0.0133
30 0.23 0.011
30 0.20 0.010
8 0.32 0.30
Üldkeskmine 42.1666666667
31
0.0135
31
0.011
31
0.010
8 0.32 0.31
S20 606.6111111111
H0:F(x,θ) F0(x,θ)
32
0.0138
32
0.011
32
0.010
8 0.32 0.32
S2A 244.5208333333 Kriitiline piirkond F > 3,43
χ21-α 1
33
0.0140
33
0.011
33
0.010
9 0.36 0.33
F 0.4031 H0 hüpotees vastuvõetud, sest 0,4031 k (intervallide arv) 5
34
0.0142
34
0.010
34
0.010
10 0.40 0.34
h (hinnatavate parameetrite arv) 0
35
0.0145
35
0.010
35
0.010
10 0.40 0.35
f1 2
f (vabadusaste) 4
36
0.0146
36
0.010
36
0.010
10 0.40 0.36
f2 22
χ21-α(f) 7.779
37
0.0148
37
0.010
37
0.010
11 0.44 0.37
Fkrit 3.43
kriitiline kvantiili väärtus χ2 > 7,779
38
0.0150
38
0.010
38
0.010
11 0.44 0.38
H0 hüpotees vastuvõetud, sest 0,160 39
0.0151
39
0.009
39
0.010
11 0.44 0.39
40
0.0152
40
0.009
40
0.010
11 0.44 0.40
41
0.0153
41
0.009
41
0.010
11 0.44 0.41
42
0.0153
42
0.009
42
0.010
11 0.44 0.42
43
0.0154
43
0.009
43
0.010
11 0.44 0.43
44
0.0154
44
0.008
44
0.010
12 0.48 0.44
45
0.0154
45
0.008
45
0.010
12 0.48 0.45
46
0.0153
46
0.008
46
0.010
12 0.48 0.46
47
0.0153
47
0.008
47
0.010
12 0.48 0.47
48
0.0152
48
0.008
48
0.010
12 0.48 0.48
49
0.0151
49
0.007
49
0.010
12 0.48 0.49
50 0.29 0.0150
50 0.15 0.007
50 0.20 0.010
12 0.48 0.50
51
0.0148
51
0.007
51
0.010
12 0.48 0.51
52
0.0147
52
0.007
52
0.010
13 0.52 0.52
53
0.0145
53
0.007
53
0.010
13 0.52 0.53
54
0.0143
54
0.007
54
0.010
14 0.56 0.54
55
0.0141
55
0.007
55
0.010
15 0.60 0.55
56
0.0138
56
0.006
56
0.010
16 0.64 0.56
57
0.0136
57
0.006
57
0.010
17 0.68 0.57
58
0.0133
58
0.006
58
0.010
18 0.72 0.58
59
0.0130
59
0.006
59
0.010
19 0.76 0.59
60
0.0127
60
0.006
60
0.010
19 0.76 0.60
61
0.0124
61
0.006
61
0.010
19 0.76 0.61
62
0.0121
62
0.006
62
0.010
19 0.76 0.62
63
0.0118
63
0.005
63
0.010
19 0.76 0.63
64
0.0115
64
0.005
64
0.010
19 0.76 0.64
65
0.0111
65
0.005
65
0.010
19 0.76 0.65
66
0.0108
66
0.005
66
0.010
19 0.76 0.66
67
0.0104
67
0.005
67
0.010
19 0.76 0.67
68
0.0101
68
0.005
68
0.010
19 0.76 0.68
69
0.0097
69
0.005
69
0.010
19 0.76 0.69
70 0.19 0.0093
70 0.09 0.005
70 0.20 0.010
19 0.76 0.70
71
0. 0090
71
0.005
71
0.010
19 0.76 0.71
72
0.0086
72
0.004
72
0.010
20 0.80 0.72
73
0.0083
73
0.004
73
0.010
20 0.80 0.73
74
0.0079
74
0.004
74
0.010
21 0.84 0.74
75
0.0076
75
0.004
75
0.010
22 0.88 0.75
76
0.0072
76
0.004
76
0.010
22 0.88 0.76
77
0.0069
77
0.004
77
0.010
22 0.88 0.77
78
0.0066
78
0.004
78
0.010
22 0.88 0.78
79
0.0062
79
0.004
79
0.010
22 0.88 0.79
80
0.0059
80
0.004
80
0.010
22 0.88 0.80
81
0.0056
81
0.004
81
0.010
22 0.88 0.81
82
0.0053
82
0.004
82
0.010
22 0.88 0.82
83
0.0050
83
0.003
83
0.010
22 0.88 0.83
84
0.0047
84
0.003
84
0.010
23 0.92 0.84
85
0.0044
85
0.003
85
0.010
23 0.92 0.85
86
0.0042
86
0.003
86
0.010
23 0.92 0.86
87
0.0039
87
0.003
87
0.010
23 0.92 0.87
88
0.0037
88
0.003
88
0.010
24 0.96 0.88
89
0.0034
89
0.003
89
0.010
24 0.96 0.89
90 0.07 0.0032
90 0.06 0.003
90 0.20 0.010
24 0.96 0.90
91
0.0030
91
0.003
91
0.010
24 0.96 0.91
92
0.0028
92
0.003
92
0.010
24 0.96 0.92
93
0.0026
93
0.003
93
0.010
24 0.96 0.93
94
0.0024
94
0.003
94
0.010
24 0.96 0.94
95
0.0022
95
0.003
95
0.010
24 0.96 0.95
96
0.0021
96
0.003
96
0.010
25 1.00 0.96
97
0.0019
97
0.003
97
0.010
25 1.00 0.97
98
0.0018
98
0.002
98
0.010
25 1.00 0.98
99
0.0016
99
0.002
99
0.010
25 1.00 0.99
100
0.0015
100
0.002
100
0.010
25 1.00 1.00

Sheet 2: OSA B

X- kesks
N- 5
B1 i 1 2 3 4 5
2.88
i x y x-xkesk y-ykesk (x-xkesk)^2 (y-ykesk)^2 (x-xkesk)(y-ykesk)
xi 0.8 4.9 1.7 3.8 3.2
t satistik:
1 0.8 2.7 -2.08 -4.12 4.3264 16.9744 8.5696
yi 2.7 14.4 2.5 9.4 5.1
2 4.9 14.4 2.02 7.58 4.0804 57.4564 15.3116
3 1.7 2.5 -1.18 -4.32 1.3924 18.6624 5.0976
4 3.8 9.4 0.92 2.58 0.8464 6.6564 2.3736 B2
5 3.2 5.1 0.32 -1.72 0.1024 2.9584 -0.5504
0.6 3.4 4.1 0.2 1.4 2.8 1.8
keskväärtused 2.88 6.82
xkesk 2.88
Vx 10.75 4.3264 4.0804 1.3924 0.8464 0.1024
ykesk 6.82
0.9270709049
mean variance stdev Δb usaldusvahemik
b1 2.87 0.20 0.4420 0.4837 2.38 3.35 b1 > Δb => oluline
b0 -1.43 2.04 1.4283 1.5631 -3.00 0.13 b0 oluline
y0 2.04
s2(y) 2.10
2.0818 1.8418 4.2318 3.3961 0.4133 0.5733 0.0590
0.64 24.01 2.89 14.44 10.24
d 1
y progn 0.8591 12.6090 3.4383 9.4566 7.7371
3.3890521635 3.207724992 0.8804333595 0.0032000137 6.9541242684
s2ad 3.61
F 1.719
f1 4
f2 6
Fkr 4.534 adekvaatne
x 1 3 5
s y progn 1.05 0.65 1.14
Δy progn 2.58 1.59 2.79
y min p -1.15 5.57 10.11
y progn 1.43 7.16 12.90
y max p 4.01 8.75 15.68