Rakendusstatistika arvutusgraafline töö 1 (excel) (1)

Overview

Sheet1
Ül 4
Ül 5
Ül 8
Ül 9
Ül 11
ül 9 õige
Sheet2

Sheet 1: Sheet1

ÜL 1 xi ni ni*xi
N 25
m ni (elemente) pi, tõenäosus Intervalli keskmine xi pi*xi pi*xi^2
0 1 2134.44
Keskväärtus 46.20
0-20 5 0.2 6.80 1.36 231.20
2 1 1953.64
Dispersioon 867.92 867.92
20-40 6 0.24 30.33 7.28 5,520.67
7 1 1536 .64
Standardhälve 29.46
40-60 6 0.24 47.17 11.32 13,348.17
10 1 1310.44
Mediaan 46
60-80 5 0.2 73.40 14.68 26,937.80
15 1 973.44
Haare 99
80-100 3 0.12 96.33 11.56 27,840.33
28 1 331.24
t- statistik
Kokku: 25 1
29 1 295.84
μ
30 1 262.44
31 1 231.04
t,alfa,n-1 1.7108820799
Normdist t F(t) Ф(t) Chi- square
32 2 201.64
20 -0.89 0.19 0.19 0.00092
32 2 201.64
ÜL 2
k = n-1 24
40 -0.21 0.42 0.23 0.00046
42 1 17.64
Usaldusvahemikkude arvutamine:
60 0.47 0.68 0.26 0.00211
46 1 0.04
80 1.15 0.87 0.19 0.00018
47 2 0.64
36.4150285018 36.4150285018
13.8484250272 13.8484250272
100 1.83 0.97 0.09 0.00872
47 2 0.64
Dispersiooni usaldusvahemikud:
48 1 3.24
σ_alumine^2 1,406.74
σ_ülemine^2 3,699.09
53 1 46.24
Expdist F(T) Ф(t) Chi-square
68 1 475.24
20
70 1 566.44
Keskväärtuse usaldusvahemikud:
40
75 2 829.44
Alumine piir
ülemine piir
60
75 2 829.44
40.9885803981
36.1193372122
45.857823584
80
79 1 1075 .84
100
94 1 2284.84
96 1 2480 .04
Ühtlane Ф(t)
99 1 2787.84
Summa: 1155 31 20830

Sheet 2: Ül 4

Ül 4 (II punkt)
k Xm ui ni φ(ui) pi ni' (ni-ni')^2/ni'
4..2 k x* ni Err:502
1 20 -0.89 5 0.1867 0.1867 4.6675 0.0236863953
1 20 5 Err:502 Err:502 Err:502 Err:502
2 40 -0.21 6 0.4168 0.2301 5.7525 0.010648631
2 40 6
#VALUE!
3 60 0.47 6 0.6808 0.2640 6.6000 0.0545454545
3 60 6
#VALUE! #VALUE!
4 80 1.15 5 0.8749 0.1941 4.8525 0.0044835137
4 80 5
#VALUE! #VALUE!
5 100 1.83 3 0.9664 0.0915 2.2875 0.2219262295
5 100 3
#VALUE! #VALUE!
Kokku
25 3.1256
24.16 0.315290224
Err:502 Err:502
χ²=0,315
2.7055439714
k xm ni F0 pi ni' (ni-ni')^2/n'i
1 20 5 0.2 0.2 5 0
2 40 6 0.4 0.2 5 0.2
3 60 6 0.6 0.2 5 0.2
4 80 5 0.8 0.2 5 0
5 100 3 1 0.2 5 0.8
kokku
25
25 1.2

Sheet 3: Ül 5

Vahemik Xm ni(emp) ni(norm) ni(eksp) ni(ühtl) f(norm) f(ühtl) f(eksp)
Lambda
0
0.0040 0.01
0.0216450216
0-20 20 5 5 9 5 0.0091 0.01 0.0140
20-40 40 6 6 6 5 0.0132 0.01 0.0091
40-60 60 6 7 4 5 0.0121 0.01 0.0059
60-80 80 5 3 2 5 0.0070 0.01 0.0038
80-100 100 3 5 2 5 0.0026 0.01 0.0025
kokku
25 26 23 25

Sheet 4: Ü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
F= #DIV/0!
Fkr= 2.9 4.26

Sheet 5: Ül 9

46
1 2 3 4 5 rühm kesk rühm disp (yi-y̅)^2 üld kesk üld rühm disp rühmade vaheline disp 29
1.-5. 46 29 31 79 75 60.5 420.5 204.49
31
6.-10. 94 32 32 10 99 53.4 1631.8 51.84
79
11.-15. 48 70 96 0 47 52.2 1251.2 36
75
16.-20. 28 68 30 47 15 37.6 418.3 73.96
94
21.-25. 7 75 53 42 2 35.8 960.7 108.16
32
kokku:
239.5 4682.5 474.45
32
10
99
2926.5625
48
70
96
0
118.6125
47
28
68
F= 0.0405296316
30
47
15
Fkr= 2.9
7
75
53
42
2
1.-5.
6.-10.
11.-15.
16.-20.
21.-25.
kokku:

Sheet 6: Ül 11

Ül 11.3
Ül 11.1
xi yi
(xi-x̅)^2
b0 -3.0871571615 -3.0871571615
1.2 1.3
3.534
4.3 4.6
1.488
b1 2.0282977797 2.420385 2.0282977797
4.9 8.8
3.312
ÜL 11.4
2.8 0.7
0.078
y = See on -3,09+2,03
d
2.2 0.4
0.774
Keskmine 3.08 3.16 Kokku 9.188
s²ad 4.4042141924
F 2.1208094025
2.0282977797
F kr 3.6 4.76
Ül 11.2
r
s²(b0) 2.5594442026
7.1
s²(b1) 0.2260194457
3.6
∆b1 3.9147749656
5.6
∆b0 1.1633405653
ül 9.5
6.4 b0 usaldusvahem. -5.6466013641 ≤ β0 ≤ -1.9238165962 = 0.95
4.8 b1 usaldusvahem. -1.8864771859 ≤ β1 ≤ 5.9430727453 = 0.95
Punktis x=1
3.2
s(y) 1.1803320986
4.3
∆y 2.8882726453
y̅0 5
s²(y) 2.07667
P 3.0117273547 ≤ μ(yI1) ≤ 8.7882726453 = 0.95
Punktis x=3
s(y) 0.6455848959
∆y 1.5797462402
P 12.2402537598 ≤ μ(yI3) ≤ 15.3997462402 = 0.95
Punktis x=5
s(y) 1.1173770258
∆y 2.7342215821
P 19.0057784179 ≤ μ(yI5) ≤ 24.4742215821 = 0.95
ül 9.6
-1 0 1 3 5
-2.02 1.94 5.8995 13.819875 21.74
-5.1154549412 -3.0871571615 -1.0588593818 2.9977361776 7.054331737
3.011 12.24 19.006
8.788 15.39975 24.474

Sheet 7: ül 9 õige

Lähterida Märgirida Käänupunktid Järjestatud rida
32 - k 0
46
75 +
2
53 + k 7
42 - k 10
94 + k 15
Käänupunkte 7 -
28
15 0 - k 29
47 + k 30
30 -
31
31 - k 32
96 + k 32
2 - k 42
70 + k 46
28 -
47
10 -
47
29 -
48
15 - k 53
99 + k 68
32 - k 70
47 +
75
68 +
75
48 + k 79
46 - k 94
75 +
96
79 +
99

Sheet 8: Sheet2

ÜL 10.
i 1 2 3 4 5
i x y x-xkesk y-ykesk (x-xkesk)^2 (y-ykesk)^2 (x-xkesk)(y-ykesk)
xi 1.2 4.3 4.9 2.8 2.2
1 1.2 1.3 -1.88 -1.86 3.5344 3.4596 3. 4968
yi 1.3 4.6 8.8 0.7 0.4
2 4.3 4.6 1.22 1.44 1.4884 2.0736 1.7568
3 4.9 8.8 1.82 5.64 3.3124 31.8096 10.2648
4 2.8 0.7 -0.28 -2.46 0.0784 6.0516 0.6888
5 2.2 0.4 -0.88 -2.76 0.7744 7.6176 2.4288
keskväärtused 3.08 3.16
kokku: 18.636
Korrelatsioon
0.8608074817