Cross-correlation analysis of the productivity of sugar beets and factors, that it is formed

Автор: Пользователь скрыл имя, 18 Ноября 2011 в 21:21, курсовая работа

Описание работы

Statistics are social science, which studies the quantitative side of the high-quality certain mass socio-economic phenomena and processes, their structure and distributing, placing in space, direction and speed of time-histories, tendencies and conformities to law of motion, closeness of intercommunications and interdepends.
The quantitative side of any public phenomenon is indissolubly related to his high-quality aspects, because a quantitative dimension does not exist without high-quality definiteness.

Содержание

Entry.............................................................................................................................................4
1. An object, task of statistics, its organization, short history of development and connection, is with other sciences........................................................................................................................................ 5
1.1. An object, task of statistics and its connection, is with other sciences..................................5
1.2. Short history of development of statistics..............................................................................7
2. Statistical estimation of indexes of products of stock-raising and factors, that on it influence.......................................................................................................................................9
2.1. System of indexes of statistics of stock-raising and method of their calculation....................................................................................................................................9
2.2. Statistical groupings and their kinds....................................................................................11
2.3. Distributing rows and them graphic image..........................................................................15
2.4. Summarizing the indexes of distributing rows......................................................................21
2.5. Variation of signs and indexes of their measuring...............................................................29
2.6. Verification of accordance of distributing of frequencies of empiric row to distributing
Theoretical..................................................................................................................................36
2.7. Selective method....................................................................................................................37
3. Cross-correlation analysis of the productivity of sugar beets and factors, that it is formed...........................................................................................................................................40
3.1. Grade correlation..................................................................................................................40
3.2. Linear regression. Determination of parameters of connection and them economic interpretation.................................................................................................................................43
3.3. Measuring of intensity of correlation. Coefficient of simple correlation and his maintenance.................................................................................................................................. 48
3.4. Plural correlation...................................................................................................................50
Conclusions....................................................................................................................................56
List of the used literature...............................................................................................................57

Работа содержит 1 файл

Курсоватна англ.doc

— 1.55 Мб (Скачать)

     Stocked functions which can be the regressions utillized for a construction, limited enough. For this purpose it costs to utillize functions, linear in relation to parameters.

     Will consider a function which is applied during the analysis of agricultural activity more frequent than other:

     лінійна Y = а0 + а1х

     Параметр  а0 лінійного рівняння регресії — це значення у при х = 0. Якщо нуль перебуває в рамках фактичної варіації ознаки х, то а0 — одне із теоретичних значень у, якщо х у досліджуваній сукупності не приймає значень, близьких до 0, то параметр а не має реального змісту.

     Parameter а1 named the coefficient of regression and shows, on how many units will change on the average у at a change х on unit.

     The parameters of equalization of regression calculate the method of leastsquares. The basic condition of this method consists in that a sum of squares of rejections of theoretical values of Y from empiric must be minimum:

     Σ (Y – y)2 = min

     Parameters of equalization regressions which respond to this condition expect the systems of normal equalizations by a decision. This system, for example, for a linear function (at a calculation from frill data) has such kind:

     Σy = na0 + а1Σx

     Σxy = а0Σx + а1Σx2.

     Will calculate данні necessary for a decision systems of equalizations, will erect calculations in a table. 
 

Таблица 27. A information and calculation information is for the calculation of cross-correlation connection between     a yield and charges of forages

yield on a cow,

c

Charges of forages on a cow,

c.f.un.

Calculation sizes (Yx- Yc)^2
У^2 Y*X X^2 Yx
1 38,1 40,4 1451,61 1539,24 1632,16 37,72528 1,15623
2 35,9 37,9 1288,81 1360,61 1436,41 35,67978 0,94133
3 38,4 39,5 1474,56 1516,8 1560,25 36,9889 0,11485
4 37,5 42,3 1406,25 1586,25 1789,29 39,27986 6,91616
5 35,4 36,7 1253,16 1299,18 1346,89 34,69794 3,81054
6 38,2 41,3 1459,24 1577,66 1705,69 38,46166 3,28211
7 36,3 37,6 1317,69 1364,88 1413,76 35,43432 1,47788
8 37,3 38 1391,29 1417,4 1444 35,7616 0,78925
9 41,2 40,2 1697,44 1656,24 1616,04 37,56164 0,83109
10 36 37,4 1296 1346,4 1398,76 35,27068 1,90252
11 38,6 43,1 1489,96 1663,66 1857,61 39,93442 10,7874
12 32,4 37 1049,76 1198,8 1369 34,9434 2,91248
13 39,4 41,5 1552,36 1635,1 1722,25 38,6253 3,90181
14 33,7 37,7 1135,69 1270,49 1421,29 35,51614 1,28564
15 36 38 1296 1368 1444 35,7616 0,78925
16 39 40 1521 1560 1600 37,398 0,5595
17 35,9 37 1288,81 1328,3 1369 34,9434 2,91248
18 37,9 38,5 1436,41 1459,15 1482,25 36,1707 0,22973
19 35,4 38 1253,16 1345,2 1444 35,7616 0,78925
20 31,3 35,4 979,69 1108,02 1253,16 33,63428 9,09457
21 37,5 39,7 1406,25 1488,75 1576,09 37,15254 0,25255
22 38,2 40,6 1459,24 1550,92 1648,36 37,88892 1,53492
23 37,8 39,8 1428,84 1504,44 1584,04 37,23436 0,34148
24 36 37,8 1296 1360,8 1428,84 35,59796 1,10679
25 33,8 37,5 1142,44 1267,5 1406,25 35,3525 1,68351
26 39,4 41,2 1552,36 1623,28 1697,44 38,37984 2,99235
27 32 37,1 1024 1187,2 1376,41 35,02522 2,63991
28 38,3 43 1466,89 1646,9 1849 39,8526 10,2566
29 37,3 42 1391,29 1566,6 1764 39,0344 5,68536
30 35,2 36,6 1239,04 1288,32 1339,56 34,61612 4,13667
bag 1099,4 1172,8 40445,24 43086,09 45975,8 1099.48 85.114
middle 36.65 39.09 1348.175 1436.2 1532.53 36.65 2.837
 

     Utillizing the expected information we can untie the system of equalizations described higher: 
 

     

      30а0+1172,8а1=1099,4             30

      1172,8а0+45975,8а1=43086,6   1172,8

     а0 + 39,09а1=36,65             ІІ - І

     а + 39,2а1=36,74

     0,11а1=0,09

     

     

     Consequently equalization of cross-correlation connection between a yield and charges of forages will have such kind:

     

     Economic maintenance of this equalization is such: the coefficient of regression of а1 shows that in our aggregate with an increase on unit of charges of forages of hopes is increased on the average on 0,8182 c. The parameter of a0=4,67, as a free member of equalization, has only calculation values and not interpreted.

     Putting  in equalization regression of value х, will get the theoretical levels of yield. In our case the parameters of equalization are certain correctly, because .

       
 

yield on a cow,с  
Output of calves, chairmen Calculation sizes (Yx- Yc)^2
У^2 Y*X X^2 Yx
1 38,1 95 1451,61 3619,5 9025 37,43 0,6084
2 35,9 93 1288,81 3338,7 8649 36,23 0,1764
3 38,4 92 1474,56 3532,8 8464 35,63 1,0404
4 37,5 93 1406,25 3487,5 8649 36,23 0,1764
5 35,4 94 1253,16 3327,6 8836 36,83      0,0324
6 38,2 93 1459,24 3552,6 8649 36,23 0,1764
7 36,3 96 1317,69 3484,8 9216 38,03 1,9044
8 37,3 95 1391,29 3543,5 9025 37,43 0,6084
9 41,2 97 1697,44 3996,4 9409 38,63 3,9204
10 36 95 1296 3420 9025 37,43 0,6084
11 38,6 97 1489,96 3744,2 9409 38,63 3,9204
12 32,4 91 1049,76 2948,4 8281 35,03      2,6244
13 39,4 96 1552,36 3782,4 9216 38,03 1,9044
14 33,7 91 1135,69 3066,7 8281 35,03 2,6244
15 36 93 1296 3348 8649 36,23 0,1764
16 39 96 1521 3744 9216 38,03 1,9044
17 35,9 94 1288,81 3374,6 8836 36,83 0,0324
18 37,9 91 1436,41 3448,9 8281 35,03 2,6244
19 35,4 95 1253,16 3363 9025 37,43 0,6084
20 31,3 90 979,69 2817 8100 34,43 4,9284
21 37,5 91 1406,25 3412,5 8281 35,03 2,6244
22 38,2 96 1459,24 3667,2 9216 38,03 1,9044
23 37,8 94 1428,84 3553,2 8836 36,83 0,0324
24 36 92 1296 3312 8464 35,63 1,0404
25 33,8 90 1142,44 3042 8100 34,43 4,9284
26 39,4 95 1552,36 3743 9025 37,43 0,6084
27 32 92 1024 2944 8464 35,63 1,0404
28 38,3 97 1466,89 3715,1 9409 38,63 3,9204
29 37,3 93 1391,29 3468,9 8649 36,23 0,1764
30 35,2 94 1239,04 3308,8 8836 36,83 0,0324
bag 1099,4 2811 40445,24 103107,3 263521 1099,5 46,908
middle 36.65 93,7 1348,175 3436,91 8784,03 36,65 1,5636
 
 
 
 

     

      30а0+2811а1=1099,4                30

      2811а0+263521а2=103107,3    2811

     а0 + 93,7а1=36,65             ІІ - І

     а + 93,75а1=36,68

     0,05а1=0,03

     

       

     Consequently equalization of cross-correlation connection between a yield and charges of forages will have such kind:

     

     Economic maintenance of this equalization is such: coefficient of regression а1 shows that in our aggregate with the increase of output of calves on one head of hopes increased on the average on 0,6с. Parameter а0=-19,57, as a free member of equalization, has only calculation values and not interpreted.

     Putting  in equalization regression of value of õ, will get the theoretical levels of yield. In our case the parameters of equalization are certain correctly, because .

       
 
 
 
 
 
 
 
 
 
 

     3.3. Measuring of intensity of correlation. Coefficient of simple correlation and his maintenance 

     Next to determination of character of connection and effects of influence of factors х on a result the estimation of closeness of connection has an important value, that estimation of co-ordination of variation of associate signs. If influence of factor sign

  x on effective considerable, it will appear in the appropriate change of values y with the change of values , that factor forms variation the influence . In default of connection variation does not depend on variation .

     For the estimation of closeness of connection of statistician utillizes the row of coefficients with such general properties:

     1) in default of any connection the value of coefficient approaches a zero; at functional connection - to unit;

     2) at presence of cross-correlation connection a coefficient is expressed a shot which after an absolute value the greater, than more dense connection.

     Among the measures of closeness of connection most widespread is a coefficient of correlation of Pirsona. This coefficient is reflected by character r. As a sphere of his use is limited to linear dependence, in the name appears a word «linear». Calculation of linear coefficient of correlation r based on the rejections of values of associate signs і from averages.

       The coefficient of correlation, estimating the closeness of connection, specifies also on his direction: at direct connection —a size is positive, at reverse - negative. The signs of coefficients of correlation and regression are identical, sizes them associate functionally.

     Obviously, that at functional connection the actual sum of rejections is evened to maximum, and coefficient of correlation , at cross-correlation connection his absolute value will be the more than more dense connection.

     In practice utillize different modifications of formula of coefficient of correlation. For the estimation of closeness of connection between the amount of charges of forages and yield will take advantage of one of modifications from a formula: 

     

     Separately will expect the index of correlation: 

     

     Divergence between an index and coefficient of correlation is small.

     Will expect the coefficient of determination: 

     

     Consequently, we can assert that in our cross-correlation model of hopes on a cow depends on the expense of forages on 57,76%, and other 42,24% it is other невраховані factors.

     For help F – will check the criterion of Fishera for importance the coefficient of детермінації. At first will formulate a null-hypothesis:

     Н0 – a coefficient of determination is unimportant.

     

     Search a critical point after a table:

     F0,95(p-1;n-p)=F0,95(1;28)=4,2

       To insert ripened calculation value with alternative:

     Fф>Fт, that 38,52>4,2 – a tabular value less than is actual, that decline a null-hypothesis, consequently a coefficient of детермінації is substantial.

     Like taking advantage of information of tables of previous section and will expound them higher will estimate the closeness of connection material between the output of calves and yield:

     

     Separately will expect the index of correlation: 

     

     Will expect the coefficient of determination: 

     

     Consequently, we can assert that in our cross-correlation model of hopes  depends on the output of calves on 35,76%, and other 62,24% it is other невраховані factors.

     For help F – will check the criterion of Fishera for importance the coefficient of детермінації. At first will formulate a null-hypothesis:

     Н0- a coefficient of детермінації is unimportant.

     

     Search a critical point after a table:

     F0,95(p-1;n-p)=F0,95(1;28)=4,2

     Stavlyaemo ripened calculation value with alternative:

     Fф>Fт, that 15,55>4,2 – a tabular value less than is actual, that decline a null-hypothesis, consequently a coefficient of детермінації is substantial.  
 
 
 
 
 
 

3.4 Plural correlation 

      Plural correlation enables to estimate connection of effective sign with any factor at the fixed value other, plugged in a regressive model. In practice often utillize plural, multivariable equalizations of regression, when two influence on the size of effective sign, three, and more factors.

      At the theoretical ground of model and choice of factor signs it follows to take into account the crowd conditions of cross-correlation connection between signs. At presence of connection, what near to functional, estimations of parameters of multivariable equalization of regression will be unreliable. For the estimation of multicolinearity between signs it is enough to calculate the proper coefficients of correlation. If the coefficient of correlation of two factor signs is near to unit, one of them it is needed to eliminate. On this stage it is important not only to choose factors but also expose the structure of intercommunication between them.

      Difficult is a problem of ground of functional connection of type of multivariable type of equalization of regression. The analysis of парних connections is useless, because factors are associate, and to define connection between In and X at the fixed values of other factor signs very difficultly. Therefore in practice more frequent all utillize multivariable linear equalizations and equalizations which over are brought to the linear kind the proper transformations, namely to the kind:

     Ух01х12х2nxn

     where Ух - theoretical values of effective sign;

     а1,а2,аn - parameters of equalization;

     х1,х2,xn - factor signs.

     The parameter of equalization of а1 is named the coefficient of part of regression. He shows, as an effective sign changes in middle у with the change of factor sign х1 на unit, on condition that other factor signs remain unchanging.

     For determination of parameters а1,а2, that at presence of 2 factor signs, it is needed to untie the system of normal equalizations: 

      

     For determination of crowd conditions and form of connection between the probed signs utillize the followings coefficients:

     Parni coefficients of correlation - utillize for measuring of closeness a copula between two probed signs without the account of their co-operating with other signs, plugged in a cross-correlation model:

           

     Partial coefficients of correlation - characterize the closeness of connection of effective sign with the first factor sign on condition that other factor signs of еліміновані:  

     

      The coefficient of plural correlation characterizes the crowd conditions of connection between the probed all models of factor and effective signs: 

      

 

     Coefficient   of determination shows  crowd conditions   connection  between effective and by the aggregate of factor signs, determine after a formula:  

     

     In same queue the plural coefficient of детермінації is laid out on partial coefficients which characterize on how many % variation of effective sign depends on each of factor: 

     

     

   

Информация о работе Cross-correlation analysis of the productivity of sugar beets and factors, that it is formed