Regressioonanalüüs (0)

Overview

Valitud andmed
4 X
Parandatud 4X
Best
CP
LMKS
Statistiliselt usald.
X1=Y
X2=Y
X3=Y
X4=Y
X1,Y
X2,Y
X3,Y
X4,Y
X1,X2,Y
X1,X3,Y
X1,X4,Y
X2,X3,Y
X2,X4,Y
X3,X4,Y
X1,X2,X3,Y
X1,X3,X4,Y
X1,X2,X4,Y
X2,X3,X4,Y
X1,X2,X3,X4,Y

Sheet 1: Valitud andmed

otsene näitaja spetsialiseerumisnäitaja mahunäitaja mahunäitaja otsene näitaja mahunäitaja spetsialiseerumisnäitaja mahunäitaja tagapõhjanäitaja mahunäitaja
jrk Segavilja saagikus, kg/ha Teravilja müügi osakaal kogumüügist Segavilja toodang, kg Kasvupind kokku, ha Segavilja toodang kasvupinna kohta, kg/ha Segavilja kasvupind, ha Segavilja pindala osakaal kogu kasvupinnast, % Toetused kokku, kr Toetused kasvupinna kohta, kr/ha Investeering kokku, kr Segavilja müük, kg/ha

X1 X2 X3 X4 X5 X6 X7 X8 X9 X10 Y 1 3148.1481481482 1 68,000 178.90 380.100615 21.60 12.073784 86,719 484.734489 720,439 3472.2222222222 2 2238.9380530974 0.3082771129 50,600 124.91 405.091666 22.60 18.093027 51,711 413.986070 84,492 1411.5044247788 3 1700 0.440320407 35,700 376.00 94.946809 21.00 5.585106 89,585 238.257979 102,000 885.7142857143 4 3007.6923076923 0.0376854187 39,100 763.00 51.245085 13.00 1.703801 341,721 447.865007 198,000 107.6923076923 5 2304 0.5555555556 28,800 51.00 564.705882 12.50 24.509804 33,597 658.764706 135,000 2184 6 3098.5915492958 0.4973633043 22,000 351.10 62.660211 7.10 2.022216 183,869 523.694104 326,772 3563.3802816902 7 2000 0.113773135 4,000 26.40 151.515152 2.00 7.575758 16,331 618.598485 0 1000 8 1823.5294117647 0.5131964809 31,000 47.50 652.631579 17.00 35.789474 10,781 226.968421 4,000 264.7058823529 9 1013 .422818792 1 15,100 147.40 102.442334 14.90 10.108548 60,888 413.080054 0 1013.422818792 10 1805.8252427185 0.2217146584 18,600 48.30 385.093168 10.30 21.325052 75,817 1569 .710145 356,717 116.5048543689 11 2089.552238806 0.3206696716 14,000 28.40 492.957746 6.70 23.591549 36,347 1279 .823944 0 1492.5373134328 12 2386.3636363636 0.4098781537 21,000 52.49 400.076205 8.80 16.765098 32,397 617.203277 10,500 1784 .0909090909 13 2498.0842911877 0.0871391819 65,200 111.80 583.184258 26.10 23.345259 84,918 759.552773 75,059 406.1302681992 14 1900 0.9630177664 41,800 302.80 138.044914 22.00 7.265522 105,687 349.032365 191,670 1440 .9090909091 15 2707.8651685393 0.9364025006 48,200 1,159.75 41.560681 17.80 1.534814 528,090 455.348135 4,160,342 2707.8651685393 16 1950 0.4078268349 11,700 51.00 229.411765 6.00 11.764706 21,317 417.980392 0 833.3333333333 17 2500 0.0580059263 12,250 27.00 453.703704 4.90 18.148148 85,336 3160.592593 64,920 418.3673469388 18 1833.3333333333 0.5913490797 16,500 70.00 235.714286 9.00 12.857143 88,018 1257.400000 0 1444.4444444445 19 1190 0.3651447144 11,900 18.60 639.784946 10.00 53.763441 53,990 2902.688172 0 500 20 650 0.6219000439 13,000 166.40 78.125000 20.00 12.019231 62,669 376.616587 259,607 630 21 2500 0.0849347064 9,000 46.70 192.719486 3.60 7.708779 36,479 781.134904 8,000 861.1111111111 22 2000 1 57,400 46.40 1237 .068966 28.70 61.853448 15,900 342.672414 0 348.4320557491 23 2300 0.4299838108 33,350 191.70 173.969744 14.50 7.563902 151,720 791.444966 108,119 920.6896551724 24 1575 0.1712059995 6,300 41.30 152.542373 4.00 9.685230 43,190 1045 .762712 0 1500 25 1700 0.2144018643 10,200 58.30 174.957118 6.00 10.291595 25,013 429.039451 220,000 1000 26 2100 0.227514471 42,000 75.70 554.821664 20.00 26.420079 67,615 893.196830 85,838 1500 27 1500 0.0229441925 16,650 195.50 85.166240 11.10 5.677749 90,856 464.736573 1,294,823 1986.4864864865 28 2970.297029703 0.9839064017 60,000 214.40 279.850746 20.20 9.421642 82,330 384.001866 267,000 74.2574257426 29 2272.7272727273 0.6515975768 10,000 66.36 150.693189 4.40 6.630500 92,852 1399.216395 0 2272.7272727273 30 1214 .4702842377 0.2452189235 14,100 55.41 254.466703 11.61 20.952897 382,392 6901 .136979 24,000 1507 .3212747631 31 1482 .5454545455 0.0679560899 8,154 30.80 264.740260 5.50 17.857143 192,993 6266.006494 140,499 545.4545454545 32 2498.3164983165 0.9491048758 74,200 259.40 286.044719 29.70 11.449499 359,486 1385 .836546 20,593 599.3265993266 33 1382 .9787234043 0.4319503474 39,000 106.61 365.819342 28.20 26.451552 238,287 2235 .128037 0 751.7730496454 34 1875 0.9936050606 18,000 57.92 310.773481 9.60 16.574586 105,458 1820.752762 0 1544.7916666667 35 1665.306122449 0.5874487612 16,320 53.86 303.007798 9.80 18.195321 124,388 2309.468994 250,000 714.2857142857 36 2499.1556906451 0.9678407163 74,000 259.30 285.383725 29.61 11.419206 492,735 1900.250675 1,025,000 496.4539007092 37 1293.7062937063 0.7069314636 18,500 121.52 152.238315 14.30 11.767610 273,846 2253.505596 142,801 1699.3006993007

Segavilja saagikus, kg/ha Teravilja müügi osakaal kogumüügist Segavilja toodang, kg Kasvupind kokku, ha Segavilja toodang kasvupinna kohta, kg/ha Segavilja kasvupind, ha Segavilja pindala osakaal kogu kasvupinnast, % Toetused kokku, kr Toetused kasvupinna kohta, kr/ha Investeering kokku, kr Segavilja müük, kg/ha
X1 X2 X3 X4 X5 X6 X7 X8 X9 X10 Y Aritmeetiline keskmine 2018 .24 0.49 29070.92 161.73 307.22 14.17 16.21 130414.27 1318.25 277734.89 1189 .17 Mediaan 2000.00 0.43 18600.00 70.00 264.74 12.50 12.02 85336.00 759.55 84492.00 1000.00 Dispersioon 354480.28 0.11 430124709.02 48798.47 54529.95 66.60 162.77 17822412731.15 2229834.90 510171180849.77 737213.31 Standardhälve 595.38 0.33 20739.45 220.90 233.52 8.16 12.76 133500.61 1493.26 714262.68 858.61 Miinimum 650.00 0.02 4000.00 18.60 41.56 2.00 1.53 10781.00 226.97 0.00 74.26 Maksimum 3148.15 1.00 74200.00 1159 .75 1237.07 29.70 61.85 528090.00 6901.14 4160342.00 3563.38 Asümmeetriakordaja -0.04 0.31 0.88 3.27 1.91 0.46 2.02 1.71 2.60 4.81 1.13 Teravatipulisuse kordaja -0.29 -1.19 -0.42 12.31 5.74 -0.89 5.04 2.21 7.32 25.58 1.23 Korrigeeritud variatsioonikordaja 43.51 71.04 82.72 154.34 87.90 67.08 86.94 111.59 136.84 257.17 77.01
mõõdukas as. oluline as. oluline as. algandmete kontroll oluline as. oluline as. oluline as. algandmete kontroll algandmete kontroll algandmete kontroll oluline as.

Segavilja saagikus, kg/ha Teravilja müügi osakaal kogumüügist Segavilja toodang, kg Kasvupind kokku, ha Segavilja toodang kasvupinna kohta, kg/ha Segavilja kasvupind, ha Segavilja pindala osakaal kogu kasvupinnast, % Toetused kokku, kr Toetused kasvupinna kohta, kr/ha Investeering kokku, kr Segavilja müük, kg/ha
X1 X2 X3 X4 X5 X6 X7 X8 X9 X10 Y Segavilja saagikus, kg/ha 1

Teravilja müügi osakaal kogumüügist 0.1096786861 1

Segavilja toodang, kg 0.5284888849 0.4876415625 1
Kasvupind kokku 0.3913763967 0.2316719159 0.3733775434 1
Segavilja toodang kasvupinna kohta, kg/ha 0.0373834683 0.0739068394 0.2887958601 -0.4107477835 1
Segavilja kasvupind, ha 0.1019054472 0.5086876577 0.8777774876 0.2620065987 0.3125344972 1
Segavilja pindala osakaal kogu kasvupinnast, % -0.2696546592 0.0266194021 0.085100616 -0.4394532468 0.9175949443 0.234377947 1
Toetused kokku, kr 0.1855155564 0.2417905986 0.3890477344 0.6542692574 -0.3286527565 0.3422092772 -0.2959662722 1
Toetused kasvupinna kohta, kr/ha -0.3328011855 -0.2380997612 -0.2729650816 -0.2579300449 0.0308296709 -0.2056504497 0.1921439459 0.350550764 1
Investeering kokku, kr 0.2380653735 0.2341597253 0.2517619933 0.7748406737 -0.2605963873 0.1482457244 -0.2842717457 0.5615251965 -0.1305340048 1
Segavilja müük, kg/ha 0.2686886589 0.201886478 -0.0434216598 0.2198798518 -0.2662113698 -0.1775546741 -0.3333972074 0.0847603401 -0.1322233744 0.3577506332 1

Sheet 2: 4 X

Segavilja saagikus, kg/ha Teravilja müügi osakaal kogumüügist Kasvupind kokku, ha Investeering kokku, kr Segavilja müük, kg/ha


Regression Statistics

X1 X2 X3 X4 Y



3148.1481481482 1 178.90 720,439 3472.2222222222
X1 - Y X2 - Y X3 - Y X4 - Y

2238.9380530974 0.3082771129 124.91 84,492 1411.5044247788
Multiple R 0.4433659456 0.2504434603 0.8191438146 0.7860026179

1700 0.440320407 376.00 102,000 885.7142857143
R Square 0.1965733617 0.0627219268 0.670996589 0.6178001153

3007.6923076923 0.0376854187 763.00 198,000 107.6923076923
Adjusted R Square 0.1212521143 -0.0251478926 0.6401525192 0.5819688762

2304 0.5555555556 51.00 135,000 2184
Standard Error 536.1476481701 0.3302241854 134.3823045742 465784.227302512

3098.5915492958 0.4973633043 351.10 326,772 3563.3802816902
Observations 36 36 36 36

2000 0.113773135 26.40 0 1000
VIF= 1.2446687131 1.0669192298 3.0394821649 2.6164319774

1823.5294117647 0.5131964809 47.50 4,000 264.7058823529


1013.422818792 1 147.40 0 1013.422818792


1805.8252427185 0.2217146584 48.30 356,717 116.5048543689
SUMMARY OUTPUT

2089.552238806 0.3206696716 28.40 0 1492.5373134328


2386.3636363636 0.4098781537 52.49 10,500 1784.0909090909
Regression Statistics

2498.0842911877 0.0871391819 111.80 75,059 406.1302681992
Multiple R 0.4532791876

1900 0.9630177664 302.80 191,670 1440.9090909091
R Square 0.2054620219

2707.8651685393 0.9364025006 1,159.75 4,160,342 2707.8651685393
Adjusted R Square 0.1061447747

1950 0.4078268349 51.00 0 833.3333333333
Standard Error 811.7647244022

2500 0.0580059263 27.00 64,920 418.3673469388
Observations 37

1833.3333333333 0.5913490797 70.00 0 1444.4444444445


1190 0.3651447144 18.60 0 500
ANOVA

650 0.6219000439 166.40 259,607 630

df SS MS F Significance F

2500 0.0849347064 46.70 8,000 861.1111111111
Regression 4 5452896.12890787 1363224.03222697 2.06874463 0.1081503184

2000 1 46.40 0 348.4320557491
Residual 32 21086782.9690814 658961.967783792

2300 0.4299838108 191.70 108,119 920.6896551724
Total 36 26539679.0979892

1575 0.1712059995 41.30 0 1500


1700 0.2144018643 58.30 220,000 1000

Coefficients Standard Error t Stat P- value Lower 95% Upper 95% Lower 95,0% Upper 95,0%
2100 0.227514471 75.70 85,838 1500
Intercept 316.8447162072 515.1894957149 0.6150061654 0.5428997096 -732.5619411507 1366.2513735651 -732.5619411507 1366.2513735651
1500 0.0229441925 195.50 1,294,823 1986.4864864865
X1 0.3616205503 0.2486257171 1.4544776563 0.1555532602 -0.1448134607 0.8680545613 -0.1448134607 0.8680545613
2970.297029703 0.9839064017 214.40 267,000 74.2574257426
X2 325.0756415193 419.6871545439 0.7745665742 0.4442816117 -529.7991135936 1179.9503966321 -529.7991135936 1179.9503966321
2272.7272727273 0.6515975768 66.36 0 2272.7272727273
X3 -1.1237269925 1.0313144227 -1.0896065911 0.2840241435 -3.2244457183 0.9769917334 -3.2244457183 0.9769917334
1214.4702842377 0.2452189235 55.41 24,000 1507.3212747631
X4 0.0005921042 0.0003028169 1.955321229 0.0593257642 -2.47135209818615E-005 0.001208922 -2.47135209818615E-005 0.001208922
1482.5454545455 0.0679560899 30.80 140,499 545.4545454545

2498.3164983165 0.9491048758 259.40 20,593 599.3265993266

1382.9787234043 0.4319503474 106.61 0 751.7730496454

1875 0.9936050606 57.92 0 1544.7916666667
RESIDUAL OUTPUT
1665.306122449 0.5874487612 53.86 250,000 714.2857142857

2499.1556906451 0.9678407163 259.30 1,025,000 496.4539007092
Observation Predicted Y Residuals
Predicted Y Y Predicted Y 1293.7062937063 0.7069314636 121.52 142,801 1699.3006993007
1 2005.895638655 1466.3265835673
2005.895638655 3472.2222222222 2005.895638655
2 1136.367438727 275.1369860518
1136.367438727 1411.5044247788 1136.367438727
3 712.610372086 173.1039136283
712.610372086 885.7142857143 712.610372086
4 676.5716162306 -568.8793085383
676.5716162306 107.6923076923 676.5716162306
5 1353.2400362357 830.7599637643
1353.2400362357 2184 1353.2400362357
6 1397.9823267009 2165.3979549893
1397.9823267009 3563.3802816902 1397.9823267009
7 1047.4042991287 -47.4042991287
1047.4042991287 1000 1047.4042991287
8 1092.0894856591 -827.3836033061
1092.0894856591 264.7058823529 1092.0894856591
9 842.7575164937 170.6653022982
842.7575164937 1013.422818792 842.7575164937
10 1198.879897334 -1082.3750429651
1198.879897334 116.5048543689 1198.879897334

11 1144.797799387 347.7395140458
1144.797799387 1492.5373134328 1144.797799387

12 1260.2769159563 523.8139931346
1260.2769159563 1784.0909090909 1260.2769159563

13 1167.3402309256 -761.2099627264
1167.3402309256 406.1302681992 1167.3402309256

14 1090.2014630906 350.7076278185
1090.2014630906 1440.9090909091 1090.2014630906

15 2760.579738348 -52.7145698086
2760.579738348 2707.8651685393 2760.579738348

16 1097 .2692827194 -263.935949386
1097.2692827194 833.3333333333 1097.2692827194

17 1247.8511830766 -829.4838361378
1247.8511830766 418.3673469388 1247.8511830766

18 1093.3880171231 351.0564273214
1093.3880171231 1444.4444444445 1093.3880171231

19 844.9715013418 -344.9715013418
844.9715013418 500 844.9715013418

20 720.788859013 -90.788859013
720.788859013 630 720.788859013

21 1200.7650794654 -339.6539683543
1200.7650794654 861.1111111111 1200.7650794654

22 1313.0205259491 -964.5884701999
1313.0205259491 348.4320557491 1313.0205259491

23 1136.9484970998 -216.2588419274
1136.9484970998 920.6896551724 1136.9484970998

24 895.6420583103 604.3579416897
895.6420583103 1500 895.6420583103

25 1066.0461206493 -66.0461206493
1066.0461206493 1000 1066.0461206493

26 1115.9661934468 384.0338065532
1115.9661934468 1500 1115.9661934468

27 1413.7156785798 572.7708079067
1413.7156785798 1986.4864864865 1413.7156785798

28 1627.9739277147 -1553.7165019721
1627.9739277147 74.2574257426 1627.9739277147

29 1275.9575803923 996.769692335
1275.9575803923 2272.7272727273 1275.9575803923

30 787.6816163142 719.6396584489
787.6816163142 1507.3212747631 787.6816163142

31 923.6337487009 -378.1792032463
923.6337487009 545.4545454545 923.6337487009

32 1249.5166000308 -650.1900007042
1249.5166000308 599.3265993266 1249.5166000308

33 837.5742448988 -85.8011952534
837.5742448988 751.7730496454 837.5742448988

34 1252 .7937831815 291.9978834852
1252.7937831815 1544.7916666667 1252.7937831815

35 1197.5210354216 -483.2353211358
1197.5210354216 714.2857142857 1197.5210354216

36 1850.7366331525 -1354.2827324433
1850.7366331525 496.4539007092 1850.7366331525

37 962.4794681008 736.8212311999
962.4794681008 1699.3006993007 962.4794681008

Sheet 3: Parandatud 4X

Segavilja saagikus, kg/ha Teravilja müügi osakaal kogumüügist Kasvupind kokku, ha Investeering kokku, kr Segavilja müük, kg/ha




X1 X2 X3 X4 Y
SUMMARY OUTPUT

2238.9380530974 0.3082771129 124.91 84,492 1411.5044247788

1700 0.440320407 376.00 102,000 885.7142857143
Regression Statistics

2304 0.5555555556 51.00 135,000 2184
Multiple R 0.5624358723

2000 0.113773135 26.40 0 1000
R Square 0.3163341104

1823.5294117647 0.5131964809 47.50 4,000 264.7058823529
Adjusted R Square 0.2069475681

1013.422818792 1 147.40 0 1013.422818792
Standard Error 549.785453752

2089.552238806 0.3206696716 28.40 0 1492.5373134328
Observations 30

2386.3636363636 0.4098781537 52.49 10,500 1784.0909090909

2498.0842911877 0.0871391819 111.80 75,059 406.1302681992
ANOVA

1900 0.9630177664 302.80 191,670 1440.9090909091

df SS MS F Significance F

2707.8651685393 0.9364025006 1,159.75 4,160,342 2707.8651685393
Regression 4 3496460.37945545 874115.094863863 2.8918923996 0.0427090946

1950 0.4078268349 51.00 0 833.3333333333
Residual 25 7556601.12893193 302264.045157277

1833.3333333333 0.5913490797 70.00 0 1444.4444444445
Total 29 11053061.5083874

1190 0.3651447144 18.60 0 500

650 0.6219000439 166.40 259,607 630

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0%
2500 0.0849347064 46.70 8,000 861.1111111111
Intercept 648.6320797991 438.424874887 1.4794600328 0.1515091294 -254.320845022 1551.5850046201 -254.320845022 1551.5850046201
2000 1 46.40 0 348.4320557491
X1 0.2373893137 0.216458597 1.0966961671 0.2832262354 -0.2084155083 0.6831941357 -0.2084155083 0.6831941357
2300 0.4299838108 191.70 108,119 920.6896551724
X2 265.4183613178 385.4448079738 0.6886027671 0.4974142857 -528.4200740736 1059.2567967093 -528.4200740736 1059.2567967093
1575 0.1712059995 41.30 0 1500
X3 -1.409442727 1.3160266011 -1.0709834633 0.2944078631 -4.1198502259 1.3009647718 -4.1198502259 1.3009647718
1700 0.2144018643 58.30 220,000 1000
X4 0.0006959512 0.0003337197 2.0854364618 0.0473952753 8.6426482244664E-006 0.0013832598 8.6426482244664E-006 0.0013832598
2100 0.227514471 75.70 85,838 1500

1500 0.0229441925 195.50 1,294,823 1986.4864864865

2272.7272727273 0.6515975768 66.36 0 2272.7272727273

1214.4702842377 0.2452189235 55.41 24,000 1507.3212747631
RESIDUAL OUTPUT
1482.5454545455 0.0679560899 30.80 140,499 545.4545454545
2498.3164983165 0.9491048758 259.40 20,593 599.3265993266
Observation Predicted Y Residuals
Predicted Y Y Predicted Y 1382.9787234043 0.4319503474 106.61 0 751.7730496454
1 1144.7032745903 266.8011501885
1144.7032745903 1411.5044247788 1144.7032745903 1875 0.9936050606 57.92 0 1544.7916666667
2 710.099594684 175.6146910303
710.099594684 885.7142857143 710.099594684 1665.306122449 0.5874487612 53.86 250,000 714.2857142857
3 1365.1035415489 818.8964584511
1365.1035415489 2184 1365.1035415489 1293.7062937063 0.7069314636 121.52 142,801 1699.3006993007
4 1116.3988982499 -116.3988982499
1116.3988982499 1000 1116.3988982499
5 1153.5655197754 -888.8596374224
1153.5655197754 264.7058823529 1153.5655197754
6 946.874330586 66.5484882059
946.874330586 1013.422818792 946.874330586 Välja võetud andmed:
7 1189.7528970118 302.7844164211
1189.7528970118 1492.5373134328 1189.7528970118 3148.1481481482 1 178.90 720,439 3472.2222222222
8 1257.2443327976 526.8465762933
1257.2443327976 1784.0909090909 1257.2443327976 3098.5915492958 0.4973633043 351.10 326,772 3563.3802816902
9 1159.4406410715 -753.3103728722
1159.4406410715 406.1302681992 1159.4406410715 2499.1556906451 0.9678407163 259.30 1,025,000 496.4539007092
10 1061.8880890183 379.0210018908
1061.8880890183 1440.9090909091 1061.8880890183 2970.297029703 0.9839064017 214.40 267,000 74.2574257426
11 2800.7827066095 -92.9175380702
2800.7827066095 2707.8651685393 2800.7827066095 1805.8252427185 0.2217146584 48.30 356,717 116.5048543689
12 1147.9043926352 -314.5710593018
1147.9043926352 833.3333333333 1147.9043926352 2500 0.0580059263 27.00 64,920 418.3673469388
13 1142.1397343743 302.3047100701
1142.1397343743 1444.4444444445 1142.1397343743
3007.6923076923 0.0376854187 763.00 198,000 107.6923076923
14 1001 .8258401235 -501.8258401235
1001.8258401235 500 1001.8258401235

15 914.1413670691 -284.1413670691
914.1413670691 630 914.1413670691

16 1204.3952291768 -343.2841180657
1204.3952291768 861.1111111111 1204.3952291768

17 1323.4309259715 -974.9988702224
1323.4309259715 348.4320557491 1323.4309259715

18 1113.80848069 -193.1188255176
1113.80848069 920.6896551724 1113.80848069

19 1009.7514800703 490.2485199298
1009.7514800703 1500 1009.7514800703

20 1180.0388655518 -180.0388655518
1180.0388655518 1000 1180.0388655518

21 1160.5804044026 339.4195955974
1160.5804044026 1500 1160.5804044026

22 1636 .3934748243 350.0930116622
1636.3934748243 1986.4864864865 1636.3934748243

23 1267 .5685889818 1005.1586837455
1267.5685889818 2272.7272727273 1267.5685889818

24 940.6255600776 566.6957146856
940.6255600776 1507.3212747631 940.6255600776

25 1072.978938556 -527.5243931014
1072.978938556 545.4545454545 1072.978938556

26 1142.3378599983 -543.0112606717
1142.3378599983 599.3265993266 1142.3378599983

27 941.3233140585 -189.5502644131
941.3233140585 751.7730496454 941.3233140585

28 1275.8231472123 268.9685194544
1275.8231472123 1544.7916666667 1275.8231472123

29 1297.95286865 -583.6671543643
1297.95286865 714.2857142857 1297.95286865

30 1071.4837719093 627.8169273914
1071.4837719093 1699.3006993007 1071.4837719093

Sheet 4: Best

Y - Segavilja müük kg/ha
X1 - Segavilja saagikus, kg/ha
X2 - Teravilja müügi osakaal kogumüügist
X3 - Kasvupind kokku, ha
X4 - Investeering kokku, kr

I etapp


Mudelid R2 Korrigeeritud R2 Y = 0,3399 X1 + 561,3110 - segavilja saagikus, kg/ha 0.0744 0.0414 Y = 239,2980 X2 + 1076,6620 - teravilja müügi osakaal kogumüügist 0.0145 -0.0207 Y = 1,2051 X3 + 1025,2940 - kasvupind kokku, ha 0.1707 0.1411 Y = 0,0004 X4 + 1092,6230 - investeering kokku, kr 0.2614 0. 2350

II etapp


Mudelid R2 Korrigeeritud R2 Y = 0,3382 X1 + 233,1088 X2 + 452,3697 0.0881 0. 0206 Y = 0,2110 X1 + 1,0651 X3 + 653,3325 0. 1971 0. 1376 Y = 0,1936 X1 + 0,0004 X4 + 741,0257 0.2840 0.2310 Y = -76,6624 X2 + 1,2469 X3 + 1056, 3789 0.1720 0.1106 Y = 50,4300 X2 + 0,0004 X4 + 1069 ,3041 0.2620 0.2073 Y = -0,7964 X3 + 0,0006 X4 + 1154 ,7115 0.2749 0.2212

III etapp


Mudelid R2 Korrigeeritud R2 Y = 0,2034 X1 - 40,4422 X2 + 1,0889 X3 + 674,2830 0.1974 0.1048 Y = 0,2193 X1 - 0,9624 X3 + 0,0006 X4 + 769,4431 0.3034 0.2230 Y = 0,1950 X1 + 61,7603 X2 + 0,0004 X4 + 709,8422 0.2850 0.2025 Y = 213,9860 X2 - 1,1458 X3 + 0,0007 X4 + 1083,0033 0.2834 0.2008

IV etapp


Mudel R2 Korrigeeritud R2 Y = 0,2374 X1 + 265,4184 X2 - 1,4094 X3 + 0,0007 X4 + 648,6321 0.3163 0.2069

Sõltumatute muutujate arv Mudelite arv Parim R2 Korrigeeritud R2 Sõltumatute muutujate nimetused
1 4 0.2614 0.2350 X4 - investeering kokku, kr
2 6 0.2840 0.2310 X1 - segavilja saagikus kg/ha; X4 - investeering kokku, kr
3 4 0.3034 0.2230 X1 - segavilja saagikus, kg/ha; X3 - kasvupind kokku, ha; X4 - investeering kokku, kr
4 1 0.3163 0.2069 X1 - segavilja saagikus, kg/ha; X2 - teravilja müügi osakaal kogu müügist; X3 - kasvupind kokku, ha; X4 - investeering kokku, kr


Ŷ = 0,2374 X1 + 265,4184 X2 - 1,4094 X3 + 0,0007 X4 + 648,6321


R2= 0.3163

Antud mudel kirjeldab 31,63 % segavilja müügi varieeruvusest


Mitmene korrelatsioonikordaja
Multiple R= 0.5624
Determinatsioonikordaja
R Square= 0.3163
Korrigeeritud det. Kordaja
Adjusted R Square= 0.2069
Jääkstandardhälve
Standard Error= 549.7855

Regressioonikordajad
x1 0.2374 Segavilja saagikus, kg/ha
x2 265.4184 Teravilja müügi osakaal kogumüügist
x3 -1.4094 Kasvupind kokku, ha
x4 0.0007 Investeering kokku, kr

Võrrandi:
Deteminatsioonikordaja
0.3163 Halb mudeli kirjeldatuse tase
Korrelatsiooonikordaja
0.5624 Keskmine seos
Jääkstandardhälve
549.7855
F-kriteerium
2. 8919 Mudel ei ole statistiliselt oluline
Significance F 0.0427

Kõige usaldusväärsem on näitaja X4
Kõige vähem usaldusväärne on X2


Y - Segavilja müük kg/ha

X1 - Segavilja saagikus, kg/ha
Kui segavilja saagikus suureneks 1 kg võrra ha kohta, siis segavilja müük suureneks 0,2374 kg võrra ha kohta.
X2 - Teravilja müügi osakaal kogumüügist
Kui teravilja müügi osakaal kogumüügist suureneks 1 ühiku võrra, siis segavilja müük suureneks 265,4184 kg võrra ha kohta.
X3 - Kasvupind kokku, ha
Kui kasvupind kokku suureneks 1 ha võrra, siis segavilja müük väheneks 1,4094 kg võrra ha kohta.
X4 - Investeering kokku, kr
Kui Investeeringud kokku suureneksid 1 kr võrra, siis segavilja müük suureneks 0,0007 kg võrra ha kohta.

Sheet 5: CP

Segavilja saagikus, kg/ha Teravilja müügi osakaal kogumüügist Kasvupind kokku, ha Investeering kokku, kr Segavilja müük, kg/ha
RESIDUAL OUTPUT Predicted Y Residuals



1144.7032745903 266.8011501885
Vahearvutused
X1 X2 X3 X4 Y
Observation 710.099594684 175.6146910303
R2T 0.3163
2238.9380530974 0.3082771129 124.91 84,492 1411.5044247788
1 1365.1035415489 818.8964584511
1-R2T 0.6837
1700 0.440320407 376.00 102,000 885.7142857143
2 1116.3988982499 -116.3988982499
n 30
2304 0.5555555556 51.00 135,000 2184
3 1153.5655197754 -888.8596374224
T 5
2000 0.113773135 26.40 0 1000
4 946.874330586 66.5484882059
n-T 25
1823.5294117647 0.5131964809 47.50 4,000 264.7058823529
5 1189.7528970118 302.7844164211

1013.422818792 1 147.40 0 1013.422818792
6 1257.2443327976 526.8465762933
Mudel Cp k+1 R Square Adj. R Square Std.Error
2089.552238806 0.3206696716 28.40 0 1492.5373134328
7 1159.4406410715 -753.3103728722
X1 7.844293032 2 0.0744 0.0414 604.4603059831
2386.3636363636 0.4098781537 52.49 10,500 1784.0909090909
8 1061.8880890183 379.0210018908
X2 10.0370878144 2 0.0145 -0.0207 623.7347024417
2498.0842911877 0.0871391819 111.80 75,059 406.1302681992
9 2800.7827066095 -92.9175380702
X3 4.3248422246 2 0.1707 0.1411 572.1690187266
1900 0.9630177664 302.80 191,670 1440.9090909091
10 1147.9043926352 -314.5710593018
X4 1.0081965677 2 0.2614 0.2350 539.9740091914
2707.8651685393 0.9364025006 1,159.75 4,160,342 2707.8651685393
11 1142.1397343743 302.3047100701
X1X2 9.3426942631 3 0.0881 0.0206 610.9737366217
1950 0.4078268349 51.00 0 833.3333333333
12 1001.8258401235 -501.8258401235
X1X3 5.3604530622 3 0.1971 0.1376 573.3285560031
1833.3333333333 0.5913490797 70.00 0 1444.4444444445
13 914.1413670691 -284.1413670691
X1X4 2.1796326299 3 0.2840 0.2310 541.3821979109
1190 0.3651447144 18.60 0 500
14 1204.3952291768 -343.2841180657
X2X3 6.2780697533 3 0.1720 0.1106 582.2188867366
650 0.6219000439 166.40 259,607 630
15 1323.4309259715 -974.9988702224
X2X4 2.9855420624 3 0.2620 0.2073 549.651946195
2500 0.0849347064 46.70 8,000 861.1111111111
16 1113.80848069 -193.1188255176
X3X4 2.5142605106 3 0.2749 0.2212 544.8311834074
2000 1 46.40 0 348.4320557491
17 1009.7514800703 490.2485199298
X1X2X3 7.3475809864 4 0.1974 0.1048 584.1219951159
2300 0.4299838108 191.70 108,119 920.6896551724
18 1180.0388655518 -180.0388655518
X1X3X4 3.4729028416 4 0.3034 0.2230 544.1976030748
1575 0.1712059995 41.30 0 1500
19 1160.5804044026 339.4195955974
X1X2X4 4.1457010814 4 0.2850 0.2025 551.3375231401
1700 0.2144018643 58.30 220,000 1000
20 1636.3934748243 350.0930116622
X2X3X4 4.2014352048 4 0.2834 0.2008 551.9248463714
2100 0.227514471 75.70 85,838 1500
21 1267.5685889818 1005.1586837455
X1X2X3X4 4.9987527278 5 0.3163 0.2069 549.785453752
1500 0.0229441925 195.50 1,294,823 1986.4864864865
22 940.6255600776 566.6957146856

2272.7272727273 0.6515975768 66.36 0 2272.7272727273
23 1072.978938556 -527.5243931014
SUMMARY OUTPUT
1214.4702842377 0.2452189235 55.41 24,000 1507.3212747631
24 1142.3378599983 -543.0112606717

1482.5454545455 0.0679560899 30.80 140,499 545.4545454545
25 941.3233140585 -189.5502644131
Regression Statistics
2498.3164983165 0.9491048758 259.40 20,593 599.3265993266
26 1275.8231472123 268.9685194544
Multiple R 0.5624358723
1382.9787234043 0.4319503474 106.61 0 751.7730496454
27 1297.95286865 -583.6671543643
R Square 0.3163341104
1875 0.9936050606 57.92 0 1544.7916666667
28 1071.4837719093 627.8169273914
Adjusted R Square 0.2069475681
1665.306122449 0.5874487612 53.86 250,000 714.2857142857
29
Standard Error 549.785453752
1293.7062937063 0.7069314636 121.52 142,801 1699.3006993007
30
Observations 30




ANOVA



df SS MS F Significance F

Regression 4 3496460.37945545 874115.094863863 2.8918923996 0.0427090946

Residual 25 7556601.12893193 302264.045157277

Total 29 11053061.5083874





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

Y - Segavilja müük kg/ha Intercept 648.6320797991 438.424874887 1.4794600328 0.1515091294 -254.320845022 1551.5850046201 -254.320845022 1551.5850046201

Segavilja saagikus, kg/ha X1 0.2373893137 0.216458597 1.0966961671 0.2832262354 -0.2084155083 0.6831941357 -0.2084155083 0.6831941357

Teravilja müügi osakaal kogumüügist X2 265.4183613178 385.4448079738 0.6886027671 0.4974142857 -528.4200740736 1059.2567967093 -528.4200740736 1059.2567967093

Kasvupind kokku, ha X3 -1.409442727 1.3160266011 -1.0709834633 0.2944078631 -4.1198502259 1.3009647718 -4.1198502259 1.3009647718

Investeering kokku, kr X4 0.0006959512 0.0003337197 2.0854364618 0.0473952753 8.6426482244664E-006 0.0013832598 8.6426482244664E-006 0.0013832598



Regressioonivõrrandi kordajad:


x1 0.2373893137 kg/ha Kui segavilja saagikus suureneks 1 kg võrra ha kohta, siis segavilja müük suureneks 0,2374 kg võrra ha kohta.

x2 265.4183613178
Kui teravilja müügi osakaal kogumüügist suureneks 1 ühiku võrra, siis segavilja müük suureneks 265,4184 kg võrra ha kohta.

x3 -1.409442727 ha Kui kasvupind kokku suureneks 1 ha võrra, siis segavilja müük väheneks 1,4094 kg võrra ha kohta.

x4 0.0006959512 kr Kui Investeeringud kokku suureneksid 1 kr võrra, siis segavilja müük suureneks 0,0007 kg võrra ha kohta.




Võrrandi:


Deteminatsioonikordaja
0.3163 Halb mudeli kirjeldatuse tase

Korrelatsiooonikordaja
1.0967 Keskmine seos

Jääkstandardhälve
2.0854

F-kriteerium
2.8919 Mudel ei ole statistiliselt oluline

Significance F 0.0427




Kõige usaldusväärsem on näitaja X4


Kõige vähem usaldusväärne on X2

Sheet 6: LMKS

Segavilja saagikus, kg/ha Teravilja müügi osakaal kogumüügist Segavilja toodang, kg Kasvupind kokku, ha Segavilja toodang kasvupinna kohta, kg/ha Segavilja kasvupind, ha Segavilja pindala osakaal kogu kasvupinnast, % Toetused kokku, kr Toetused kasvupinna kohta, kr/ha Investeering kokku, kr Segavilja müük, kg/ha




X1 X2 X3 X4 X5 X6 X7 X8 X9 X10 Y
SUMMARY OUTPUT
3148.1481481482 1 68,000 178.90 380.100615 21.60 12.073784 86,719 484.734489 720,439 3472.2222222222

2238.9380530974 0.3082771129 50,600 124.91 405.091666 22.60 18.093027 51,711 413.986070 84,492 1411.5044247788
Regression Statistics
1700 0.440320407 35,700 376.00 94.946809 21.00 5.585106 89,585 238.257979 102,000 885.7142857143
Multiple R 0.6225908204
3007.6923076923 0.0376854187 39,100 763.00 51.245085 13.00 1.703801 341,721 447.865007 198,000 107.6923076923
R Square 0.3876193297
2304 0.5555555556 28,800 51.00 564.705882 12.50 24.509804 33,597 658.764706 135,000 2184
Adjusted R Square 0.1520883026
3098.5915492958 0.4973633043 22,000 351.10 62.660211 7.10 2.022216 183,869 523.694104 326,772 3563.3802816902
Standard Error 790.6274644582
2000 0.113773135 4,000 26.40 151.515152 2.00 7.575758 16,331 618.598485 0 1000
Observations 37
1823.5294117647 0.5131964809 31,000 47.50 652.631579 17.00 35.789474 10,781 226.968421 4,000 264.7058823529

1013.422818792 1 15,100 147.40 102.442334 14.90 10.108548 60,888 413.080054 0 1013.422818792
ANOVA
1805.8252427185 0.2217146584 18,600 48.30 385.093168 10.30 21.325052 75,817 1569.710145 356,717 116.5048543689

df SS MS F Significance F
2089.552238806 0.3206696716 14,000 28.40 492.957746 6.70 23.591549 36,347 1279.823944 0 1492.5373134328
Regression 10 10287292.6215447 1028729.26215447 1.6457251281 0.1486880311
2386.3636363636 0.4098781537 21,000 52.49 400.076205 8.80 16.765098 32,397 617.203277 10,500 1784.0909090909
Residual 26 16252386.4764445 625091.787555559
2498.0842911877 0.0871391819 65,200 111.80 583.184258 26.10 23.345259 84,918 759.552773 75,059 406.1302681992
Total 36 26539679.0979892
1900 0.9630177664 41,800 302.80 138.044914 22.00 7.265522 105,687 349.032365 191,670 1440.9090909091

2707.8651685393 0.9364025006 48,200 1,159.75 41.560681 17.80 1.534814 528,090 455.348135 4,160,342 2707.8651685393

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0% 1950 0.4078268349 11,700 51.00 229.411765 6.00 11.764706 21,317 417.980392 0 833.3333333333
Segavilja müük, kg/ha Intercept -1151.7357979922 1614.0061535234 -0.7135882323 0.4818387409 -4469.3729281684 2165.901332184 -4469.3729281684 2165.901332184 2500 0.0580059263 12,250 27.00 453.703704 4.90 18.148148 85,336 3160.592593 64,920 418.3673469388
Segavilja saagikus, kg/ha X1 1.2982024316 0.7664765026 1.6937276319 0.1022658724 -0.277312568 2.8737174312 -0.277312568 2.8737174312 1833.3333333333 0.5913490797 16,500 70.00 235.714286 9.00 12.857143 88,018 1257.400000 0 1444.4444444445
Teravilja müügi osakaal kogumüügist X2 823.902090512 485.763400693 1.6960975021 0.1018108379 -174.5988700337 1822.4030510578 -174.5988700337 1822.4030510578 1190 0.3651447144 11,900 18.60 639.784946 10.00 53.763441 53,990 2902.688172 0 500
Segavilja toodang, kg X3 -0.0469358986 0.0377513152 -1.2432917466 0.2248551504 -0.1245348375 0.0306630403 -0.1245348375 0.0306630403 650 0.6219000439 13,000 166.40 78.125000 20.00 12.019231 62,669 376.616587 259,607 630
Kasvupind kokku, ha X4 -1.6421965031 1.5420949904 -1.0649126762 0.2967056248 -4.8120181218 1.5276251157 -4.8120181218 1.5276251157 2500 0.0849347064 9,000 46.70 192.719486 3.60 7.708779 36,479 781.134904 8,000 861.1111111111
Segavilja toodang kasvupinna kohta, kg/ha X5 -1.5518766631 2.8055249521 -0.553150191 0.5848859914 -7.3187157365 4.2149624103 -7.3187157365 4.2149624103 2000 1 57,400 46.40 1237.068966 28.70 61.853448 15,900 342.672414 0 348.4320557491
Segavilja kasvupind, ha X6 84.3327926321 85.9515472674 0.9811666609 0.3355529948 -92.34314134 261.0087266042 -92.34314134 261.0087266042 2300 0.4299838108 33,350 191.70 173.969744 14.50 7.563902 151,720 791.444966 108,119 920.6896551724
Segavilja pindala osakaal kogu kasvupinnast, % X7 6.2120394247 47.493577397 0.1307974628 0.8969423271 -91.4124061037 103.8364849531 -91.4124061037 103.8364849531 1575 0.1712059995 6,300 41.30 152.542373 4.00 9.685230 43,190 1045.762712 0 1500
Toetused kokku, kr X8 -0.0015002276 0.0024626791 -0.6091851757 0.5476884115 -0.006562337 0.0035618818 -0.006562337 0.0035618818 1700 0.2144018643 10,200 58.30 174.957118 6.00 10.291595 25,013 429.039451 220,000 1000
Toetused kasvupinna kohta, kr/ha X9 0.0856755927 0.173640928 0.4934066737 0.6258673459 -0.2712484431 0.4425996285 -0.2712484431 0.4425996285 2100 0.227514471 42,000 75.70 554.821664 20.00 26.420079 67,615 893.196830 85,838 1500
Investeering kokku, kr X10 0.0007564914 0.0003378959 2.2388298566 0.0339437911 6.19364633465845E-005 0.0014510463 6.19364633465845E-005 0.0014510463 1500 0.0229441925 16,650 195.50 85.166240 11.10 5.677749 90,856 464.736573 1,294,823 1986.4864864865

2970.297029703 0.9839064017 60,000 214.40 279.850746 20.20 9.421642 82,330 384.001866 267,000 74.2574257426

2272.7272727273 0.6515975768 10,000 66.36 150.693189 4.40 6.630500 92,852 1399.216395 0 2272.7272727273

1214.4702842377 0.2452189235 14,100 55.41 254.466703 11.61 20.952897 382,392 6901.136979 24,000 1507.3212747631
RESIDUAL OUTPUT
1482.5454545455 0.0679560899 8,154 30.80 264.740260 5.50 17.857143 192,993 6266.006494 140,499 545.4545454545

2498.3164983165 0.9491048758 74,200 259.40 286.044719 29.70 11.449499 359,486 1385.836546 20,593 599.3265993266
Observation Predicted Y Residuals
1382.9787234043 0.4319503474 39,000 106.61 365.819342 28.20 26.451552 238,287 2235.128037 0 751.7730496454
1 2036.8292650963 1435.3929571259
1875 0.9936050606 18,000 57.92 310.773481 9.60 16.574586 105,458 1820.752762 0 1544.7916666667
2 840.2370621074 571.2673626713
1665.306122449 0.5874487612 16,320 53.86 303.007798 9.80 18.195321 124,388 2309.468994 250,000 714.2857142857
3 746.4267107699 139.2875749444
2499.1556906451 0.9678407163 74,000 259.30 285.383725 29.61 11.419206 492,735 1900.250675 1,025,000 496.4539007092
4 398.5986462487 -290.9063385564
1293.7062937063 0.7069314636 18,500 121.52 152.238315 14.30 11.767610 273,846 2253.505596 142,801 1699.3006993007
5 1299.7652309538 884.2347690462


6 2201.7836427821 1361.5966389081


7 1316.4016440847 -316.4016440847


8 754.8580274974 -490.1521451445
Segavilja müük, kg/ha Intercept -1151.7357979922

9 1141.4228900513 -128.0000712593
Segavilja saagikus, kg/ha X1 1.2982024316 Kui segavilja saagikus suureneb 1 kg võrra ha kohta, siis segavilja müük suureneb 1,2982 kg võrra ha kohta.

10 1117.0154456334 -1000.5105912644
Teravilja müügi osakaal kogumüügist X2 823.902090512 Kui tervailja müügi osakaal kogumüügist suureneb 1 ühiku võrra, siis segavilja müük suureneks 823,9021 kg võrra ha kohta.

11 1123.0780759884 369.4592374444
Segavilja toodang, kg X3 -0.0469358986 Kui segavilja toodang suureneks 1 kg võrra, siis segavilja müük väheneks 0,0469 kg võrra ha kohta.

12 1449.7186227808 334.3722863102
Kasvupind kokku, ha X4 -1.6421965031 Kui kasvupind kokku suureneks 1 ha võrra, siis segavilja müük väheneks 1,6422 kg võrra ha kohta.

13 354.7971149212 51.3331532781
Segavilja toodang kasvupinna kohta, kg/ha X5 -1.5518766631 Kui segavilja toodang kasvupinna kohta suureneks 1 kg võrra ha kohta, siis segavilja müük väheneks 1,5519 kg võrra ha kohta.

14 1351.6756813828 89.2334095263
Segavilja kasvupind, ha X6 84.3327926321 Kui segavilja kasvupind suureneks 1ha võrra, siis segavilja müük suureneks 84,3328 kg võrra ha kohta.

15 2808.4585308208 -100.5933622815
Segavilja pindala osakaal kogu kasvupinnast, % X7 6.2120394247 Kui segavilja pindala osakaalu kogu kasvupinnast suurendada 1 % võrra, siis segavilja müük suureneks 6,2120 kg võrra ha kohta.

16 1309.7574651644 -476.424131831
Toetused kokku, kr X8 -0.0015002276 Kui toetused kokku suureneksid 1 kr võrra, siis segavilja müük väheneks 0,0015 kg võrra ha kohta.

17 1536.0065696359 -1117.6392226971
Toetused kasvupinna kohta, kr/ha X9 0.0856755927 Kui toetused kasvupinna kohta suureneksid 1 kr võrra ha kohta, siis segavilja müük suureneks 0,0857 kg võrra ha kohta.

18 1274.8658243581 169.5786200864
Investeering kokku, kr X10 0.0007564914 Kui investeeringud kokku suureneksid 1 kr võrra, siis segavilja müük suureneks 0,0008 kg võrra ha kohta.

19 457.0199955265 42.9800044735


20 1095.7713189274 -465.7713189274
Seose tihedust isel. näitajad:

21 1735.2922458557 -874.1811347446
R2=D 0.3876 Mudel kirjeldab 38,76% söödavilja müügist

22 388.5664530051 -40.134397256
Korr. R Square 0.1521 Mudeli kvaliteet on halb

23 1230 .0903090095 -309.4006538371
Jääkstandardhälve 790.6275

24 856.0418986388 643.9581013612
F-kriteerium 1.6457 Mudel ei ole statistiliselt oluline

25 1121.4460623783 -121.4460623783
Significance F 0.1487

26 696.1035610622 803.8964389378


27 1434.1707441869 552.3157422996
Suurima usaldatavusega näitajad:

28 1785 .8379545548 -1711.5805288122
X10 - investeering kokku, kr - ainuke usaldusväärne

29 1916.2172682722 356.510004455


30 624.2413480734 883.0799266898
Väikseima usaldatavusega näitajad:

31 913.1145932715 -367.660047817
X2 - teravilja müügi osakaal kogu müügist

32 691.8273292278 -92.5007299012
X1 - teravilja saagikus kg/ha

33 802.7682477649 -50.9951981195
X7 - segavilja pindala osakaal kogu kasvupinnast, %

34 1589 .1225979321 -44.3309312654
X3 - segavilja toodang, kg

35 1309.3647047944 -595.0789905087
X4 - kasvupind kokku, ha

36 1315.1464690321 -818.6925683228
X6 - segavilja kasvupind, ha

37 975.3968578496 723.9038414511
X8 - toetused kokku, kr


X5 - segavilja toodang kasvupinna kohta, kg/ha


X9 - toetused kasvupinna kohta, kr/ha

Sheet 7: Statistiliselt usald.

Investeering kokku, kr Segavilja müük, kg/ha




X10 Y
SUMMARY OUTPUT

720,439 3472.2222222222


84,492 1411.5044247788
Regression Statistics

102,000 885.7142857143
Multiple R 0.3577506332

198,000 107.6923076923
R Square 0.1279855156

135,000 2184
Adjusted R Square 0.103070816

326,772 3563.3802816902
Standard Error 813.1593515587

0 1000
Observations 37

4,000 264.7058823529


0 1013.422818792
ANOVA

356,717 116.5048543689

df SS MS F Significance F

0 1492.5373134328
Regression 1 3396694.51203293 3396694.51203293 5.13694798 0.0297094569

10,500 1784.0909090909
Residual 35 23142984.5859563 661228.131027323

75,059 406.1302681992
Total 36 26539679.0979892

191,670 1440.9090909091


4,160,342 2707.8651685393

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0%
0 833.3333333333
Intercept 1069.7286389736 143.694624361 7.4444582999 1.02927772451346E-008 778.013044651 1361.4442332961 778.013044651 1361.4442332961
64,920 418.3673469388
X10 0.0004300501 0.0001897433 2.2664836157 0.0297094569 4.48507053925597E-005 0.0008152495 4.48507053925597E-005 0.0008152495
0 1444.4444444445


0 500
Ŷ = 0,0004 X10 + 1069,7286

259,607 630


8,000 861.1111111111
RESIDUAL OUTPUT

0 348.4320557491

108,119 920.6896551724
Observation Predicted Y Residuals
Predicted Y Y Predicted Y 0 1500
1 1379.5534889775 2092.6687332448
1379.5534889775 3472.2222222222 1379.5534889775 220,000 1000
2 1106.064430382 305.4399943967
1106.064430382 1411.5044247788 1106.064430382 85,838 1500
3 1113.5937471929 -227.8794614786
1113.5937471929 885.7142857143 1113.5937471929 1,294,823 1986.4864864865
4 1154.8785549287 -1047.1862472364
1154.8785549287 107.6923076923 1154.8785549287 267,000 74.2574257426
5 1127.785399852 1056.214600148
1127.785399852 2184 1127.785399852 0 2272.7272727273
6 1210 .2569639053 2353.1233177849
1210.2569639053 3563.3802816902 1210.2569639053 24,000 1507.3212747631
7 1069.7286389736 -69.7286389736
1069.7286389736 1000 1069.7286389736 140,499 545.4545454545
8 1071.4488392959 -806.742956943
1071.4488392959 264.7058823529 1071.4488392959 20,593 599.3265993266
9 1069.7286389736 -56.3058201816
1069.7286389736 1013.422818792 1069.7286389736 0 751.7730496454
10 1223 .1348135683 -1106.6299591994
1223.1348135683 116.5048543689 1223.1348135683 0 1544.7916666667
11 1069.7286389736 422.8086744593
1069.7286389736 1492.5373134328 1069.7286389736 250,000 714.2857142857
12 1074.2441648197 709.8467442712
1074.2441648197 1784.0909090909 1074.2441648197 1,025,000 496.4539007092
13 1102.0077679719 -695.8774997727
1102.0077679719 406.1302681992 1102.0077679719 142,801 1699.3006993007
14 1152.1563379186 288.7527529905
1152.1563379186 1440.9090909091 1152.1563379186
15 2858.8840513192 -151.0188827799
2858.8840513192 2707.8651685393 2858.8840513192

16 1069.7286389736 -236.3953056402
1069.7286389736 833.3333333333 1069.7286389736

17 1097.6474902049 -679.2801432661
1097.6474902049 418.3673469388 1097.6474902049

18 1069.7286389736 374.7158054709
1069.7286389736 1444.4444444445 1069.7286389736

19 1069.7286389736 -569.7286389736
1069.7286389736 500 1069.7286389736

20 1181.372650243 -551.372650243
1181.372650243 630 1181.372650243

21 1073.1690396182 -212.0579285071
1073.1690396182 861.1111111111 1073.1690396182

22 1069.7286389736 -721.2965832244
1069.7286389736 348.4320557491 1069.7286389736

23 1116.2252236359 -195.5355684635
1116.2252236359 920.6896551724 1116.2252236359

24 1069.7286389736 430.2713610264
1069.7286389736 1500 1069.7286389736

25 1164.3396567015 -164.3396567014
1164.3396567015 1000 1164.3396567015

26 1106.6432777905 393.3567222095
1106.6432777905 1500 1106.6432777905

27 1626.5673744621 359.9191120244
1626.5673744621 1986.4864864865 1626.5673744621

28 1184 .5520104888 -1110.2945847462
1184.5520104888 74.2574257426 1184.5520104888

29 1069.7286389736 1202.9986337537
1069.7286389736 2272.7272727273 1069.7286389736

30 1080 .0498409075 427.2714338556
1080.0498409075 1507.3212747631 1080.0498409075

31 1130 .1502452452 -584.6956997906
1130.1502452452 545.4545454545 1130.1502452452

32 1078.584660283 -479.2580609564
1078.584660283 599.3265993266 1078.584660283

33 1069.7286389736 -317.9555893282
1069.7286389736 751.7730496454 1069.7286389736

34 1069.7286389736 475.0630276931
1069.7286389736 1544.7916666667 1069.7286389736

35 1177.2411591189 -462.9554448332
1177.2411591189 714.2857142857 1177.2411591189

36 1510 .5299715694 -1014.0760708602
1510.5299715694 496.4539007092 1510.5299715694

37 1131.1402205307 568.16047877
1131.1402205307 1699.3006993007 1131.1402205307

Sheet 8: X1=Y

Teravilja müügi osakaal kogumüügist Kasvupind kokku, ha Investeering kokku, kr Segavilja saagikus, kg/ha
Segavilja müük, kg/ha


VIF= 1.2446687131
X2 X3 X4 X1=Y
Y
SUMMARY OUTPUT
1 178.90 720,439 3148.1481481482
3472.2222222222

0.3082771129 124.91 84,492 2238.9380530974
1411.5044247788
Regression Statistics
0.440320407 376.00 102,000 1700
885.7142857143
Multiple R 0.4433659456
0.0376854187 763.00 198,000 3007.6923076923
107.6923076923
R Square 0.1965733617
0.5555555556 51.00 135,000 2304
2184
Adjusted R Square 0.1212521143
0.4973633043 351.10 326,772 3098.5915492958
3563.3802816902
Standard Error 536.1476481701
0.113773135 26.40 0 2000
1000
Observations 36
0.5131964809 47.50 4,000 1823.5294117647
264.7058823529

1 147.40 0 1013.422818792
1013.422818792
ANOVA
0.2217146584 48.30 356,717 1805.8252427185
116.5048543689

df SS MS F Significance F
0.3206696716 28.40 0 2089.552238806
1492.5373134328
Regression 3 2250594.36221511 750198.120738371 2.6097996067 0.0684774111
0.4098781537 52.49 10,500 2386.3636363636
1784.0909090909
Residual 32 9198537.62042509 287454.300638284
0.0871391819 111.80 75,059 2498.0842911877
406.1302681992
Total 35 11449131.9826402
0.9630177664 302.80 191,670 1900
1440.9090909091

0.9364025006 1,159.75 4,160,342 2707.8651685393
2707.8651685393

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0% 0.4078268349 51.00 0 1950
833.3333333333
Intercept 1837 .5719613427 167.1753013761 10.9918866377 2.13360622806158E-012 1497 .0470172801 2178.0969054052 1497.0470172801 2178.0969054052 0.0580059263 27.00 64,920 2500
418.3673469388
X2 -110.0228113551 286.3525620035 -0.3842215016 0.7033557273 -693.3038902929 473.2582675826 -693.3038902929 473.2582675826 0.5913490797 70.00 0 1833.3333333333
1444.4444444445
X3 1.5786426687 0.6477303132 2.4371912763 0.0205411709 0.259259202 2.8980261353 0.259259202 2.8980261353 0.3651447144 18.60 0 1190
500
X4 -0.0001987422 0.0002004254 -0.9916018219 0.3288310614 -0.0006069954 0.000209511 -0.0006069954 0.000209511 0.6219000439 166.40 259,607 650
630

0.0849347064 46.70 8,000 2500
861.1111111111

1 46.40 0 2000
348.4320557491

0.4299838108 191.70 108,119 2300
920.6896551724

0.1712059995 41.30 0 1575
1500

0.2144018643 58.30 220,000 1700
1000

0.227514471 75.70 85,838 2100
1500

0.0229441925 195.50 1,294,823 1500
1986.4864864865

0.9839064017 214.40 267,000 2970.297029703
74.2574257426

0.6515975768 66.36 0 2272.7272727273
2272.7272727273

0.2452189235 55.41 24,000 1214.4702842377
1507.3212747631

0.0679560899 30.80 140,499 1482.5454545455
545.4545454545

0.9491048758 259.40 20,593 2498.3164983165
599.3265993266

0.4319503474 106.61 0 1382.9787234043
751.7730496454

0.9936050606 57.92 0 1875
1544.7916666667

0.5874487612 53.86 250,000 1665.306122449
714.2857142857

0.9678407163 259.30 1,025,000 2499.1556906451
496.4539007092

0.7069314636 121.52 142,801 1293.7062937063
1699.3006993007

Sheet 9: X2=Y

Segavilja saagikus, kg/ha Kasvupind kokku, ha Investeering kokku, kr Teravilja müügi osakaal kogumüügist
Segavilja müük, kg/ha


VIF= 1.0669192298
X1 X3 X4 X2=Y
Y
SUMMARY OUTPUT
3148.1481481482 178.90 720,439 1
3472.2222222222

2238.9380530974 124.91 84,492 0.3082771129
1411.5044247788
Regression Statistics
1700 376.00 102,000 0.440320407
885.7142857143
Multiple R 0.2504434603
3007.6923076923 763.00 198,000 0.0376854187
107.6923076923
R Square 0.0627219268
2304 51.00 135,000 0.5555555556
2184
Adjusted R Square -0.0251478926
3098.5915492958 351.10 326,772 0.4973633043
3563.3802816902
Standard Error 0.3302241854
2000 26.40 0 0.113773135
1000
Observations 36
1823.5294117647 47.50 4,000 0.5131964809
264.7058823529

1013.422818792 147.40 0 1
1013.422818792
ANOVA
1805.8252427185 48.30 356,717 0.2217146584
116.5048543689

df SS MS F Significance F
2089.552238806 28.40 0 0.3206696716
1492.5373134328
Regression 3 0.2335170886 0.0778390295 0.7138051183 0.5509814202
2386.3636363636 52.49 10,500 0.4098781537
1784.0909090909
Residual 32 3.4895364032 0.1090480126
2498.0842911877 111.80 75,059 0.0871391819
406.1302681992
Total 35 3.7230534918
1900 302.80 191,670 0.9630177664
1440.9090909091

2707.8651685393 1,159.75 4,160,342 0.9364025006
2707.8651685393

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0% 1950 51.00 0 0.4078268349
833.3333333333
Intercept 0.5016634048 0.2068036646 2.4257955282 0.0210912542 0.0804181267 0.922908683 0.0804181267 0.922908683 2500 27.00 64,920 0.0580059263
418.3673469388
X1 -0.000041738 0.0001086301 -0.3842215016 0.7033557273 -0.0002630102 0.0001795342 -0.0002630102 0.0001795342 1833.3333333333 70.00 0 0.5913490797
1444.4444444445
X3 0.0003176773 0.0004307567 0.7374865273 0.4662002261 -0.0005597455 0.0011951001 -0.0005597455 0.0011951001 1190 18.60 0 0.3651447144
500
X4 0.000000028 1.25230816388984E-007 0.2232337778 0.8247725008 -2.27131076154049E-007 0.000000283 -2.27131076154049E-007 0.000000283 650 166.40 259,607 0.6219000439
630

2500 46.70 8,000 0.0849347064
861.1111111111

2000 46.40 0 1
348.4320557491

2300 191.70 108,119 0.4299838108
920.6896551724

1575 41.30 0 0.1712059995
1500

1700 58.30 220,000 0.2144018643
1000

2100 75.70 85,838 0.227514471
1500

1500 195.50 1,294,823 0.0229441925
1986.4864864865

2970.297029703 214.40 267,000 0.9839064017
74.2574257426

2272.7272727273 66.36 0 0.6515975768
2272.7272727273

1214.4702842377 55.41 24,000 0.2452189235
1507.3212747631

1482.5454545455 30.80 140,499 0.0679560899
545.4545454545

2498.3164983165 259.40 20,593 0.9491048758
599.3265993266

1382.9787234043 106.61 0 0.4319503474
751.7730496454

1875 57.92 0 0.9936050606
1544.7916666667

1665.306122449 53.86 250,000 0.5874487612
714.2857142857

2499.1556906451 259.30 1,025,000 0.9678407163
496.4539007092

1293.7062937063 121.52 142,801 0.7069314636
1699.3006993007

Sheet 10: X3=Y

Segavilja saagikus, kg/ha Teravilja müügi osakaal kogumüügist Investeering kokku, kr Kasvupind kokku, ha
Segavilja müük, kg/ha


VIF= 3.0394821649
X1 X2 X4 X3=Y
Y
SUMMARY OUTPUT
3148.1481481482 1 720,439 178.90
3472.2222222222

2238.9380530974 0.3082771129 84,492 124.91
1411.5044247788
Regression Statistics
1700 0.440320407 102,000 376.00
885.7142857143
Multiple R 0.8191438146
3007.6923076923 0.0376854187 198,000 763.00
107.6923076923
R Square 0.670996589
2304 0.5555555556 135,000 51.00
2184
Adjusted R Square 0.6401525192
3098.5915492958 0.4973633043 326,772 351.10
3563.3802816902
Standard Error 134.3823045742
2000 0.113773135 0 26.40
1000
Observations 36
1823.5294117647 0.5131964809 4,000 47.50
264.7058823529

1013.422818792 1 0 147.40
1013.422818792
ANOVA
1805.8252427185 0.2217146584 356,717 48.30
116.5048543689

df SS MS F Significance F
2089.552238806 0.3206696716 0 28.40
1492.5373134328
Regression 3 1178566.41082949 392855.470276497 21.754476426 7.23086895419927E-008
2386.3636363636 0.4098781537 10,500 52.49
1784.0909090909
Residual 32 577875.321045509 18058.6037826722
2498.0842911877 0.0871391819 75,059 111.80
406.1302681992
Total 35 1756441.731875
1900 0.9630177664 191,670 302.80
1440.9090909091

2707.8651685393 0.9364025006 4,160,342 1,159.75
2707.8651685393

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0% 1950 0.4078268349 0 51.00
833.3333333333
Intercept -119.2088368521 89.1108543778 -1.3377588812 0.1904053274 -300.7217065918 62.3040328875 -300.7217065918 62.3040328875 2500 0.0580059263 64,920 27.00
418.3673469388
X1 0.0991743119 0.0406920511 2.4371912763 0.0205411709 0.0162873166 0.1820613072 0.0162873166 0.1820613072 1833.3333333333 0.5913490797 0 70.00
1444.4444444445
X2 52.6080967964 71.3343157422 0.7374865273 0.4662002261 -92.6951488259 197.9113424187 -92.6951488259 197.9113424187 1190 0.3651447144 0 18.60
500
X4 0.0002196401 3.30694723551269E-005 6.6417782032 1.71638206626879E-007 0.0001522798 0.0002870004 0.0001522798 0.0002870004 650 0.6219000439 259,607 166.40
630

2500 0.0849347064 8,000 46.70
861.1111111111

2000 1 0 46.40
348.4320557491

2300 0.4299838108 108,119 191.70
920.6896551724

1575 0.1712059995 0 41.30
1500

1700 0.2144018643 220,000 58.30
1000

2100 0.227514471 85,838 75.70
1500

1500 0.0229441925 1,294,823 195.50
1986.4864864865

2970.297029703 0.9839064017 267,000 214.40
74.2574257426

2272.7272727273 0.6515975768 0 66.36
2272.7272727273

1214.4702842377 0.2452189235 24,000 55.41
1507.3212747631

1482.5454545455 0.0679560899 140,499 30.80
545.4545454545

2498.3164983165 0.9491048758 20,593 259.40
599.3265993266

1382.9787234043 0.4319503474 0 106.61
751.7730496454

1875 0.9936050606 0 57.92
1544.7916666667

1665.306122449 0.5874487612 250,000 53.86
714.2857142857

2499.1556906451 0.9678407163 1,025,000 259.30
496.4539007092

1293.7062937063 0.7069314636 142,801 121.52
1699.3006993007

Sheet 11: X4=Y

Segavilja saagikus, kg/ha Teravilja müügi osakaal kogumüügist Kasvupind kokku, ha Investeering kokku, kr
Segavilja müük, kg/ha


VIF= 2.6164319774
X1 X2 X3 X4=Y
Y
SUMMARY OUTPUT
3148.1481481482 1 178.90 720,439
3472.2222222222

2238.9380530974 0.3082771129 124.91 84,492
1411.5044247788
Regression Statistics
1700 0.440320407 376.00 102,000
885.7142857143
Multiple R 0.7860026179
3007.6923076923 0.0376854187 763.00 198,000
107.6923076923
R Square 0.6178001153
2304 0.5555555556 51.00 135,000
2184
Adjusted R Square 0.5819688762
3098.5915492958 0.4973633043 351.10 326,772
3563.3802816902
Standard Error 465784.227302512
2000 0.113773135 26.40 0
1000
Observations 36
1823.5294117647 0.5131964809 47.50 4,000
264.7058823529

1013.422818792 1 147.40 0
1013.422818792
ANOVA
1805.8252427185 0.2217146584 48.30 356,717
116.5048543689

df SS MS F Significance F
2089.552238806 0.3206696716 28.40 0
1492.5373134328
Regression 3 11222173217019.3 3740724405673.11 17.2419410927 7.66060893045925E-007
2386.3636363636 0.4098781537 52.49 10,500
1784.0909090909
Residual 32 6942558284921.55 216954946403.798
2498.0842911877 0.0871391819 111.80 75,059
406.1302681992
Total 35 18164731501940.9
1900 0.9630177664 302.80 191,670
1440.9090909091

2707.8651685393 0.9364025006 1,159.75 4,160,342
2707.8651685393

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0% 1950 0.4078268349 51.00 0
833.3333333333
Intercept 111414.21738684 316775.819889986 0.3517131372 0.7273589471 -533837.009681192 756665.444454871 -533837.009681192 756665.444454871 2500 0.0580059263 27.00 64,920
418.3673469388
X1 -149.999843663 151.2702380612 -0.9916018219 0.3288310614 -458.1272340736 158.1275467475 -458.1272340736 158.1275467475 1833.3333333333 0.5913490797 70.00 0
1444.4444444445
X2 55618.9674368465 249151.217063322 0.2232337778 0.8247725008 -451885.451907517 563123.38678121 -451885.451907517 563123.38678121 1190 0.3651447144 18.60 0
500
X3 2638.7425542267 397.2945909192 6.6417782032 1.71638206626878E-007 1829.4799584038 3448.0051500496 1829.4799584038 3448.0051500496 650 0.6219000439 166.40 259,607
630

2500 0.0849347064 46.70 8,000
861.1111111111

2000 1 46.40 0
348.4320557491

2300 0.4299838108 191.70 108,119
920.6896551724

1575 0.1712059995 41.30 0
1500

1700 0.2144018643 58.30 220,000
1000

2100 0.227514471 75.70 85,838
1500

1500 0.0229441925 195.50 1,294,823
1986.4864864865

2970.297029703 0.9839064017 214.40 267,000
74.2574257426

2272.7272727273 0.6515975768 66.36 0
2272.7272727273

1214.4702842377 0.2452189235 55.41 24,000
1507.3212747631

1482.5454545455 0.0679560899 30.80 140,499
545.4545454545

2498.3164983165 0.9491048758 259.40 20,593
599.3265993266

1382.9787234043 0.4319503474 106.61 0
751.7730496454

1875 0.9936050606 57.92 0
1544.7916666667

1665.306122449 0.5874487612 53.86 250,000
714.2857142857

2499.1556906451 0.9678407163 259.30 1,025,000
496.4539007092

1293.7062937063 0.7069314636 121.52 142,801
1699.3006993007

Sheet 12: X1,Y

Segavilja saagikus, kg/ha Segavilja müük, kg/ha


X1 Y

2238.9380530974 1411.5044247788
SUMMARY OUTPUT
1700 885.7142857143

2304 2184
Regression Statistics
2000 1000
Multiple R 0.2728117926
1823.5294117647 264.7058823529
R Square 0.0744262742
1013.422818792 1013.422818792
Adjusted R Square 0.0413700697
2089.552238806 1492.5373134328
Standard Error 604.4603059831
2386.3636363636 1784.0909090909
Observations 30
2498.0842911877 406.1302681992

1900 1440.9090909091
ANOVA
2707.8651685393 2707.8651685393

df SS MS F Significance F
1950 833.3333333333
Regression 1 822638.186131317 822638.186131317 2.25150695 0.1446773732
1833.3333333333 1444.4444444445
Residual 28 10230423.3222561 365372.261509145
1190 500
Total 29 11053061.5083874
650 630

2500 861.1111111111

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0% 2000 348.4320557491
Intercept 561.3110272288 434.3578868617 1.2922777373 0.2068248187 -328.4307585288 1451.0528129863 -328.4307585288 1451.0528129863 2300 920.6896551724
X1 0.3398504773 0.2264911507 1.5005022326 0.1446773732 -0.1240956072 0.8037965618 -0.1240956072 0.8037965618 1575 1500

1700 1000

2100 1500

1500 1986.4864864865

2272.7272727273 2272.7272727273

1214.4702842377 1507.3212747631

1482.5454545455 545.4545454545

2498.3164983165 599.3265993266

1382.9787234043 751.7730496454

1875 1544.7916666667

1665.306122449 714.2857142857

1293.7062937063 1699.3006993007

Sheet 13: X2,Y

Teravilja müügi osakaal kogumüügist Segavilja müük, kg/ha


X2 Y

0.3082771129 1411.5044247788
SUMMARY OUTPUT
0.440320407 885.7142857143

0.5555555556 2184
Regression Statistics
0.113773135 1000
Multiple R 0.1202402697
0.5131964809 264.7058823529
R Square 0.0144577225
1 1013.422818792
Adjusted R Square -0.020740216
0.3206696716 1492.5373134328
Standard Error 623.7347024417
0.4098781537 1784.0909090909
Observations 30
0.0871391819 406.1302681992

0.9630177664 1440.9090909091
ANOVA
0.9364025006 2707.8651685393

df SS MS F Significance F
0.4078268349 833.3333333333
Regression 1 159802.095545819 159802.095545819 0.4107548077 0.526797892
0.5913490797 1444.4444444445
Residual 28 10893259.4128416 389044.979030056
0.3651447144 500
Total 29 11053061.5083874
0.6219000439 630

0.0849347064 861.1111111111

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0% 1 348.4320557491
Intercept 1076.6620281535 212.5423973161 5.0656341593 2.31775893692003E-005 641.2886693237 1512.0353869833 641.2886693237 1512.0353869833 0.4299838108 920.6896551724
X2 239.2979882581 373.3771358215 0.6409015585 0.526797892 -525.5303932111 1004.1263697273 -525.5303932111 1004.1263697273 0.1712059995 1500

0.2144018643 1000

0.227514471 1500

0.0229441925 1986.4864864865

0.6515975768 2272.7272727273

0.2452189235 1507.3212747631

0.0679560899 545.4545454545

0.9491048758 599.3265993266

0.4319503474 751.7730496454

0.9936050606 1544.7916666667

0.5874487612 714.2857142857

0.7069314636 1699.3006993007

Sheet 14: X3,Y

Kasvupind kokku, ha Segavilja müük, kg/ha


X3 Y

124.91 1411.5044247788
SUMMARY OUTPUT
376.00 885.7142857143

51.00 2184
Regression Statistics
26.40 1000
Multiple R 0.4131297797
47.50 264.7058823529
R Square 0.1706762148
147.40 1013.422818792
Adjusted R Square 0.1410575082
28.40 1492.5373134328
Standard Error 572.1690187266
52.49 1784.0909090909
Observations 30
111.80 406.1302681992

302.80 1440.9090909091
ANOVA
1,159.75 2707.8651685393

df SS MS F Significance F
51.00 833.3333333333
Regression 1 1886494.70065189 1886494.70065189 5.7624465873 0.0232626478
70.00 1444.4444444445
Residual 28 9166566.80773549 327377.385990553
18.60 500
Total 29 11053061.5083874
166.40 630

46.70 861.1111111111

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0% 46.40 348.4320557491
Intercept 1025.2939508957 125.3665157845 8.1783715889 6.66714943753862E-009 768.4922880222 1282.0956137691 768.4922880222 1282.0956137691 191.70 920.6896551724
X3 1.205124071 0.5020284214 2.4005096516 0.0232626478 0.1767654808 2.2334826612 0.1767654808 2.2334826612 41.30 1500

58.30 1000

75.70 1500

195.50 1986.4864864865

66.36 2272.7272727273

55.41 1507.3212747631

30.80 545.4545454545

259.40 599.3265993266

106.61 751.7730496454

57.92 1544.7916666667

53.86 714.2857142857

121.52 1699.3006993007

Sheet 15: X4,Y

Investeering kokku, kr Segavilja müük, kg/ha


X4 Y

84,492 1411.5044247788
SUMMARY OUTPUT
102,000 885.7142857143

135,000 2184
Regression Statistics
0 1000
Multiple R 0.5112532056
4,000 264.7058823529
R Square 0.2613798403
0 1013.422818792
Adjusted R Square 0.2350005488
0 1492.5373134328
Standard Error 539.9740091914
10,500 1784.0909090909
Observations 30
75,059 406.1302681992

191,670 1440.9090909091
ANOVA
4,160,342 2707.8651685393

df SS MS F Significance F
0 833.3333333333
Regression 1 2889047.45152551 2889047.45152551 9.9085239294 0.0038847636
0 1444.4444444445
Residual 28 8164014.05686187 291571.93060221
0 500
Total 29 11053061.5083874
259,607 630

8,000 861.1111111111

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0% 0 348.4320557491
Intercept 1092.6229897252 103.4858652251 10.5581857711 2.86303172872259E-011 880.641807131 1304 .6041723194 880.641807131 1304.6041723194 108,119 920.6896551724
X4 0.000406113 0.0001290157 3.1477807944 0.0038847636 0.0001418364 0.0006703896 0.0001418364 0.0006703896 0 1500

220,000 1000

85,838 1500

1,294,823 1986.4864864865

0 2272.7272727273

24,000 1507.3212747631

140,499 545.4545454545

20,593 599.3265993266

0 751.7730496454

0 1544.7916666667

250,000 714.2857142857

142,801 1699.3006993007

Sheet 16: X1,X2,Y

Segavilja saagikus, kg/ha Teravilja müügi osakaal kogumüügist Segavilja müük, kg/ha


X1 X2 Y

2238.9380530974 0.3082771129 1411.5044247788
SUMMARY OUTPUT
1700 0.440320407 885.7142857143

2304 0.5555555556 2184
Regression Statistics
2000 0.113773135 1000
Multiple R 0.2968905477
1823.5294117647 0.5131964809 264.7058823529
R Square 0.0881439973
1013.422818792 1 1013.422818792
Adjusted R Square 0.0205991082
2089.552238806 0.3206696716 1492.5373134328
Standard Error 610.9737366217
2386.3636363636 0.4098781537 1784.0909090909
Observations 30
2498.0842911877 0.0871391819 406.1302681992

1900 0.9630177664 1440.9090909091
ANOVA
2707.8651685393 0.9364025006 2707.8651685393

df SS MS F Significance F
1950 0.4078268349 833.3333333333
Regression 2 974261.023666984 487130.511833492 1.3049691617 0.287742842
1833.3333333333 0.5913490797 1444.4444444445
Residual 27 10078800.4847204 373288.906841496
1190 0.3651447144 500
Total 29 11053061.5083874
650 0.6219000439 630

2500 0.0849347064 861.1111111111

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0% 2000 1 348.4320557491
Intercept 452.3696971793 471.1408624461 0.9601580615 0.3454958106 -514.3314908721 1419.0708852306 -514.3314908721 1419.0708852306 2300 0.4299838108 920.6896551724
X1 0.3381789294 0.2289467552 1.4771073263 0.1512170107 -0.1315810042 0.807938863 -0.1315810042 0.807938863 1575 0.1712059995 1500
X2 233.1087747486 365.7622276026 0.6373232585 0.5292820327 -517.3733170233 983.5908665204 -517.3733170233 983.5908665204 1700 0.2144018643 1000

2100 0.227514471 1500

1500 0.0229441925 1986.4864864865

2272.7272727273 0.6515975768 2272.7272727273

1214.4702842377 0.2452189235 1507.3212747631

1482.5454545455 0.0679560899 545.4545454545

2498.3164983165 0.9491048758 599.3265993266

1382.9787234043 0.4319503474 751.7730496454

1875 0.9936050606 1544.7916666667

1665.306122449 0.5874487612 714.2857142857

1293.7062937063 0.7069314636 1699.3006993007

Sheet 17: X1,X3,Y

Segavilja saagikus, kg/ha Kasvupind kokku, ha Segavilja müük, kg/ha


X1 X3 Y
SUMMARY OUTPUT
2238.9380530974 124.91 1411.5044247788

1700 376.00 885.7142857143
Regression Statistics
2304 51.00 2184
Multiple R 0.4439035139
2000 26.40 1000
R Square 0.1970503297
1823.5294117647 47.50 264.7058823529
Adjusted R Square 0.1375725763
1013.422818792 147.40 1013.422818792
Standard Error 573.3285560031
2089.552238806 28.40 1492.5373134328
Observations 30
2386.3636363636 52.49 1784.0909090909

2498.0842911877 111.80 406.1302681992
ANOVA
1900 302.80 1440.9090909091

df SS MS F Significance F
2707.8651685393 1,159.75 2707.8651685393
Regression 2 2178009.41391384 1089004.70695692 3.3130089576 0.0516764148
1950 51.00 833.3333333333
Residual 27 8875052.09447354 328705.633128649
1833.3333333333 70.00 1444.4444444445
Total 29 11053061.5083874
1190 18.60 500

650 166.40 630

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0% 2500 46.70 861.1111111111
Intercept 653.3325468151 414.4718726052 1.5763012885 0.1266024208 -197.0934798749 1503.7585735051 -197.0934798749 1503.7585735051 2000 46.40 348.4320557491
X1 0.2109550022 0.2240078107 0.9417305651 0.354680909 -0.2486710546 0.670581059 -0.2486710546 0.670581059 2300 191.70 920.6896551724
X3 1.0651462286 0.5245461169 2.0306054976 0.0522502754 -0.0111334889 2.1414259462 -0.0111334889 2.1414259462 1575 41.30 1500

1700 58.30 1000

2100 75.70 1500

1500 195.50 1986.4864864865

2272.7272727273 66.36 2272.7272727273

1214.4702842377 55.41 1507.3212747631

1482.5454545455 30.80 545.4545454545

2498.3164983165 259.40 599.3265993266

1382.9787234043 106.61 751.7730496454

1875 57.92 1544.7916666667

1665.306122449 53.86 714.2857142857

1293.7062937063 121.52 1699.3006993007

Sheet 18: X1,X4,Y

Segavilja saagikus, kg/ha Investeering kokku, kr Segavilja müük, kg/ha


X1 X4 Y
SUMMARY OUTPUT
2238.9380530974 84,492 1411.5044247788

1700 102,000 885.7142857143
Regression Statistics
2304 135,000 2184
Multiple R 0.5329534753
2000 0 1000
R Square 0.2840394068
1823.5294117647 4,000 264.7058823529
Adjusted R Square 0.2310052888
1013.422818792 0 1013.422818792
Standard Error 541.3821979109
2089.552238806 0 1492.5373134328
Observations 30
2386.3636363636 10,500 1784.0909090909

2498.0842911877 75,059 406.1302681992
ANOVA
1900 191,670 1440.9090909091

df SS MS F Significance F
2707.8651685393 4,160,342 2707.8651685393
Regression 2 3139505.03458679 1569752.51729339 5.3557863784 0.0109901371
1950 0 833.3333333333
Residual 27 7913556.47380059 293094.684214837
1833.3333333333 0 1444.4444444445
Total 29 11053061.5083874
1190 0 500

650 259,607 630

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0% 2500 8,000 861.1111111111
Intercept 741.0257280987 394.2469681084 1.8795977853 0.070995686 -67.9022228273 1549.9536790248 -67.9022228273 1549.9536790248 2000 0 348.4320557491
X1 0.1935892083 0.2094199358 0.9244067792 0.3634630963 -0.2361050017 0.6232834183 -0.2361050017 0.6232834183 2300 108,119 920.6896551724
X4 0.0003754488 0.0001335378 2.8115548908 0.009070703 0.0001014519 0.0006494457 0.0001014519 0.0006494457 1575 0 1500

1700 220,000 1000

2100 85,838 1500

1500 1,294,823 1986.4864864865

2272.7272727273 0 2272.7272727273

1214.4702842377 24,000 1507.3212747631

1482.5454545455 140,499 545.4545454545

2498.3164983165 20,593 599.3265993266

1382.9787234043 0 751.7730496454

1875 0 1544.7916666667

1665.306122449 250,000 714.2857142857

1293.7062937063 142,801 1699.3006993007

Sheet 19: X2,X3,Y

Teravilja müügi osakaal kogumüügist Kasvupind kokku, ha Segavilja müük, kg/ha


X2 X3 Y
SUMMARY OUTPUT
0.3082771129 124.91 1411.5044247788

0.440320407 376.00 885.7142857143
Regression Statistics
0.5555555556 51.00 2184
Multiple R 0.4146749913
0.113773135 26.40 1000
R Square 0.1719553484
0.5131964809 47.50 264.7058823529
Adjusted R Square 0.1106187075
1 147.40 1013.422818792
Standard Error 582.2188867366
0.3206696716 28.40 1492.5373134328
Observations 30
0.4098781537 52.49 1784.0909090909

0.0871391819 111.80 406.1302681992
ANOVA
0.9630177664 302.80 1440.9090909091

df SS MS F Significance F
0.9364025006 1,159.75 2707.8651685393
Regression 2 1900633.04242293 950316.521211467 2.8034686278 0.0782935006
0.4078268349 51.00 833.3333333333
Residual 27 9152428.46596445 338978.832072757
0.5913490797 70.00 1444.4444444445
Total 29 11053061.5083874
0.3651447144 18.60 500

0.6219000439 166.40 630

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0% 0.0849347064 46.70 861.1111111111
Intercept 1056.3788574588 198.5973562439 5.3191989936 0.000012932 648.8907460943 1463.8669688233 648.8907460943 1463.8669688233 1 46.40 348.4320557491
X2 -76.6624097101 375.3786065375 -0.2042269015 0.8397078143 -846.8756810127 693.5508615924 -846.8756810127 693.5508615924 0.4299838108 191.70 920.6896551724
X3 1.2468599673 0.5502064428 2.2661675152 0.0316677553 0.1179296105 2.3757903241 0.1179296105 2.3757903241 0.1712059995 41.30 1500

0.2144018643 58.30 1000

0.227514471 75.70 1500

0.0229441925 195.50 1986.4864864865

0.6515975768 66.36 2272.7272727273

0.2452189235 55.41 1507.3212747631

0.0679560899 30.80 545.4545454545

0.9491048758 259.40 599.3265993266

0.4319503474 106.61 751.7730496454

0.9936050606 57.92 1544.7916666667

0.5874487612 53.86 714.2857142857

0.7069314636 121.52 1699.3006993007

Sheet 20: X2,X4,Y

Teravilja müügi osakaal kogumüügist Investeering kokku, kr Segavilja müük, kg/ha


X2 X4 Y
SUMMARY OUTPUT
0.3082771129 84,492 1411.5044247788

0.440320407 102,000 885.7142857143
Regression Statistics
0.5555555556 135,000 2184
Multiple R 0.5118587654
0.113773135 0 1000
R Square 0.2619993957
0.5131964809 4,000 264.7058823529
Adjusted R Square 0.2073326842
1 0 1013.422818792
Standard Error 549.651946195
0.3206696716 0 1492.5373134328
Observations 30
0.4098781537 10,500 1784.0909090909

0.0871391819 75,059 406.1302681992
ANOVA
0.9630177664 191,670 1440.9090909091

df SS MS F Significance F
0.9364025006 4,160,342 2707.8651685393
Regression 2 2895895.43557735 1447947.71778867 4.7926679476 0.0165487687
0.4078268349 0 833.3333333333
Residual 27 8157166.07281003 302117.261955927
0.5913490797 0 1444.4444444445
Total 29 11053061.5083874
0.3651447144 0 500

0.6219000439 259,607 630

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0% 0.0849347064 8,000 861.1111111111
Intercept 1069.3040945883 187.3140861687 5.7086154942 4.57456571614529E-006 684.9673408245 1453.6408483521 684.9673408245 1453.6408483521 1 0 348.4320557491
X2 50.4300239903 334.9620259887 0.1505544512 0.8814463326 -636.8552749204 737.7153229011 -636.8552749204 737.7153229011 0.4299838108 108,119 920.6896551724
X4 0.0004023417 0.0001336957 3.0093845322 0.0056149627 0.0001280208 0.0006766626 0.0001280208 0.0006766626 0.1712059995 0 1500

0.2144018643 220,000 1000

0.227514471 85,838 1500

0.0229441925 1,294,823 1986.4864864865

0.6515975768 0 2272.7272727273

0.2452189235 24,000 1507.3212747631

0.0679560899 140,499 545.4545454545

0.9491048758 20,593 599.3265993266

0.4319503474 0 751.7730496454

0.9936050606 0 1544.7916666667

0.5874487612 250,000 714.2857142857

0.7069314636 142,801 1699.3006993007

Sheet 21: X3,X4,Y

Kasvupind kokku, ha Investeering kokku, kr Segavilja müük, kg/ha


X3 X4 Y
SUMMARY OUTPUT
124.91 84,492 1411.5044247788

376.00 102,000 885.7142857143
Regression Statistics
51.00 135,000 2184
Multiple R 0.5242976288
26.40 0 1000
R Square 0.2748880036
47.50 4,000 264.7058823529
Adjusted R Square 0.2211760038
147.40 0 1013.422818792
Standard Error 544.8311834074
28.40 0 1492.5373134328
Observations 30
52.49 10,500 1784.0909090909

111.80 75,059 406.1302681992
ANOVA
302.80 191,670 1440.9090909091

df SS MS F Significance F
1,159.75 4,160,342 2707.8651685393
Regression 2 3038354.01123257 1519177.00561628 5.1178136153 0.01304574
51.00 0 833.3333333333
Residual 27 8014707.49715481 296841.018413141
70.00 0 1444.4444444445
Total 29 11053061.5083874
18.60 0 500

166.40 259,607 630

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0% 46.70 8,000 861.1111111111
Intercept 1154.7114712224 136.2610019637 8.474262295 4.35999426673284E-009 875.1269923906 1434.2959500542 875.1269923906 1434.2959500542 46.40 0 348.4320557491
X3 -0.7963725921 1.1228941444 -0.7092143067 0.4842711685 -3.1003610379 1.5076158537 -3.1003610379 1.5076158537 191.70 108,119 920.6896551724
X4 0.0006023407 0.0003057767 1.9698708886 0.0591904643 -2.50613404713631E-005 0.0012297427 -2.50613404713631E-005 0.0012297427 41.30 0 1500

58.30 220,000 1000

75.70 85,838 1500

195.50 1,294,823 1986.4864864865

66.36 0 2272.7272727273

55.41 24,000 1507.3212747631

30.80 140,499 545.4545454545

259.40 20,593 599.3265993266

106.61 0 751.7730496454

57.92 0 1544.7916666667

53.86 250,000 714.2857142857

121.52 142,801 1699.3006993007

Sheet 22: X1,X2,X3,Y

Segavilja saagikus, kg/ha Teravilja müügi osakaal kogumüügist Kasvupind kokku, ha Segavilja müük, kg/ha


X1 X2 X3 Y

2238.9380530974 0.3082771129 124.91 1411.5044247788
SUMMARY OUTPUT
1700 0.440320407 376.00 885.7142857143

2304 0.5555555556 51.00 2184
Regression Statistics
2000 0.113773135 26.40 1000
Multiple R 0.4442998483
1823.5294117647 0.5131964809 47.50 264.7058823529
R Square 0.1974023552
1013.422818792 1 147.40 1013.422818792
Adjusted R Square 0.1047949346
2089.552238806 0.3206696716 28.40 1492.5373134328
Standard Error 584.1219951159
2386.3636363636 0.4098781537 52.49 1784.0909090909
Observations 30
2498.0842911877 0.0871391819 111.80 406.1302681992

1900 0.9630177664 302.80 1440.9090909091
ANOVA
2707.8651685393 0.9364025006 1,159.75 2707.8651685393

df SS MS F Significance F
1950 0.4078268349 51.00 833.3333333333
Regression 3 2181900.37375477 727300.124584922 2.1316040767 0.1205121348
1833.3333333333 0.5913490797 70.00 1444.4444444445
Residual 26 8871161.13463261 341198.505178177
1190 0.3651447144 18.60 500
Total 29 11053061.5083874
650 0.6219000439 166.40 630

2500 0.0849347064 46.70 861.1111111111

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0% 2000 1 46.40 348.4320557491
Intercept 674.2829755988 465.6231035592 1.4481304094 0.1595332848 -282.8190116914 1631.384962889 -282.8190116914 1631.384962889 2300 0.4299838108 191.70 920.6896551724
X1 0.2083733586 0.2295018049 0.9079377771 0.3722502177 -0.263374353 0.6801210703 -0.263374353 0.6801210703 1575 0.1712059995 41.30 1500
X2 -40.4421801819 378.7125920277 -0.1067885807 0.9157764386 -818.8970542439 738.01269388 -818.8970542439 738.01269388 1700 0.2144018643 58.30 1000
X3 1.0888764491 0.5787800283 1.8813303773 0.0711698345 -0.100822926 2.2785758242 -0.100822926 2.2785758242 2100 0.227514471 75.70 1500

1500 0.0229441925 195.50 1986.4864864865

2272.7272727273 0.6515975768 66.36 2272.7272727273

1214.4702842377 0.2452189235 55.41 1507.3212747631

1482.5454545455 0.0679560899 30.80 545.4545454545

2498.3164983165 0.9491048758 259.40 599.3265993266

1382.9787234043 0.4319503474 106.61 751.7730496454

1875 0.9936050606 57.92 1544.7916666667

1665.306122449 0.5874487612 53.86 714.2857142857

1293.7062937063 0.7069314636 121.52 1699.3006993007

Sheet 23: X1,X3,X4,Y

Segavilja saagikus, kg/ha Kasvupind kokku, ha Investeering kokku, kr Segavilja müük, kg/ha


X1 X3 X4 Y

2238.9380530974 124.91 84,492 1411.5044247788
SUMMARY OUTPUT
1700 376.00 102,000 885.7142857143

2304 51.00 135,000 2184
Regression Statistics
2000 26.40 0 1000
Multiple R 0.5507876661
1823.5294117647 47.50 4,000 264.7058823529
R Square 0.3033670531
1013.422818792 147.40 0 1013.422818792
Adjusted R Square 0.2229863284
2089.552238806 28.40 0 1492.5373134328
Standard Error 544.1976030748
2386.3636363636 52.49 10,500 1784.0909090909
Observations 30
2498.0842911877 111.80 75,059 406.1302681992

1900 302.80 191,670 1440.9090909091
ANOVA
2707.8651685393 1,159.75 4,160,342 2707.8651685393

df SS MS F Significance F
1950 51.00 0 833.3333333333
Regression 3 3353134.69738709 1117711.5657957 3.7741268747 0.0225839125
1833.3333333333 70.00 0 1444.4444444445
Residual 26 7699926.81100029 296151.031192319
1190 18.60 0 500
Total 29 11053061.5083874
650 166.40 259,607 630

2500 46.70 8,000 861.1111111111

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0% 2000 46.40 0 348.4320557491
Intercept 769.443129367 397.707140836 1.9346977974 0.063977934 -48.0555985612 1586.9418572953 -48.0555985612 1586.9418572953 2300 191.70 108,119 920.6896551724
X1 0.2192537218 0.2126667332 1.0309732908 0.3120489805 -0.2178890046 0.6563964481 -0.2178890046 0.6563964481 1575 41.30 0 1500
X3 -0.9623576927 1.1330846844 -0.8493254793 0.4034530666 -3.2914465952 1.3667312097 -3.2914465952 1.3667312097 1700 58.30 220,000 1000
X4 0.0006085103 0.0003054798 1.9919822335 0.0569727921 -1.94123795957587E-005 0.0012364329 -1.94123795957587E-005 0.0012364329 2100 75.70 85,838 1500

1500 195.50 1,294,823 1986.4864864865

2272.7272727273 66.36 0 2272.7272727273

1214.4702842377 55.41 24,000 1507.3212747631

1482.5454545455 30.80 140,499 545.4545454545

2498.3164983165 259.40 20,593 599.3265993266

1382.9787234043 106.61 0 751.7730496454

1875 57.92 0 1544.7916666667

1665.306122449 53.86 250,000 714.2857142857

1293.7062937063 121.52 142,801 1699.3006993007

Sheet 24: X1,X2,X4,Y

Segavilja saagikus, kg/ha Teravilja müügi osakaal kogumüügist Investeering kokku, kr Segavilja müük, kg/ha


X1 X2 X4 Y

2238.9380530974 0.3082771129 84,492 1411.5044247788
SUMMARY OUTPUT
1700 0.440320407 102,000 885.7142857143

2304 0.5555555556 135,000 2184
Regression Statistics
2000 0.113773135 0 1000
Multiple R 0.533823348
1823.5294117647 0.5131964809 4,000 264.7058823529
R Square 0.2849673668
1013.422818792 1 0 1013.422818792
Adjusted R Square 0.2024636015
2089.552238806 0.3206696716 0 1492.5373134328
Standard Error 551.3375231401
2386.3636363636 0.4098781537 10,500 1784.0909090909
Observations 30
2498.0842911877 0.0871391819 75,059 406.1302681992

1900 0.9630177664 191,670 1440.9090909091
ANOVA
2707.8651685393 0.9364025006 4,160,342 2707.8651685393

df SS MS F Significance F
1950 0.4078268349 0 833.3333333333
Regression 3 3149761.83340868 1049920.61113623 3.4539922579 0.0309085471
1833.3333333333 0.5913490797 0 1444.4444444445
Residual 26 7903299.6749787 303973.064422258
1190 0.3651447144 0 500
Total 29 11053061.5083874
650 0.6219000439 259,607 630

2500 0.0849347064 8,000 861.1111111111

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0% 2000 1 0 348.4320557491
Intercept 709.8422072375 435.91079048 1.6284116446 0.1154963964 -186.1852464274 1605.8696609024 -186.1852464274 1605.8696609024 2300 0.4299838108 108,119 920.6896551724
X1 0.195034811 0.2134160484 0.913871344 0.3691819211 -0.2436481549 0.6337177769 -0.2436481549 0.6337177769 1575 0.1712059995 0 1500
X2 61.7602713682 336.217897328 0.183691207 0.8556807878 -629.3455076093 752.8660503457 -629.3455076093 752.8660503457 1700 0.2144018643 220,000 1000
X4 0.0003706012 0.0001385303 2.6752358385 0.0127456558 8.58481030925588E-005 0.0006553542 8.58481030925588E-005 0.0006553542 2100 0.227514471 85,838 1500

1500 0.0229441925 1,294,823 1986.4864864865

2272.7272727273 0.6515975768 0 2272.7272727273

1214.4702842377 0.2452189235 24,000 1507.3212747631

1482.5454545455 0.0679560899 140,499 545.4545454545

2498.3164983165 0.9491048758 20,593 599.3265993266

1382.9787234043 0.4319503474 0 751.7730496454

1875 0.9936050606 0 1544.7916666667

1665.306122449 0.5874487612 250,000 714.2857142857

1293.7062937063 0.7069314636 142,801 1699.3006993007

Sheet 25: X2,X3,X4,Y

Teravilja müügi osakaal kogumüügist Kasvupind kokku, ha Investeering kokku, kr Segavilja müük, kg/ha


X2 X3 X4 Y

0.3082771129 124.91 84,492 1411.5044247788
SUMMARY OUTPUT
0.440320407 376.00 102,000 885.7142857143

0.5555555556 51.00 135,000 2184
Regression Statistics
0.113773135 26.40 0 1000
Multiple R 0.5323937922
0.5131964809 47.50 4,000 264.7058823529
R Square 0.28344315
1 147.40 0 1013.422818792
Adjusted R Square 0.2007635135
0.3206696716 28.40 0 1492.5373134328
Standard Error 551.9248463714
0.4098781537 52.49 10,500 1784.0909090909
Observations 30
0.0871391819 111.80 75,059 406.1302681992

0.9630177664 302.80 191,670 1440.9090909091
ANOVA
0.9364025006 1,159.75 4,160,342 2707.8651685393

df SS MS F Significance F
0.4078268349 51.00 0 833.3333333333
Regression 3 3132914.57129218 1044304.85709739 3.4282099183 0.0317082317
0.5913490797 70.00 0 1444.4444444445
Residual 26 7920146.9370952 304621.036042123
0.3651447144 18.60 0 500
Total 29 11053061.5083874
0.6219000439 166.40 259,607 630

0.0849347064 46.70 8,000 861.1111111111

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0% 1 46.40 0 348.4320557491
Intercept 1083.0032787978 188.7287413819 5.7384120239 4.84683314854984E-006 695.0657987745 1470.9407588211 695.0657987745 1470.9407588211 0.4299838108 191.70 108,119 920.6896551724
X2 213.9859769631 384.0698726596 0.5571537686 0.5821874784 -575.4809450409 1003 .4528989672 -575.4809450409 1003.4528989672 0.1712059995 41.30 0 1500
X3 -1.1457531425 1.2989107091 -0.8820876866 0.3858120036 -3.815702317 1.524196032 -3.815702317 1.524196032 0.2144018643 58.30 220,000 1000
X4 0.000672426 0.0003343255 2.0112915265 0.0547684817 -1.47898552699655E-005 0.0013596419 -1.47898552699655E-005 0.0013596419 0.227514471 75.70 85,838 1500

0.0229441925 195.50 1,294,823 1986.4864864865

0.6515975768 66.36 0 2272.7272727273

0.2452189235 55.41 24,000 1507.3212747631

0.0679560899 30.80 140,499 545.4545454545

0.9491048758 259.40 20,593 599.3265993266

0.4319503474 106.61 0 751.7730496454

0.9936050606 57.92 0 1544.7916666667

0.5874487612 53.86 250,000 714.2857142857

0.7069314636 121.52 142,801 1699.3006993007

Sheet 26: X1,X2,X3,X4,Y

Segavilja saagikus, kg/ha Teravilja müügi osakaal kogumüügist Kasvupind kokku, ha Investeering kokku, kr Segavilja müük, kg/ha



X1 X2 X3 X4 Y
SUMMARY OUTPUT
2238.9380530974 0.3082771129 124.91 84,492 1411.5044247788

1700 0.440320407 376.00 102,000 885.7142857143
Regression Statistics
2304 0.5555555556 51.00 135,000 2184
Multiple R 0.5624358723
2000 0.113773135 26.40 0 1000
R Square 0.3163341104
1823.5294117647 0.5131964809 47.50 4,000 264.7058823529
Adjusted R Square 0.2069475681
1013.422818792 1 147.40 0 1013.422818792
Standard Error 549.785453752
2089.552238806 0.3206696716 28.40 0 1492.5373134328
Observations 30
2386.3636363636 0.4098781537 52.49 10,500 1784.0909090909

2498.0842911877 0.0871391819 111.80 75,059 406.1302681992
ANOVA
1900 0.9630177664 302.80 191,670 1440.9090909091

df SS MS F Significance F
2707.8651685393 0.9364025006 1,159.75 4,160,342 2707.8651685393
Regression 4 3496460.37945545 874115.094863863 2.8918923996 0.0427090946
1950 0.4078268349 51.00 0 833.3333333333
Residual 25 7556601.12893193 302264.045157277
1833.3333333333 0.5913490797 70.00 0 1444.4444444445
Total 29 11053061.5083874
1190 0.3651447144 18.60 0 500

650 0.6219000439 166.40 259,607 630

Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95,0% Upper 95,0% 2500 0.0849347064 46.70 8,000 861.1111111111
Intercept 648.6320797991 438.424874887 1.4794600328 0.1515091294 -254.320845022 1551.5850046201 -254.320845022 1551.5850046201 2000 1 46.40 0 348.4320557491
X1 0.2373893137 0.216458597 1.0966961671 0.2832262354 -0.2084155083 0.6831941357 -0.2084155083 0.6831941357 2300 0.4299838108 191.70 108,119 920.6896551724
X2 265.4183613178 385.4448079738 0.6886027671 0.4974142857 -528.4200740736 1059.2567967093 -528.4200740736 1059.2567967093 1575 0.1712059995 41.30 0 1500
X3 -1.409442727 1.3160266011 -1.0709834633 0.2944078631 -4.1198502259 1.3009647718 -4.1198502259 1.3009647718 1700 0.2144018643 58.30 220,000 1000
X4 0.0006959512 0.0003337197 2.0854364618 0.0473952753 8.6426482244664E-006 0.0013832598 8.6426482244664E-006 0.0013832598 2100 0.227514471 75.70 85,838 1500

1500 0.0229441925 195.50 1,294,823 1986.4864864865

2272.7272727273 0.6515975768 66.36 0 2272.7272727273

1214.4702842377 0.2452189235 55.41 24,000 1507.3212747631

1482.5454545455 0.0679560899 30.80 140,499 545.4545454545

2498.3164983165 0.9491048758 259.40 20,593 599.3265993266

1382.9787234043 0.4319503474 106.61 0 751.7730496454

1875 0.9936050606 57.92 0 1544.7916666667

1665.306122449 0.5874487612 53.86 250,000 714.2857142857

1293.7062937063 0.7069314636 121.52 142,801 1699.3006993007