Statistika ülesanded (0)

Overview

Tiitelleht
Ül4
Ül5
Ül6
Ül7
Ül8
Ül9
Ül10
Ül11

Sheet 1: Tiitelleht

9
11
1
4
12
N 25
N(μ,σ)
X2- statistik 6.331
11
15
k 24
x̅ 49.72
U(0,100)
X2-statistik 4.400
b0 -2.431 17
t0,95(24) 1.7108820799
σ 868.7933333333
b1 4.294 27
X2+ 13.8484250272
s 29.4753003943
7
Δb0 3.221 33
X2- 36.4150285018
M 44
DN-statistik 0.13
Δb1 1.160 33
Haare 90
Regressioonimudel y = 4,294x - 2,43 34
8
F-statistik 1.171 38
2
F-statistik 0.142
39
Δμ 10.0857526489
41
Alumine piir 39.6342473511
9
44
Ülemine piir 59.8057526489
Seerijate arv 7
46
σ al piir 572.5943616649
Pikima seeria pikkus 4
48
σ ül piir 1505.6614711847
Käänupunktid 9
52
56
3
10
59
t-statistik 0.0474973955
Korrelatsioonitegur 0.973 t-statistik 7.248
66
X2-statistik 26.0638
Determinatsioonitegur 0.946 z-statistik 3.024
83
88
97
98
98
99

Sheet 2: Ül4

Vahemik ni Pi
0-20 5 0.2
20-40 6 0.24
40-60 7 0.28
60-80 1 0.04
80-100 6 0.24
 SUM 25 1
Intervall xi- ni nixi- ni(xi-)2 (xi - x-)2 (xi - x-)2 * ni
Intervall ni pi xi ti Ф (ti) pi ni' X2 0-20 10 5 50 500 1577 .68 7888.39
0-20 5 0.2 0 -1.687 -0.453 0.109 2.720 1.912 20-40 30 6 180 5400 388.88 2333.27
20-40 6 0.24 20 -1.008 -0.344 0.214 5.361 0.076 40-60 50 7 350 17500 0.08 0.55
40-60 7 0.28 40 -0.330 -0.129 0.266 6.653 0.018 60-80 70 1 70 4900 411.28 411.28
60-80 1 0.04 60 0.349 0.137 0.212 5.292 3.480 80-100 90 6 540 48600 1622.48 9734.87
80-100 6 0.24 80 1.027 0.348 0.348 8.712 0.844 k = 5 ∑ 25 1190 76900 4000.39 20368.36
 ∑ 25 1 200 -1.649
6.331
λ ̂ 0.0201126307
a 0
χ²kr 4.61
b 100
Interval ni F0 pi ni' X2
0-20 5 0.2 0.2 5 0
20-40 6 0.4 0.2 5 0.2
40-60 7 0.6 0.2 5 0.8
60-80 1 0.8 0.2 5 3.2
80-100 6 1 0.2 5 0.2
 ∑ 25
25 4.4

Sheet 3: Ül5

Intervall xm ni (emp) ni (norm) ni (ühtl) f (norm) f (ühtl)
0
0.0032627035 0.01
0-20 20 5 2.720 5 0.0081411203 0.01
20-40 40 6 5.361 5 0.012818517 0.01
40-60 60 7 6.653 5 0.0127361581 0.01
60-80 80 1 5.292 5 0.0079852064 0.01
80-100 100 6 5.025 5 0.0031592275 0.01
∑
25 25.050 25

Sheet 4: Ül6

Empiiriline Ühtlane
0 9 0 0.09 2 11 0.08 0.11 3 12 0.12 0.12 4 15 0.16 0.15 5 17 0.2 0.17 6 27 0.24 0.27 7 33 0.28 0.33 8 33 0.32 0.33 9 34 0.36 0.34 10 38 0.4 0.38 11 39 0.44 0.39 12 41 0.48 0.41 13 44 0.52 0.44 14 46 0.56 0.46 15 48 0.6 0.48 16 52 0.64 0.52 17 56 0.68 0.56
18 59 0.72 0.59
19 66 0.76 0.66
20 83 0.8 0.83
21 88 0.84 0.88
22 97 0.88 0.97
23 98 0.92 0.98
24 98 0.96 0.98
25 99 1 0.99

Sheet 5: Ül7

Empiiriline Ühtlane Vahe 0 0.09 0.09 0.08 0.11 0.03 0.12 0.12 0 0.16 0.15 0.01 0.2 0.17 0.03 0.24 0.27 0.03 0.28 0.33 0.05 0.32 0.33 0.01 0.36 0.34 0.02 0.4 0.38 0.02 0.44 0.39 0.05 0.48 0.41 0.07 0.52 0.44 0.08 0.56 0.46 0.1 0.6 0.48 0.12 0.64 0.52 0.12 0.68 0.56 0.12 0.72 0.59 0.13 0.76 0.66 0.1 0.8 0.83 0.03 0.84 0.88 0.04 0.88 0.97 0.09 0.92 0.98 0.06 0.96 0.98 0.02 1 0.99 0.01 DN
0.13

Sheet 6: Ül8

i/r 1 2 3 4 5
1 15 52 56 12 38 34.6 -15.12 228.6144 333.44 2 34 27 88 98 33 56 6.28 39.4384 928.4 3 41 48 66 97 46 59.6 9.88 97.6144 421.04 4 33 98 59 44 39 54.6 4.88 23.8144 545.04 5 11 17 99 83 9 43.8 -5.92 35.0464 1517.76  ∑
248.6
424.528 3745.68
F-statistik 0.1416725401
y- 49.72
sA2 106.132
s02 749.136

Sheet 7: Ül9

Andmed Märgirida Käänupunktid
15 - K
52 +
56 + K
12 -
38 -
Xmed 44
34 -
27 - K
NS 9
88 +
98 + K
Lmax 4
33 -
41 - K
48 +
66 +
41 48 66 97 46 33 98 59 44 39 11 17 99 83 9 97 +
46 + K
33 - K
98 +
59 +
44
39 -
11 -
17 - K
99 +
83 + K
9 -

Sheet 8: Ül10

i xi yi xi - x̅ yi - y̅ (xi - x̅)*(yi - y̅) (xi - x̅)2 (yi - y̅)2
1 1.9 4.8 -1.06 -5.48 5.81 1.12 30.03
2 2.9 8.4 -0.06 -1.88 0.11 0.00 3.53
3 5.2 21.4 2.24 11.12 24.91 5.02 123.65
4 1.1 4.3 -1.86 -5.98 11.12 3.46 35.76
5 3.7 12.5 0.74 2.22 1.64 0.55 4.93
∑ 14.8 51.4
43.596 10.152 197.908
x̅ 2.96
y̅ 10.28
r 0.9726109717
t 7.2475422709
d 0.9459721022
z 3.0242750582

Sheet 9: Ül11

xi yi xi2 xiyi (xi - x̅)2
r yr yr - y0- (yr - y0-)2
1.9 4.8 3.61 9.12 1.12
1 2.9 0.829 0.687
2.9 8.4 8.41 24.36 0.00
2 0.7 -1.371 1.881
5.2 21.4 27.04 111.28 5.02
3 3.5 1.429 2.041
1.1 4.3 1.21 4.73 3.46
4 1.8 -0.271 0.074
3.7 12.5 13.69 46.25 0.55
5 4.2 2.129 4.531
∑
53.960 195.740 10.152
6 0.1 -1.971 3.887
7 1.3 -0.771 0.595
V(x) 10.152
∑ 14.5 0.000 13.694
x̅ 3
b1 4.2943262411
W 7
s2(b1) 0.2248208188
Δb1 1.1602517495
x 1 3 5
b0 -2.4312056738
y0- 2.0714285714
s2(b0) 1.7330473403
Δb0 3.2213594121
s(ŷ) 1.17 0.66 1.18
s2(y) 2.2823809524
Δŷ 2.86299 1.61502 2.88746
ŷ – Δŷ -0.9998694326 8.8367530496 16.1529655319
t1-α/2(W-1) 2.447
s2ad 2.6731382979
F-statistik 1.1712060141
ŷ 1.8631205674 10.4517730496 19.0404255319
ŷ + Δŷ 4.7261105674 12.0667930496 21.9278855319
Jrk
1 1.9 4.8 5.7280141844 -0.9280141844
2 2.9 8.4 10.0223404255 -1.6223404255 2.6319884563
3 5.2 21.4 19.8992907801 1.5007092199 2.2521281626
4 1.1 4.3 2.2925531915 2.0074468085 4.029842689
5 3.7 12.5 13.4578014184 -0.9578014184 0.9173835572
∑ 14.8 51.4 51.4 6.21724893790088E-015 10.6925531915