Vajad kellegagi rääkida?
Küsi julgelt abi LasteAbi
Logi sisse

Ökonomeetria Labor 8 VIF(2011) (1)

5 VÄGA HEA
Punktid

Lõik failist

Overview

Juhend
Andmed

Sheet 1: Juhend


Labor 8 Multikollineaarsuse kindlakstegemine - VIFj
MS.0151 Ökonomeetria 2011


Sõltumatute muutujate vahel esineva multikollineaarsuse kindlasktegemiseks
leitakse varieeruvusindeks ehk dispersiooni mõju faktor VIFj (Variance Inflationary Factor ).


Varieeruvusindeks näitab argumendi mõju regressiooniparameetri hajuvusele.





kus Rj2 on determinatsioonikordaja , mis on leitud sõltumatu muutuja Xj
(R2 leidmiseks teostada regressioonanalüüs, kus sõltuvaks muutujaks Y on uuritav Xj)
ja ülejäänud sõltumatute muutujate Xj vahel.


Kui VIFj > 10, siis tuleb selline sõltumatu muutuja Xj eemaldada.




Ülesanne


Sõltumatute muutujate vahel esineva multikollineaarsuse kindlakstegemiseks
leida varieeruvusindeks VIFj.
Andmed on esitatud töölehel nimega "andmed".


Selleks:
1. Koostada korrelatsioonimaatriks ,et hinnata sõltumatute muutujate vahel esinevat korrelatsiooni.
Kasutada MS Exceli protseduuri Andmed/DataAnalysis/Correlation.


























































2. Teostada regressioonanalüüsid (Y-ks on kordamööda kõik X-d) ja arvutada varieeruvusindeksi VIFj väärtused.


1) sõltuvaks muutujaks Y on X1 ja sõltumatuteks muutujateks X2...X10;



























2) sõltuvaks muutujaks Y on X2 ja sõltumatuteks muutujateks X1 ja X3...X10;































3) teostada regressioonid nii, et kõik Xj oleksid sõltuvaks muutujaks Y.
X3....X10.


















4) teostada regressioon (esialgne Y sõltuv muutuja, X-d sõltumatud muutujad)


















3. Arvutada varieeruvusindeks VIFj kõikide muutujate jaoks.









4. Kopeerida erinevate regressioonide tabelitest R2 ja F.
















5. Korrigeerida andmestikku ja teostada uus regressioon.

Sheet 2: Andmed


Piimatoodang lehma kohta Piima omahind Töökulu Toetused kokku Töötasu piima tootmisel Müügiosakaal (looma-kasvatus) Söödakulu Lehmade arv
Söödakulu Töökulu Töötasu piima tootmisel

jrk
ts/lehma kohta €/kg tundi/ts €/ha €/tunnis % €/lehma kohta 100 ha põllumaa kohta
€/ts tundi/lehma kohta €/lehma kohta
Piimatoodang lehma kohta Piima omahind Töökulu Söödakulu Toetused kokku Töötasu piima tootmisel Töötasu piima tootmisel Töökulu Müügiosakaal (looma-kasvatus) Söödakulu Lehmade arv
X1 X2 X3 X5 X6 X9 X10 Y9
X4 X8 X7

ts/lehma kohta €/kg tundi/ts €/ts €/ha €/tunnis €/lehma kohta tundi/lehma kohta % €/lehma kohta 100 ha põllumaa kohta
1
43.2 0.12 1.1 55.2 1.20 29.7 253.7 21.4
5.87 47.7 57.07
X1 1

2
35.5 0.25 7.0 29.6 1.20 67.5 353.4 13.7
9.94 247.8 296.68
X2 -0.1391791975 1

3
39.2 0.15 7.4 29.6 0.75 98.7 203.6 29.4
5.19 289.2 215.78
X3 -0.4222066441 0.5434188307 1

4
40.6 0.17 4.6 35.2 1.44 85.5 235.0 39.8
5.79 186.4 269.12
X4 0.0013488465 0.5878733876 -0.0993015359 1

5
44.8 0.27 8.1 35.5 1.18 95.2 290.0 24.0
6.47 361.3 425.73
X5 0.1275914921 0.0676666314 -0.1016130236 0.1603071287 1
6
0.00 0.19 3.5 31.2 1.46 69.8 476.9 23.9
8.89 185.9 271.33
X6 0.1297701931 0.2883282359 0.0375373295 -0.0847449921 0.0231518932 1
7
41.0 0.17 4.9 29.3 1.29 77.0 203.0 29.4
4.95 201.5 259.46
X7 0.0378562957 0.5862172753 0.6532371054 -0.1217261551 -0.0376274531 0.6533459993 1
8
38.2 0.19 2.6 32.5 1.05 31.2 275.3 10.1
7.20 100.7 106.15
X8 -0.054021385 0.5477696329 0.8913466403 -0.1030934874 -0.0645528974 0.1268688462 0.7972302565 1
9
41.1 0.23 7.5 44.8 1.33 74.6 201.3 32.2
4.89 309.6 412.44
X9 -0.0324349844 0.3231260668 0.5608681031 -0.2101189342 -0.0214548264 0.2523123742 0.5325957862 0.5897156428 1
10
53.8 0.25 5.7 42.2 1.73 66.8 371.0 21.1
6.90 304.1 525.29
X10 0.4741036953 0.4035155633 -0.2892181012 0.8414832023 0.1944927189 -0.0184017038 -0.073143699 -0.0886907807 -0.1713863056 1
12
46.4 0.31 8.5 48.7 1.43 74.0 473.3 25.6
10.21 392.5 560.69
Y9 -0.0621608954 -0.045391323 0.237548335 -0.3991149782 0.1746583098 0.3469699545 0.3240953387 0.2144484997 0.7339371431 -0.3590187617 1 10X+Y
13
40.5 0.18 5.7 41.2 0.67 97.6 235.3 35.7
5.82 232.1 154.44
R^2 0.8090315055 0.859 0.953 0.954 0.047 0.867 0.956 0.971 0.470 0.949
0.7714577544
14
44.8 0.18 5.9 31.0 1.23 76.8 183.5 20.8
4.10 262.8 322.79
VIF 5.2364658507 7.072 21.354 21.609 1.049 7.524 22.972 33.964 1.887 19.467
4.3755586514 KUI VIF ON SUUREM KUI 10 SIS SÕLTUMATU MUUTUJAGA ON SEOTUD 1 SOLTUV MUUTUJA 15
44.2 0.19 6.4 31.6 1.36 93.1 202.5 30.1
4.58 284.0 386.31
TOL 0.1909684945 0.141 0.047 0.046 0.953 0.133 0.044 0.029 0.530 0.051
0.2285422456
16
34.9 0.12 2.4 39.1 0.93 33.4 195.2 19.9
5.60 83.7 78.05
x1 SUMMARY OUTPUT

17
34.4 0.10 1.7 46.6 1.00 19.2 102.2 13.4
2.97 58.9 58.65
Regression Statistics
0.764817596
18
46.8 0.11 2.1 32.0 0.75 30.4 281.1 8.1
6.00 97.8 73.47
Multiple R 0.8994617866

19
51.4 0.20 4.5 28.3 0.77 57.7 499.0 8.4
9.72 231.0 177.13
R Square 0.8090315055

20
45.7 0.11 5.1 43.5 0.73 93.3 102.3 34.8
2.24 231.7 170.01
Adjusted R Square 0.7963002725

21
55.2 0.21 3.7 44.2 1.92 62.0 374.0 29.5
6.78 203.6 391.57
Standard Error 5.684885887

22
50.1 0.24 2.6 35.2 0.77 67.4 593.6 20.0
11.84 128.9 98.85
Observations 145

23
61.2 0.19 4.2 43.7 0.77 62.3 532.2 21.7
8.70 254.5 195.21

24
45.4 0.18 2.5 37.8 0.83 61.3 417.6 13.8
9.21 112.8 93.52
ANOVA

25
47.6 0.13 1.4 27.0 0.97 17.1 354.2 16.2
7.44 66.0 63.77

df SS MS F Significance F
26
48.3 0.12 1.3 27.4 0.74 37.8 309.8 22.2
6.42 60.5 44.59
Regression 9 18483.3625172088 2053.7069463565 63.5469877603 3.42499675126927E-044
27
40.9 0.14 8.2 24.7 0.62 93.9 116.3 24.8
2.84 334.2 207.83
Residual 135 4362.9202190334 32.3179275484

28
44.4 0.18 4.6 36.2 1.61 87.2 214.1 39.2
4.83 202.2 324.56
Total 144 22846.2827362421

29
48.3 0.31 7.0 29.9 1.47 96.6 346.0 23.2
7.16 338.7 496.43

30
59.7 0.17 3.0 28.8 1.90 75.4 315.6 23.5
5.29 177.1 335.73

Coefficients Standard Error t Stat P- value Lower 95% Upper 95% Lower 95,0% Upper 95,0%
31
48.2 0.16 4.5 34.4 1.39 83.4 132.9 29.7
2.76 217.3 302.78
Intercept 45.2325050445 4.5122271955 10.0244298625 5.08419406621875E-018 36.3087082967 54.1563017923 36.3087082967 54.1563017923
32
41.0 0.23 6.6 33.1 1.42 79.2 175.5 29.0
4.28 272.2 386.68
X2 54.0929506547 23.6488063569 2.2873438024 0.023730954 7.3228896374 100.863011672 7.3228896374 100.863011672
33
46.9 0.13 1.9 29.2 1.69 98.0 221.8 43.4
4.73 89.6 151.44
X3 -5.1644389493 1.0898051827 -4.7388643688 5.3785348909698E-006 -7.3197382115 -3.0091396872 -7.3197382115 -3.0091396872
34
63.6 0.22 4.4 33.5 2.02 62.1 387.4 22.4
6.09 282.5 571.51
X4 -4.5777656267 0.5803114144 -7.8884638711 9.26838310226528E-013 -5.7254430127 -3.4300882407 -5.7254430127 -3.4300882407
36
49.1 0.29 7.3 41.5 1.53 66.3 265.7 22.7
5.42 356.2 544.36
X5 0.0246916715 0.0390769079 0.6318737289 0.5285379712 -0.0525904263 0.1019737693 -0.0525904263 0.1019737693
37
41.8 0.20 5.6 32.9 0.89 94.3 167.2 26.9
4.00 232.5 207.11
X6 3.1692997668 3.0187454903 1.0498731267 0.2956522493 -2.8008497896 9.1394493231 -2.8008497896 9.1394493231
38
48.8 0.19 6.0 30.2 1.70 99.7 187.9 29.2
3.85 291.6 495.03
X7 -0.0222620634 0.0148386235 -1.5002782034 0.1358774574 -0.051608294 0.0070841673 -0.051608294 0.0070841673
39
51.0 0.16 4.9 26.2 1.30 100.0 65.9 29.5
1.29 249.3 324.76
X8 0.1071302706 0.0323693768 3.3096179483 0.0011981596 0.0431136049 0.1711469362 0.0431136049 0.1711469362
40
49.8 0.17 1.7 20.7 1.05 18.7 512.4 7.1
10.28 85.2 89.02
X9 -0.0065514878 0.0252563988 -0.2593991287 0.7957224487 -0.0565008719 0.0433978962 -0.0565008719 0.0433978962
41
42.0 0.15 1.6 29.9 1.29 28.0 197.1 15.7
4.69 67.3 86.87
X10 0.0784736888 0.0089628452 8.7554439678 7.38426601019089E-015 0.0607479394 0.0961994383 0.0607479394 0.0961994383
42
59.4 0.15 1.6 25.4 1.42 9.5 435.8 4.2
7.34 96.5 136.66

43
43.0 0.19 1.8 28.7 1.01 24.8 329.1 9.5
7.65 77.9 78.31

44
48.7 0.13 4.0 32.9 1.06 98.5 133.8 33.0
2.75 194.8 207.22

45
85.9 0.20 1.5 26.8 1.05 59.9 962.4 18.9
11.20 131.7 138.23

46
50.5 0.21 5.1 35.7 1.40 72.4 244.3 25.1
4.83 257.1 360.64

47
55.2 0.18 4.1 33.6 0.88 92.3 238.1 36.8
4.31 224.2 196.76
x2 SUMMARY OUTPUT

48
64.8 0.15 2.7 36.4 1.59 95.4 200.6 29.4
3.09 175.9 280.20

49
60.1 0.11 2.8 15.1 0.89 22.7 278.5 7.2
4.63 168.0 150.35
Regression Statistics

50
54.7 0.13 0.7 33.0 1.02 47.5 256.0 16.3
4.68 36.5 37.32
Multiple R 0.9266044664

51
58.3 0.16 1.7 31.9 1.08 21.2 485.6 9.9
8.32 100.1 107.76
R Square 0.8585958371

52
47.6 0.13 1.3 40.4 1.16 20.9 352.2 25.6
7.39 61.4 71.59
Adjusted R Square 0.8491688929

53
69.9 0.12 1.1 35.8 1.11 63.3 341.2 30.1
4.88 78.2 86.65
Standard Error 0.0202996735

54
52.4 0.13 2.0 42.8 1.39 53.5 217.1 26.0
4.14 104.9 146.10
Observations 145

55
49.8 0.19 4.2 37.7 1.90 93.1 247.3 39.8
4.96 208.8 397.52

56
65.0 0.22 3.9 37.4 1.02 48.2 468.2 10.0
7.20 254.2 259.89
ANOVA

57
64.0 0.19 2.9 26.7 1.53 81.9 378.9 15.6
5.92 187.5 286.28

df SS MS F Significance F
58
60.6 0.25 5.2 31.2 1.65 93.3 349.7 22.9
5.77 317.9 523.74
Regression 9 0.3377835199 0.0375315022 91.0789137269 6.52730234849499E-053
59
40.3 0.18 6.0 28.8 1.31 94.3 129.5 32.0
3.21 243.9 320.68
Residual 135 0.0556303604 0.0004120767

60
53.4 0.18 4.4 38.4 1.66 92.0 253.9 37.4
4.76 237.3 394.39
Total 144 0.3934138803

61
55.4 0.24 5.3 28.3 1.80 87.0 227.0 25.9
4.10 295.3 531.16

62
52.4 0.18 2.0 28.6 2.41 100.0 208.7 38.4
3.99 107.1 257.62

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0%
63
74.0 0.24 4.0 29.5 2.41 67.7 355.1 23.2
4.80 299.0 721.57
Intercept 0.0146598625 0.0212428199 0.6901090604 0.491310287 -0.0273518978 0.0566716228 -0.0273518978 0.0566716228
65
51.2 0.27 6.6 36.5 1.90 62.4 311.3 24.6
6.08 338.1 642.77
X1 0.0006897239 0.0003015392 2.2873438024 0.023730954 9.3372092425596E-005 0.0012860757 9.3372092425596E-005 0.0012860757
66
48.7 0.21 4.7 34.7 1.79 98.2 212.7 43.0
4.37 230.4 413.38
X3 0.0090143618 0.0041304849 2.1823979487 0.0308100679 0.0008455338 0.0171831897 0.0008455338 0.0171831897
67
56.2 0.19 6.1 36.3 1.24 87.7 291.0 29.1
5.17 340.9 422.65
X4 0.0172070597 0.0020199072 8.5187378166 2.80245534420302E-014 0.0132123049 0.0212018144 0.0132123049 0.0212018144
68
52.7 0.20 5.4 30.7 1.88 99.3 205.8 29.6
3.90 287.0 538.94
X5 2.97872664514421E-005 0.0001397191 0.2131940042 0.8314972596 -0.000246534 0.0003061086 -0.000246534 0.0003061086
69
57.6 0.17 4.2 30.2 1.71 99.2 184.1 34.7
3.20 243.5 415.62
X6 -0.0097636761 0.0107906254 -0.90482949 0.3671676581 -0.0311042123 0.0115768601 -0.0311042123 0.0115768601
70
51.9 0.21 3.6 13.3 1.02 48.0 599.7 7.1
11.55 185.6 189.82
X7 0.000219148 4.99857552333331E-005 4.3842083222 2.32252523253399E-005 0.0001202915 0.0003180044 0.0001202915 0.0003180044
71
53.5 0.13 3.1 21.7 1.02 30.9 364.4 10.5
6.82 163.3 166.95
X8 -0.0001387867 0.0001195877 -1.1605432664 0.2478758485 -0.0003752943 9.77209487640894E-005 -0.0003752943 9.77209487640894E-005
72
50.2 0.18 2.6 27.8 1.25 42.4 144.6 14.9
2.88 132.6 165.69
X9 0.0002139802 8.83084760855795E-005 2.4230986939 0.0167141627 3.93331644329179E-005 0.0003886271 3.93331644329179E-005 0.0003886271
73
70.3 0.15 1.5 32.1 1.32 28.9 446.9 9.8
6.36 108.1 143.16
X10 -0.0001150067 3.88324177700115E-005 -2.9616160247 0.0036169697 -0.0001918053 -3.82081391309778E-005 -0.0001918053 -3.82081391309778E-005
74
50.7 0.20 3.1 22.7 1.02 51.2 425.8 8.8
8.40 158.5 162.12

75
49.4 0.17 2.5 35.3 1.01 30.9 318.3 7.7
6.44 122.0 123.58

76
34.7 0.24 7.9 31.9 1.12 99.9 201.6 33.9
5.80 274.7 306.63
X3 SUMMARY OUTPUT

77
39.6 0.27 3.0 27.3 1.18 52.7 659.2 15.9
16.63 118.8 139.99

78
59.3 0.21 3.7 36.5 1.22 90.4 361.4 35.9
6.09 221.0 268.77
Regression Statistics

79
70.2 0.17 2.2 34.3 1.87 83.6 348.4 26.8
4.96 155.5 291.08
Multiple R 0.9763041123

80
63.0 0.15 1.6 40.0 1.66 42.0 314.6 19.9
4.99 103.3 171.53
R Square 0.9531697197

81
65.2 0.15 2.5 23.2 0.84 29.3 350.0 8.8
5.37 163.6 138.12
Adjusted R Square 0.950047701

82
34.5 0.30 4.7 45.3 1.16 53.1 438.3 8.6
12.69 161.6 187.19
Standard Error 0.4157115808

83
52.0 0.15 3.3 50.1 0.75 72.5 110.7 30.2
2.13 172.4 129.65
Observations 145

84
61.0 0.16 2.9 21.1 0.73 62.0 270.8 19.8
4.44 178.0 129.38

85
69.0 0.14 1.5 31.4 1.00 45.0 324.9 21.5
4.71 100.8 100.60
ANOVA

86
56.9 0.15 3.3 78.5 1.02 35.6 262.4 18.9
4.61 186.1 190.31

df SS MS F Significance F
87
64.0 0.20 4.5 22.7 1.02 50.1 445.2 11.5
6.96 286.8 293.27
Regression 9 474.855523922 52.7617248802 305.3055778403 3.76146269554784E-085
88
56.6 0.11 1.2 42.6 1.31 27.0 295.8 26.0
5.23 67.4 88.21
Residual 135 23.3301759805 0.1728161184

89
62.0 0.14 1.7 48.5 1.55 40.8 326.6 30.4
5.27 108.1 167.54
Total 144 498.1856999025

90
32.9 0.28 8.0 33.2 1.48 87.8 282.2 20.9
8.59 261.8 388.38

91
38.1 0.32 5.2 69.5 1.68 96.8 622.6 42.7
16.33 196.9 330.48

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0%
92
64.6 0.20 1.4 28.6 2.48 42.4 618.7 12.9
9.58 90.9 225.52
Intercept 0.726002576 0.4312898925 1.683328519 0.0946226373 -0.1269561012 1.5789612532 -0.1269561012 1.5789612532
93
44.1 0.22 5.9 48.5 1.52 99.2 193.8 31.4
4.40 259.5 393.64
X1 -0.0276161982 0.0058275984 -4.7388643688 5.37853489097014E-006 -0.0391413943 -0.0160910021 -0.0391413943 -0.0160910021
94
57.3 0.19 3.2 47.1 2.01 82.4 341.0 30.7
5.95 181.2 363.32
X2 3.7804293343 1.7322364771 2.1823979487 0.0308100679 0.3545986811 7.2062599875 0.3545986811 7.2062599875
95
57.4 0.26 4.8 39.6 2.05 85.9 404.1 26.1
7.04 274.6 563.88
X4 0.1297592949 0.0500613257 2.5920067649 0.0105919348 0.0307533991 0.2287651907 0.0307533991 0.2287651907
96
55.7 0.19 2.0 50.3 2.44 100.0 328.4 46.4
5.89 111.7 272.33
X5 0.0001711265 0.002861713 0.059798629 0.9524044485 -0.0054884611 0.0058307142 -0.0054884611 0.0058307142
97
81.8 0.32 4.0 49.7 2.83 80.0 840.7 24.1
10.28 323.4 913.74
X6 0.3719552641 0.2193233763 1.6959216585 0.0922056432 -0.0617988771 0.8057094052 -0.0617988771 0.8057094052
99
50.2 0.20 4.4 44.4 2.01 99.9 237.6 38.4
4.74 222.4 447.57
X7 -0.0033752555 0.001054824 -3.1998280462 0.0017141426 -0.0054613728 -0.0012891382 -0.0054613728 -0.0012891382
100
58.1 0.22 5.0 50.4 1.41 79.3 455.0 30.6
7.83 290.0 409.75
X8 0.0226281069 0.00150487 15.0365859783 1.24028537387653E-030 0.0196519372 0.0256042766 0.0196519372 0.0256042766
101
58.6 0.21 3.3 43.5 2.32 97.2 163.8 38.2
2.80 195.9 455.39
X9 0.0031018913 0.0018279614 1.6969129194 0.0920175392 -0.0005132538 0.0067170363 -0.0005132538 0.0067170363
102
52.5 0.28 3.8 40.0 1.14 90.9 741.4 23.2
14.11 201.1 229.56
X10 -0.0035017745 0.0007633218 -4.5875468552 1.01314147765475E-005 -0.0050113901 -0.0019921589 -0.0050113901 -0.0019921589
103
38.7 0.28 6.8 42.5 1.91 98.5 206.8 24.6
5.34 264.6 504.30

104
63.3 0.22 4.2 38.8 1.15 41.3 674.8 9.9
10.67 268.6 308.95

105
45.9 0.17 2.3 32.0 1.14 25.5 541.4 10.4
11.79 107.7 123.11
X4 SUMMARY OUTPUT

106
58.3 0.17 3.8 14.9 1.15 55.7 372.2 16.5
6.39 218.9 251.87

107
52.9 0.16 3.2 60.9 0.70 50.0 345.6 28.6
6.53 168.4 117.07
Regression Statistics

108
76.6 0.22 3.5 45.5 1.15 100.0 741.5 21.7
9.68 265.5 305.45
Multiple R 0.9765878678

109
55.6 0.16 1.8 52.2 1.69 37.7 519.1 23.8
9.33 100.3 169.14
R Square 0.9537238635

110
68.2 0.16 0.9 45.1 1.31 23.1 691.2 11.3
10.14 60.7 79.25
Adjusted R Square 0.9506387877

111
63.6 0.17 2.1 55.4 1.27 69.5 537.6 21.8
8.46 134.6 170.37
Standard Error 0.697551866

112
53.5 0.26 3.8 39.7 0.87 81.7 600.4 17.5
11.22 203.6 176.72
Observations 145

113
77.6 0.22 3.3 34.1 1.15 92.2 739.3 27.0
9.53 257.5 296.19

114
55.7 0.19 2.7 38.4 1.75 41.0 370.9 13.1
6.66 150.7 264.00
ANOVA

115
53.7 0.23 2.9 37.4 1.33 54.1 702.3 19.0
13.08 156.8 207.82

df SS MS F Significance F
116
46.8 0.28 5.8 46.3 1.15 61.7 556.5 11.4
11.89 271.3 312.11
Regression 9 1353.7932174997 150.4214686111 309.1411477029 1.68761876646198E-085
117
59.5 0.24 3.8 54.7 1.40 90.4 542.4 37.8
9.11 224.1 313.95
Residual 135 65.6881117683 0.4865786057

118
68.7 0.20 2.0 51.5 1.94 66.5 654.2 25.0
9.52 140.3 271.55
Total 144 1419.4813292681

119
55.3 0.26 5.0 65.0 1.15 21.2 705.0 2.7
12.76 278.0 319.81

120
32.2 0.35 5.5 28.0 1.30 57.8 485.4 17.6
15.08 175.8 228.20

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0%
121
55.8 0.25 4.5 27.8 1.15 47.8 448.0 5.5
8.03 253.9 292.08
Intercept 3.1058633727 0.680637937 4.5631652368 1.12056650274301E-005 1.7597710008 4.4519557447 1.7597710008 4.4519557447
122
80.2 0.17 2.4 50.2 0.66 100.0 749.1 32.3
9.34 194.4 128.68
X1 -0.0689228235 0.0087371667 -7.8884638711 9.26838310226555E-013 -0.0862022502 -0.0516433967 -0.0862022502 -0.0516433967
123
71.5 0.16 1.3 45.0 2.22 31.6 526.1 16.6
7.36 92.8 206.19
X2 20.3180286601 2.3850984849 8.5187378166 2.80245534420294E-014 15.6010378746 25.0350194456 15.6010378746 25.0350194456
124
34.7 0.30 2.6 61.7 1.49 43.0 574.5 7.8
16.57 90.8 135.35
X3 0.3653484257 0.1409519569 2.5920067649 0.0105919348 0.0865888332 0.6441080182 0.0865888332 0.6441080182
125
54.9 0.16 1.9 40.8 1.07 66.5 455.1 28.8
8.29 105.4 112.68
X5 0.00125624 0.0048007169 0.2616775837 0.7939688479 -0.0082381006 0.0107505806 -0.0082381006 0.0107505806
126
44.9 0.18 3.8 34.1 0.75 51.0 287.4 13.4
6.40 169.1 126.19
X6 0.0638116485 0.371877274 0.1715932997 0.8640142211 -0.6716471536 0.7992704506 -0.6716471536 0.7992704506
127
49.0 0.21 3.7 94.6 0.69 40.9 376.7 13.4
7.69 181.5 125.80
X7 -0.0030376069 0.0018171473 -1.6716349147 0.0969127124 -0.0066313651 0.0005561513 -0.0066313651 0.0005561513
128
59.8 0.15 2.4 64.6 1.06 49.7 336.3 18.7
5.62 142.5 150.99
X8 -0.0099845962 0.0040394097 -2.4717958522 0.0146877292 -0.0179733054 -0.0019958869 -0.0179733054 -0.0019958869
129
41.1 0.21 4.2 34.0 0.99 53.0 421.2 14.6
10.25 174.0 172.48
X9 -0.0090098913 0.0030012451 -3.0020511958 0.00319581 -0.0149454304 -0.0030743522 -0.0149454304 -0.0030743522
130
66.5 0.15 1.7 50.3 1.15 50.2 369.7 34.5
5.56 114.1 131.18
X10 0.0143510764 0.0006088484 23.5708522872 1.078460801055E-049 0.0131469616 0.0155551913 0.0131469616 0.0155551913
131
82.5 0.20 2.5 35.5 1.15 53.7 592.9 18.1
7.19 206.2 237.26

132
64.6 0.18 2.1 52.7 1.33 72.6 440.4 37.5
6.81 138.7 184.16

133
48.6 0.16 7.2 42.8 0.82 100.0 215.8 25.0
4.44 350.4 285.65

134
57.7 0.29 5.5 35.1 1.15 56.0 801.1 11.6
13.88 317.5 365.31
X5 SUMMARY OUTPUT

135
49.2 0.23 4.3 48.5 1.59 56.2 421.7 21.8
8.56 213.2 338.10

136
41.1 0.25 6.7 26.3 1.56 98.4 240.3 30.8
5.85 277.3 433.65
Regression Statistics

138
52.3 0.22 3.6 34.2 1.75 61.8 519.8 20.0
9.94 189.9 333.20
Multiple R 0.2165655321

139
52.1 0.31 1.8 36.1 1.19 75.1 763.1 16.4
14.64 95.3 113.04
R Square 0.0469006297

140
77.1 0.20 3.5 42.4 1.15 78.0 561.6 16.2
7.29 273.4 314.56
Adjusted R Square -0.0166393283

141
71.1 0.16 1.7 45.3 1.17 63.3 432.2 24.1
6.08 124.0 145.41
Standard Error 12.5024005356

142
77.7 0.16 1.4 31.8 1.47 46.3 589.1 10.8
7.58 108.1 159.15
Observations 145

143
86.4 0.17 2.1 39.9 0.88 99.8 545.4 22.0
6.31 182.9 160.37

144
57.5 0.13 2.5 69.3 0.84 28.5 315.0 15.6
5.48 143.9 121.50
ANOVA

145
63.9 0.20 3.8 45.9 1.15 49.5 478.8 10.8
7.49 243.2 279.83

df SS MS F Significance F
146
56.2 0.13 1.1 53.5 1.51 28.3 381.9 22.7
6.80 61.8 93.08
Regression 9 1038.3913839659 115.3768204407 0.7381281192 0.6733809271
147
84.7 0.17 1.5 82.4 1.24 84.1 800.8 28.4
9.45 124.0 153.46
Residual 135 21101.8525854341 156.3100191514

148
50.0 0.19 2.8 40.7 1.06 68.8 518.4 21.6
10.37 142.0 150.39
Total 144 22140.2439694

149
67.9 0.25 3.6 43.3 1.15 99.3 924.5 21.6
13.62 243.8 280.45

150
54.0 0.19 2.3 36.9 1.20 69.9 524.2 23.8
9.71 123.1 147.65

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0%


Intercept 25.8667817233 12.9158723698 2.0027127075 0.0472109186 0.3231610555 51.4104023911 0.3231610555 51.4104023911


X1 0.1194246022 0.1890007398 0.6318737289 0.5285379712 -0.2543606959 0.4932099003 -0.2543606959 0.4932099003


X2 11.2989831576 52.9985972056 0.2131940042 0.8314972596 -93.5159317151 116.1138980304 -93.5159317151 116.1138980304


X3 0.154781794 2.5883836573 0.059798629 0.9524044485 -4.9642445011 5.273808089 -4.9642445011 5.273808089


X4 0.4035584318 1.5421971808 0.2616775837 0.7939688479 -2.6464329782 3.4535498419 -2.6464329782 3.4535498419


X6 1.1828705118 6.6652008877 0.1774695965 0.8594055458 -11.9988456181 14.3645866418 -11.9988456181 14.3645866418


X7 -0.0052260036 0.0329014704 -0.1588379964 0.8740338843 -0.0702949865 0.0598429793 -0.0702949865 0.0598429793


X8 -0.011234644 0.0740132399 -0.1517923559 0.8795773184 -0.1576100548 0.1351407667 -0.1576100548 0.1351407667


X9 0.0237564061 0.0555209642 0.4278817278 0.6694190319 -0.0860469744 0.1335597865 -0.0860469744 0.1335597865


X10 0.0024252878 0.0246804045 0.098267749 0.9218654425 -0.0463849569 0.0512355325 -0.0463849569 0.0512355325













X6 SUMMARY OUTPUT







Regression Statistics



Multiple R 0.9311823957



R Square 0.8671006541



Adjusted R Square 0.8582406978



Standard Error 0.1614219636



Observations 145







ANOVA




df SS MS F Significance F


Regression 9 22.9512155082 2.5501350565 97.8673727015 1.02578351628441E-054


Residual 135 3.517701795 0.0260570503



Total 144 26.4689173032








Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0%


Intercept 1.1140605663 0.1394334285 7.9899101541 5.30803608236735E-013 0.8383041556 1.3898169771 0.8383041556 1.3898169771


X1 0.0025553187 0.0024339309 1.0498731267 0.2956522493 -0.0022582477 0.007368885 -0.0022582477 0.007368885


X2 -0.6173913053 0.6823288941 -0.90482949 0.3671676581 -1.96682787 0.7320452595 -1.96682787 0.7320452595


X3 0.0560830617 0.0330693705 1.6959216585 0.0922056432 -0.009317976 0.1214840995 -0.009317976 0.1214840995


X4 0.0034172142 0.0199146135 0.1715932997 0.8640142211 -0.0359677624 0.0428021909 -0.0359677624 0.0428021909


X5 0.0001971858 0.0011110962 0.1774695965 0.8594055458 -0.0020002206 0.0023945922 -0.0020002206 0.0023945922


X7 0.0043771195 0.0001963898 22.2879139396 4.44619726020504E-047 0.0039887209 0.0047655181 0.0039887209 0.0047655181


X8 -0.0070365838 0.0007393044 -9.5178441621 9.50624600076826E-017 -0.0084987003 -0.0055744672 -0.0084987003 -0.0055744672


X9 0.0020558566 0.0006951677 2.9573532898 0.003664223 0.0006810287 0.0034306844 0.0006810287 0.0034306844


X10 9.13266025194613E-005 0.00031857 0.2866767223 0.7747993658 -0.0005387068 0.00072136 -0.0005387068 0.00072136









X7 SUMMARY OUTPUT







Regression Statistics



Multiple R 0.9779923389



R Square 0.956469015



Adjusted R Square 0.9535669493



Standard Error 32.7017232655



Observations 145







ANOVA




df SS MS F Significance F


Regression 9 3172104.29461106 352456.032734563 329.5821407972 2.74707771195197E-087


Residual 135 144369.365112071 1069 .4027045339



Total 144 3316473.65972313








Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0%


Intercept -208.7978882053 29.1937733054 -7.1521377528 4.89503302424222E-011 -266.5341873747 -151.0615890359 -266.5341873747 -151.0615890359


X1 -0.7366533872 0.4910111908 -1.5002782034 0.1358774574 -1.7077224132 0.2344156388 -1.7077224132 0.2344156388


X2 568.7227656701 129.7207440605 4.3842083222 2.32252523253399E-005 312.1750556771 825.270475663 312.1750556771 825.270475663


X3 -20.8864043649 6.527352115 -3.1998280462 0.0017141426 -33.7954980457 -7.9773106842 -33.7954980457 -7.9773106842


X4 -6.6760540106 3.9937273097 -1.6716349147 0.0969127124 -14.5744175534 1.2223095322 -14.5744175534 1.2223095322


X5 -0.0357539616 0.2250970321 -0.1588379964 0.8740338843 -0.4809266171 0.4094186939 -0.4809266171 0.4094186939


X6 179.6405719756 8.0599993549 22.2879139396 4.4461972602051E-047 163.7003737288 195.5807702224 163.7003737288 195.5807702224


X8 1.6124109872 0.1350031015 11.9435107007 6.90778137998643E-023 1.3454163999 1.8794055745 1.3454163999 1.8794055745


X9 -0.3589251323 0.1419997565 -2.5276461108 0.0126355695 -0.6397569501 -0.0780933146 -0.6397569501 -0.0780933146


X10 -0.00346096 0.0645565649 -0.0536112792 0.9573241234 -0.131133978 0.1242120579 -0.131133978 0.1242120579









X8 SUMMARY OUTPUT







Regression Statistics



Multiple R 0.9851683272



R Square 0.9705566329



Adjusted R Square 0.9685937417



Standard Error 14.5371760637



Observations 145







ANOVA




df SS MS F Significance F


Regression 9 940431.73679167 104492.415199074 494.4526021174 9.965864951131E-099


Residual 135 28529.4808672573 211.3294879056



Total 144 968961.217658928








Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0%


Intercept 43.5957350675 14.7702700774 2.9515868592 0.0037290485 14.3846864278 72.8067837072 14.3846864278 72.8067837072


X1 0.7005333242 0.2116659189 3.3096179483 0.0011981596 0.2819232772 1.1191433712 0.2819232772 1.1191433712


X2 -71.175374728 61.3293590911 -1.1605432664 0.2478758485 -192.4659728054 50.1152233495 -192.4659728054 50.1152233495


X3 27.6709503842 1.8402415564 15.0365859783 1.24028537387635E-030 24.0315189228 31.3103818457 24.0315189228 31.3103818457


X4 -4.3364824727 1.7543853668 -2.4717958522 0.0146877292 -7.8061168133 -0.866848132 -7.8061168133 -0.866848132


X5 -0.0151891196 0.1000651152 -0.1517923559 0.8795773184 -0.2130871223 0.1827088831 -0.2130871223 0.1827088831


X6 -57.0685332228 5.9959516305 -9.5178441621 9.50624600076798E-017 -68.9266802846 -45.2103861609 -68.9266802846 -45.2103861609


X7 0.3186358018 0.0266785713 11.9435107007 6.90778137998703E-023 0.2658737981 0.3713978055 0.2658737981 0.3713978055


X9 0.0757229623 0.0642712236 1.1781783204 0.2407981523 -0.0513857385 0.2028316631 -0.0513857385 0.2028316631


X10 0.1065367237 0.0271939564 3.9176617765 0.0001414064 0.0527554468 0.1603180005 0.0527554468 0.1603180005









X9 SUMMARY OUTPUT







Regression Statistics



Multiple R 0.6856643236



R Square 0.4701355647



Adjusted R Square 0.434811269



Standard Error 19.367574523



Observations 145







ANOVA




df SS MS F Significance F


Regression 9 44930.6369429972 4992.2929936664 13.309127769 4.42398321086373E-015


Residual 135 50638.897292226 375.1029429054



Total 144 95569.5342352232








Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0%


Intercept -6.7613055092 20.2947914672 -0.3331547171 0.7395343416 -46.898157278 33.3755462595 -46.898157278 33.3755462595


X1 -0.0760408403 0.2931422348 -0.2593991287 0.7957224487 -0.6557859658 0.5037042853 -0.6557859658 0.5037042853


X2 194.7806720851 80.3849519534 2.4230986939 0.0167141627 35.8039757141 353.7573684561 35.8039757141 353.7573684561


X3 6.7327547922 3.9676489672 1.6969129194 0.0920175392 -1.1140338148 14.5795433993 -1.1140338148 14.5795433993


X4 -6.9457158898 2.3136567089 -3.0020511958 0.00319581 -11.5214168286 -2.3700149509 -11.5214168286 -2.3700149509


X5 0.0570091276 0.1332357143 0.4278817278 0.6694190319 -0.2064901117 0.320508367 -0.2064901117 0.320508367


X6 29.5949784158 10.0072515915 2.9573532898 0.003664223 9.8037145149 49.3862423168 9.8037145149 49.3862423168


X7 -0.1258963278 0.0498077351 -2.5276461108 0.0126355695 -0.2244006993 -0.0273919563 -0.2244006993 -0.0273919563


X8 0.1344057864 0.114079324 1.1781783204 0.2407981523 -0.0912080085 0.3600195812 -0.0912080085 0.3600195812


X10 0.0729086751 0.0377155498 1.9331197763 0.0553148378 -0.0016810753 0.1474984255 -0.0016810753 0.1474984255









X10 SUMMARY OUTPUT







Regression Statistics



Multiple R 0.973977501



R Square 0.9486321724



Adjusted R Square 0.9452076505



Standard Error 43.5972121212



Observations 145







ANOVA




df SS MS F Significance F


Regression 9 4738685.16832579 526520.574258421 277.0115701847 1.90245641023557E-082


Residual 135 256596.782139832 1900.7169047395



Total 144 4995281.95046562








Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0%


Intercept -230.3375100086 41.1798376784 -5.5934535684 0.000000119 -311.778555778 -148.8964642392 -311.778555778 -148.8964642392


X1 4.6152794508 0.5271325438 8.7554439678 7.38426601019025E-015 3.572773505 5.6577853965 3.572773505 5.6577853965


X2 -530.4720600727 179.1157448018 -2.9616160247 0.0036169697 -884.7078801444 -176.236240001 -884.7078801444 -176.236240001


X3 -38.5142428126 8.3953895248 -4.5875468552 1.01314147765478E-005 -55.1177395986 -21.9107460266 -55.1177395986 -21.9107460266


X4 56.0594593828 2.3783382416 23.5708522872 1.0784608010549E-049 51.3558382781 60.7630804875 51.3558382781 60.7630804875


X5 0.029491299 0.3001116774 0.098267749 0.9218654425 -0.5640372391 0.6230198371 -0.5640372391 0.6230198371


X6 6.6617677381 23.2379095319 0.2866767223 0.7747993658 -39.2956658134 52.6192012897 -39.2956658134 52.6192012897


X7 -0.0061513826 0.1147404562 -0.0536112792 0.9573241234 -0.2330726935 0.2207699282 -0.2330726935 0.2207699282


X8 0.9582011184 0.2445849522 3.9176617765 0.0001414064 0.4744873543 1.4419148825 0.4744873543 1.4419148825


X9 0.3694419196 0.1911117584 1.9331197763 0.0553148378 -0.0085183235 0.7474021627 -0.0085183235 0.7474021627









Y SUMMARY OUTPUT







Regression Statistics



Multiple R 0.8783266786



R Square 0.7714577544 MIDA ROHKEM X SEDA SUUREMON R^2



Adjusted R Square 0.7544023629



Standard Error 4.7751738241



Observations 145







ANOVA
PALJU ON ÄRA SELGITATUD




df SS MS F Significance F


Regression 10 10314.0403767963 1031.4040376796 45.2324859283 3.93646303673211E-038


Residual 134 3055.5061967631 22.8022850505



Total 144 13369.5465735594








Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0%


Intercept 10.3550578837 5.0058404105 2.0685952876 0.0405066037 0.4543779215 20.2557378458 0.4543779215 20.2557378458
PIIMAOMAHINNA SEOS LEHMADE ARVUGA-
t-stat -3,62065

X1 -0.0166693168 0.0722937161 -0.2305776727 0.817994572 -0.1596536887 0.126315055 -0.1596536887 0.126315055
Kui x suureneb ühe 1 võrra sis y väheneb 73 võrra


X2 -73.3028538915 20.2457210313 -3.6206590903 0.0004156049 -113.3453618618 -33.2603459211 -113.3453618618 -33.2603459211


X3 0.6683084554 0.9886217888 0.6760001277 0.5002056064 -1.2870131553 2.6236300661 -1.2870131553 2.6236300661
TOETUSED tstat 5,43080698


X4 0.4760408341 0.5891770156 0.807975908 0.4205364797 -0.6892486265 1.6413302948 -0.6892486265 1.6413302948
Kui toetusi saadakse rohkem sis lehmade arv suureneb.


X5 0.1785226235 0.0328722093 5.4308069802 2.55534122737776E-007 0.1135071222 0.2435381247 0.1135071222 0.2435381247


X6 1.6166460515 2.5460074788 0.6349730176 0.5265287407 -3.4189130479 6.652205151 -3.4189130479 6.652205151
MÜÜGIOSAKAAL


X7 0.0227333613 0.0125675801 1.8088893069 0.0727101334 -0.002123122 0.0475898445 -0.002123122 0.0475898445
Kui müügiosakaal suureneb sis lehmade arv suureneb.


X8 -0.0557828404 0.0282710703 -1.973142147 0.0505372243 -0.1116980906 0.0001324099 -0.1116980906 0.0001324099


X9 0.3235683392 0.0212200824 15.2482131631 4.53949941705992E-031 0.2815987143 0.3655379641 0.2815987143 0.3655379641


X10 -0.0099573055 0.0094267846 -1.0562780332 0.2927418353 -0.0286018425 0.0086872316 -0.0286018425 0.0086872316


STATISTILISELT USALDUSVÄÄRSED



ILMA X8--sata







SUMMARY OUTPUT







Regression Statistics



Multiple R 0.8745385046



R Square 0.764817596



Adjusted R Square 0.7491387691



Standard Error 4.826072787



Observations 145







ANOVA




df SS MS F Significance F


Regression 9 10225.264469979 1136.1404966643 48.7802817931 3.59531987458764E-038


Residual 135 3144.2821035804 23.290978545



Total 144 13369.5465735594








Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0%


Intercept 7.9231639538 4.9034556756 1.6158326858 0.1084650965 -1.7743623265 17.6206902341 -1.7743623265 17.6206902341


X1 -0.0557470554 0.0702691586 -0.7933360308 0.4289742105 -0.1947178258 0.0832237149 -0.1947178258 0.0832237149


X2 -69.3324893251 20.3602095521 -3.4052935039 0.0008707804 -109.5987179332 -29.066260717 -109.5987179332 -29.066260717


X3 -0.8752557526 0.6109260601 -1.4326705142 0.1542635978 -2.083479486 0.3329679808 -2.083479486 0.3329679808


X4 0.7179421436 0.5824233977 1.2326808065 0.2198372269 -0.4339120954 1.8697963827 -0.4339120954 1.8697963827


X5 0.1793699157 0.033219762 5.3994942979 2.92132558424943E-007 0.1136714498 0.2450683816 0.1136714498 0.2450683816


X6 4.8000909302 1.9905447158 2.4114459183 0.0172344359 0.8634060756 8.7367757848 0.8634060756 8.7367757848


X7 0.0049589512 0.0088567908 0.5599038427 0.5764728893 -0.0125570553 0.0224749577 -0.0125570553 0.0224749577


X9 0.3193442973 0.021336854 14.9667939432 1.83972276385415E-030 0.2771465665 0.3615420281 0.2771465665 0.3615420281


X10 -0.0159002265 0.0090278891 -1.7612341452 0.0804627758 -0.0337546128 0.0019541597 -0.0337546128 0.0019541597






ilma x7 --ta



ja 8sata
võrrandi statistiline olulisus suurenes kui x8 välja võtta;)



SUMMARY OUTPUT







Regression Statistics



Multiple R 0.8742262085



R Square 0.7642714636



Adjusted R Square 0.7504050791



Standard Error 4.8138767292



Observations 145







ANOVA




df SS MS F Significance F


Regression 8 10217.9629272423 1277.2453659053 55.1168521153 5.45330989136407E-039


Residual 136 3151 .5836463171 23.1734091641



Total 144 13369.5465735594








Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0%


Intercept 6.5105907709 4.1940060398 1.5523560789 0.1229010556 -1.7833109481 14.80449249 -1.7833109481 14.80449249


X1 -0.0517399994 0.0697271109 -0.7420356116 0.4593453474 -0.1896295969 0.0861495982 -0.1896295969 0.0861495982


X2 -64.7026470147 18.5584071097 -3.4864332177 0.0006595384 -101.4030244505 -28.0022695789 -101.4030244505 -28.0022695789


X3 -0.633232344 0.4306298613 -1.4704794093 0.1437417823 -1.4848290544 0.2183643663 -1.4848290544 0.2183643663


X4 0.5785422195 0.5251961014 1.101573713 0.2725927732 -0.4600649754 1.6171494143 -0.4600649754 1.6171494143


X5 0.1787554874 0.0331177272 5.3975771479 2.91912285800642E-007 0.1132631701 0.2442478047 0.1132631701 0.2442478047


X6 5.6937381219 1.1864563468 4.7989444681 4.14110666444642E-006 3.3474486219 8.0400276218 3.3474486219 8.0400276218


X9 0.3169289261 0.0208434024 15.2052395547 3.98398105706506E-031 0.2757098317 0.3581480204 0.2757098317 0.3581480204


X10 -0.0141835616 0.0084698563 -1.674592942 0.0963122057 -0.0309332169 0.0025660938 -0.0309332169 0.0025660938










SUMMARY OUTPUT



ilma x4jata



7 ja 8sata
Regression Statistics



Multiple R 0.8730224325



R Square 0.7621681677



Adjusted R Square 0.7500161762



Standard Error 4.817625607



Observations 145







ANOVA




df SS MS F Significance F


Regression 7 10189.8428145134 1455.6918306448 62.7196103508 1.20085893754788E-039


Residual 137 3179.703759046 23.2095164894



Total 144 13369.5465735594








Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0%


Intercept 9.7974654663 2.9496040949 3.3216205128 0.0011475244 3.9648263517 15.6301045808 3.9648263517 15.6301045808


X1 -0.1116325223 0.0436892033 -2.5551512478 0.0117060225 -0.1980249153 -0.0252401294 -0.1980249153 -0.0252401294


X2 -53.4390419475 15.4995913631 -3.4477710216 0.0007511582 -84.0884172314 -22.7896666637 -84.0884172314 -22.7896666637


X3 -0.7919180421 0.4061369694 -1.9498792323 0.0532327355 -1.59502595 0.0111898657 -1.59502595 0.0111898657


X5 0.1803674095 0.0331111497 5.4473315178 0.00000023 0.1148923895 0.2458424295 0.1148923895 0.2458424295


X6 5.3333058816 1.1413356025 4.6728638533 7.01950547738697E-006 3.0763932709 7.5902184922 3.0763932709 7.5902184922


X9 0.3119440983 0.0203621001 15.3198391523 1.73058638898405E-031 0.2716794466 0.35220875 0.2716794466 0.35220875


X10 -0.0059447474 0.003978151 -1.4943493864 0.1373840514 -0.0138112672 0.0019217723 -0.0138112672 0.0019217723
Vasakule Paremale
Ökonomeetria Labor 8 VIF 2011 #1 Ökonomeetria Labor 8 VIF 2011 #2 Ökonomeetria Labor 8 VIF 2011 #3 Ökonomeetria Labor 8 VIF 2011 #4 Ökonomeetria Labor 8 VIF 2011 #5 Ökonomeetria Labor 8 VIF 2011 #6 Ökonomeetria Labor 8 VIF 2011 #7 Ökonomeetria Labor 8 VIF 2011 #8 Ökonomeetria Labor 8 VIF 2011 #9 Ökonomeetria Labor 8 VIF 2011 #10 Ökonomeetria Labor 8 VIF 2011 #11 Ökonomeetria Labor 8 VIF 2011 #12 Ökonomeetria Labor 8 VIF 2011 #13 Ökonomeetria Labor 8 VIF 2011 #14 Ökonomeetria Labor 8 VIF 2011 #15 Ökonomeetria Labor 8 VIF 2011 #16 Ökonomeetria Labor 8 VIF 2011 #17 Ökonomeetria Labor 8 VIF 2011 #18 Ökonomeetria Labor 8 VIF 2011 #19 Ökonomeetria Labor 8 VIF 2011 #20 Ökonomeetria Labor 8 VIF 2011 #21 Ökonomeetria Labor 8 VIF 2011 #22 Ökonomeetria Labor 8 VIF 2011 #23 Ökonomeetria Labor 8 VIF 2011 #24 Ökonomeetria Labor 8 VIF 2011 #25 Ökonomeetria Labor 8 VIF 2011 #26 Ökonomeetria Labor 8 VIF 2011 #27 Ökonomeetria Labor 8 VIF 2011 #28 Ökonomeetria Labor 8 VIF 2011 #29 Ökonomeetria Labor 8 VIF 2011 #30 Ökonomeetria Labor 8 VIF 2011 #31 Ökonomeetria Labor 8 VIF 2011 #32 Ökonomeetria Labor 8 VIF 2011 #33 Ökonomeetria Labor 8 VIF 2011 #34 Ökonomeetria Labor 8 VIF 2011 #35 Ökonomeetria Labor 8 VIF 2011 #36 Ökonomeetria Labor 8 VIF 2011 #37 Ökonomeetria Labor 8 VIF 2011 #38 Ökonomeetria Labor 8 VIF 2011 #39 Ökonomeetria Labor 8 VIF 2011 #40 Ökonomeetria Labor 8 VIF 2011 #41 Ökonomeetria Labor 8 VIF 2011 #42 Ökonomeetria Labor 8 VIF 2011 #43 Ökonomeetria Labor 8 VIF 2011 #44 Ökonomeetria Labor 8 VIF 2011 #45 Ökonomeetria Labor 8 VIF 2011 #46 Ökonomeetria Labor 8 VIF 2011 #47 Ökonomeetria Labor 8 VIF 2011 #48 Ökonomeetria Labor 8 VIF 2011 #49 Ökonomeetria Labor 8 VIF 2011 #50 Ökonomeetria Labor 8 VIF 2011 #51 Ökonomeetria Labor 8 VIF 2011 #52 Ökonomeetria Labor 8 VIF 2011 #53 Ökonomeetria Labor 8 VIF 2011 #54 Ökonomeetria Labor 8 VIF 2011 #55 Ökonomeetria Labor 8 VIF 2011 #56
Punktid 50 punkti Autor soovib selle materjali allalaadimise eest saada 50 punkti.
Leheküljed ~ 56 lehte Lehekülgede arv dokumendis
Aeg2012-10-24 Kuupäev, millal dokument üles laeti
Allalaadimisi 50 laadimist Kokku alla laetud
Kommentaarid 1 arvamus Teiste kasutajate poolt lisatud kommentaarid
Autor agne01 Õppematerjali autor

Sarnased õppematerjalid

thumbnail
105
xlsx

Regressioonanalüüs

spetsialiseeru otsene näitaja misnäitaja mahunäitaja mahunäitaja Teravilja müügi Segavilja osakaal Segavilja Kasvupind jrk saagikus, kg/ha kogumüügist toodang, kg kokku, ha X1 X2 X3 X4 1 3148,148148148 1 68 000 178,90 2 2238,938053097 0,3082771129 50 600 124,91 3 1700 0,440320407 35 700 376,00 4 3007,692307692 0,0376854187 39 100 763,00 5 2304 0,5555555556 28 800 51,00 6 3098,591549296 0,4973633043 22 000 351,10 7 2000 0,113773135 4 000 26,40 8 1823,529411765 0,5131964809

Ökonomeetria
thumbnail
9
xlsx

Statistika eksam 2012, exceli osa

2.1 Koopia- Teenindaja Töötundide masinate tööstaaz, arv arv kuudes 1 1 12 SUMMARY OUTPUT 3,1 3 8 17 10 5 Regression Statistics 14 8 2 Multiple R 0,9346801 6 5 10 R Square 0,8736269 1,8 1 1 Adjusted R Square 0,8578302 11,5 10 10 Standard Error 2,056276 9,3 5 2 Observations 10 6 4 6 12,2 10 18 ANOVA df SS MS Regression 1 233,84283 233,84283

Statistika
thumbnail
20
xlsx

Statistika

Riik Populatsioon Immigratsioon Sünnid Hiina 1 336 450 000 3852000 181 340 000 India 1 178 436 000 5700000 26913000 Ameerika Ühendriigid 308 898 000 38355000 4399000 Indoneesia 231 369 500 160000 4220000 Brasiilia 192 651 000 641000 3105000 Pakistan 169 010 500 3254000 5337000 Bangladesh 162 221 000 1032000 3430000 Nigeeria 154 729 000 971000 6028000 Venemaa 141 927 297 12080000 1545000 Jaapan 127 430 000 2048000 1473000 Mehhiko 107 550 697 644000 2049000 Filipiinid 92 226 600 374000 2236000 Vietnam 85 789 573 21000 1267000 Saksamaa 81 757 600 10144000 679000 Etioopia 79 221 000

Statistika
thumbnail
6
xlsx

Ökonomeetria Labor 6 ül.1

Labor 1 - ül 2 Leida regressioonimudel Y = a0 + a1 X, kui perede arv on X ja autode arv Y. Regressioonikordajate (parameetri hinnangute) ja usalduspiiride leidmiseks kasutada vahendit Andmed - Data Analysis - Regression. Alevik Perede arv (X) A 7000 B 7500 C 8000 D 6000 E 9000 Hinnata regressioonimudeli a) kirjeldatuse taset; b) statistilist olulisust; c) parameetri (regressioonikordaja a1)

Ökonomeetria
thumbnail
46
xlsx

Statistika kolmas kontrolltöö

Ülikoolist väljalangenute arv Kasvutempo Bakalaureuseõpe Magistriõpe BakalaureuseõpMagistriõpe 1993 2952 105 -226 81 1994 2726 186 -589 184 1995 2137 370 -105 100 1996 2032 470 197 65 1997 2229 535 157 -23 1998 2386 512 187 76 1999 2573 588 457 43 2000 3030 631 284 29 2001 3314 660 -267 102 2002 3047 762 945 237 2003 3992 999 -224

Statistika
thumbnail
18
xlsx

Statistika eksami üks variant

Ülesande 1 lahendus Keskmine tellimuste arv 15 mminuti jooksul µ 7 Keskmine tellimuste arv 5 minuti jooksul 2.33 m P(x=m) Tõenäosus, et 5 min jookusl 0 0.097 ei ole ühtegi tellimust Töötajate Arenduskulud Firma Käive (mln $) arv (tuh) (mln $) Abbott Laboratories 10012 50.24 1072 Alza 326 1.44 20 American Home Products Corp 13376 64.71 1354 Bristol Myers Squibb 13767 49.14 1199 Carter Wallace Inc 662 3.61 26 Genentech Inc. 857 2.84 503 IVAX Corp. 1259 7.89 64 Johnson & Johnson 18842 82.3 16

Statistika
thumbnail
12
xlsx

Statistika ülesanded 13

Gümnaasiumi hinded Hinded EMÜ-s Gümn_keskmHinne Gümn_matem õppeaine A õppeaine B õppeaine C õppeaine D 3,27 29 3 3 1 1. Ül.11.1 1 3,5 30 3 3 1 (Points: 2 2) Kopeerige 3,79 59 1 4 2 korrelatsioonimaatriks to 1 3,84 59 1 4 2 usaldusväärsust. 1 Missug 3,87 72 4 4 2 Vastus2vormistage lühi

Statistika
thumbnail
40
doc

Matemaatika andmestiku analüüs

Eesti Maaülikool Metsandus- ja maaehitusinstituut Geomaatika osakond Matemaatika andmestiku analüüs Aruanne õppeaines matemaatiline statistika Koostajad: Juhendaja: Eve Aruvee Tartu Sisukord Sissejuhatus....................................................................................................................... 3 Tunnuste esmaanalüüs.......................................................................................................4 Seoste analüüs................................................................................................................... 8 Mudeli koostamine.......................................................................................................... 13 Kokkuvõte.......................................................................................................................

Statistika




Meedia

Kommentaarid (1)

Schumi profiilipilt
Schumi: okei
14:51 25-10-2013



Sellel veebilehel kasutatakse küpsiseid. Kasutamist jätkates nõustute küpsiste ja veebilehe üldtingimustega Nõustun