-------------
      name:  <unnamed>
       log:  C:\Users\Alveena\Desktop\SPROJ\Question1.smcl
  log type:  smcl
 opened on:   5 Apr 2020, 20:26:07

. use "C:\Users\Alveena\Desktop\SPROJ\Qs1.dta", clear

.  *Wheat regression:

.  regress n_WheatYield n_WheatThr_G n_WheatHar_G n_WheatThr_P n_WheatHar_P n_BulldozerP n_BulldozerG n_TractorsP n_TractorsG n_ElectP n_ElectG n_DesielP n_DesielG n_Others_Irrig n_Left_Pump n_Wells n_Tubewells n_Tanks n_Canal_Pvt n_Canal_Govt n_Fertilizer

      Source |       SS           df       MS      Number of obs   =        25
-------------+----------------------------------   F(20, 4)        =      1.39
       Model |  7533024.04        20  376651.202   Prob > F        =    0.4101
    Residual |     1080921         4   270230.25   R-squared       =    0.8745
-------------+----------------------------------   Adj R-squared   =    0.2471
       Total |  8613945.04        24  358914.377   Root MSE        =    519.84

---------------+----------------------------------------------------------------
   n_WheatYield |      Coef.    Std. Err.       t    P>|t|      [95% Con f. Interval]
---------------+----------------------------------------------------------------
  n_WheatThr_G |   -111.1696    93.04805     -1.19    0.298     -369.5124     147.1732
  n_WheatHar_G |   -354.6986    308.7953     -1.15    0.315     -1212.052     502.6546
  n_WheatThr_P |     .361501    .9522206      0.38    0.724     -2.282287     3.005289
  n_WheatHar_P |   -51.80561    56.07626     -0.92    0.408     -207.4983      103.887
  n_BulldozerP |    -2.20489    2.914038     -0.76    0.491     -10.29556     5.885777
  n_BulldozerG |   -2.339011    21.39272     -0.11    0.918     -61.73472      57.0567
   n_TractorsP |   -.0357512    .4119353     -0.09    0.935     -1.179467     1.107965
   n_TractorsG |    28.40467    20.82114      1.36    0.244     -29.40408     86.21342
      n_ElectP |   -.1033298    .5194427     -0.20    0.852     -1.545534     1.338874
      n_ElectG |    -11.3867    6.153291     -1.85    0.138     -28.47097     5.697578
     n_DesielP |    3.968472    1.841651      2.15    0.097     -1.144771     9.081716
     n_DesielG |   -61.73345    59.38735     -1.04    0.357     -226.6192     103.1523
n_Others_Irrig |    .0362287     .122328      0.30    0.782     -.3034084     .3758658
   n_Left_Pump |    .0137696    .1047315      0.13    0.902     -.2770117     .3045508
       n_Wells |   -.1113837    .1325423     -0.84    0.448     -.4793801     .2566127
   n_Tubewells |    .0927724    .0577089      1.61    0.183     -.0674532      .252998
       n_Tanks |    .3518409    .8320603      0.42    0.694     -1.958329     2.662011
   n_Canal_Pvt |    .0108259    .0164096      0.66    0.545     -.0347345     .0563863
  n_Canal_Govt |    .0100871    .0153588      0.66    0.547     -.0325558       .05273
  n_Fertilizer |    .0171453    .0146227      1.17    0.306     -.0234539     .0577444
         _cons |    1653.953    197.3077      8.38    0.001      1106.139     2201.767
---------------+----------------------------------------------------------------

. *Rice regression:

. reg n_RiceYield n_RiceHusking n_BulldozerP n_BulldozerG n_TractorsP n_TractorsG n_ElectP n_ElectG n_DesielP n_DesielG n_Others_Irrig n_Left_Pump n_Wells n_Tubewells n_Tanks n_Canal_Pvt n_Canal_Govt n_Fertilizer

      Source |       SS           df       MS      Number of obs   =        25
-------------+----------------------------------   F(17, 7)        =      1.12
       Model |  12456217.7        17   732718.69   Prob > F        =    0.4666
    Residual |  4579722.83         7  654246.118   R-squared       =    0.7312
-------------+----------------------------------   Adj R-squared   =    0.0783
       Total |  17035940.6        24  709830.857   Root MSE        =    808.85

---------------+----------------------------------------------------------------
    n_RiceYield |      Coef.    Std. Err.       t    P>|t|      [95% Con f. Interval]
---------------+----------------------------------------------------------------
 n_RiceHusking |    .8195757    5.825722      0.14    0.892     -12.95607     14.59522
  n_BulldozerP |    1.434933     4.22752      0.34    0.744     -8.561564     11.43143
  n_BulldozerG |    36.94064    32.13883      1.15    0.288     -39.05561     112.9369
   n_TractorsP |    .2953394    .5142327      0.57    0.584     -.9206278     1.511307
   n_TractorsG |    -16.8293     28.5084     -0.59    0.574     -84.24097     50.58236
      n_ElectP |     .166722    .6209361      0.27    0.796     -1.301559     1.635003
      n_ElectG |    7.034629    7.316819      0.96    0.368      -10.2669     24.33616
     n_DesielP |    1.041454    2.553908      0.41    0.696      -4.99758     7.080488
     n_DesielG |    22.34639    82.65946      0.27    0.795     -173.1122      217.805
n_Others_Irrig |   -.3903118    .1818038     -2.15    0.069     -.8202094     .0395858
   n_Left_Pump |     .158684    .1596284      0.99    0.353     -.2187772     .5361453
       n_Wells |   -.0824382    .2302787     -0.36    0.731     -.6269608     .4620843
   n_Tubewells |   -.0527325    .0633208     -0.83    0.432     -.2024623     .0969973
       n_Tanks |   -1.106673    .5198941     -2.13    0.071     -2.336027     .1226809
   n_Canal_Pvt |   -.0002191    .0227843     -0.01    0.993     -.0540954     .0536573
  n_Canal_Govt |   -.0064698    .0146453     -0.44    0.672     -.0411003     .0281608
  n_Fertilizer |     .006783     .016944      0.40    0.701     -.0332833     .0468493
         _cons |    1827.248    263.4229      6.94    0.000      1204.352     2450.145
---------------+----------------------------------------------------------------

. *Sugarcane regression:

.  reg n_SugarcaneYield n_BulldozerP n_BulldozerG n_TractorsP n_TractorsG n_ElectP n_ElectG n_DesielP n_DesielG n_Others_Irrig n_Left_Pump n_Wells n_Tubewells n_Tanks n_Canal_Pvt n_Canal_Govt n_Fertilizer

      Source |       SS           df       MS      Number of obs   =        25
-------------+----------------------------------   F(16, 8)        =      1.61
       Model |  7.8483e+09        16   490517290   Prob > F        =    0.2518
    Residual |  2.4387e+09         8   304834625   R-squared       =    0.7629
-------------+----------------------------------   Adj R-squared   =    0.2888
       Total |  1.0287e+10        24   428623068   Root MSE        =     17460

---------------+----------------------------------------------------------------
 n_SugarcaneY~d |      Coef.    Std. Err.       t    P>|t|      [95% Con f. Interval]
---------------+----------------------------------------------------------------
  n_BulldozerP |     17.9045    82.50094      0.22    0.834      -172.343      208.152
  n_BulldozerG |   -1145.915    683.8403     -1.68    0.132     -2722.854     431.0235
   n_TractorsP |    2.639779    9.756499      0.27    0.794     -19.85875     25.13831
   n_TractorsG |    577.3857    613.5829      0.94    0.374     -837.5389      1992.31
      n_ElectP |    6.243044    12.29426      0.51    0.625     -22.10757     34.59366
      n_ElectG |    207.3303    157.1557      1.32    0.224     -155.0715     569.7321
     n_DesielP |   -46.57523    48.55737     -0.96    0.366     -158.5487     65.39826
     n_DesielG |   -349.0381     1739.04     -0.20    0.846     -4359.272     3661.195
n_Others_Irrig |    5.337011    3.913254      1.36    0.210     -3.686969     14.36099
   n_Left_Pump |    .6823117    3.356519      0.20    0.844     -7.057835     8.422458
       n_Wells |   -3.229845    4.426066     -0.73    0.486     -13.43637     6.976681
   n_Tubewells |   -2.312034    1.343494     -1.72    0.124     -5.410138     .7860694
       n_Tanks |    -14.1914    10.53666     -1.35    0.215     -38.48899     10.10618
   n_Canal_Pvt |   -.0036891    .4443011     -0.01    0.994     -1.028249     1.020871
  n_Canal_Govt |    .1247332     .315083      0.40    0.703     -.6018495     .8513158
  n_Fertilizer |    .4256869    .3601365      1.18    0.271     -.4047894     1.256163
         _cons |    23350.74    5685.417      4.11    0.003      10240.14     36461.34
---------------+----------------------------------------------------------------

. *Maize regression:

.  reg n_MaizeYield n_Maize_ShellerG n_Maize_ShellerP n_BulldozerP n_BulldozerG n_TractorsP n_TractorsG n_ElectP n_ElectG n_DesielP n_DesielG n_Others_Irrig n_Left_Pump n_Wells n_Tubewells n_Tanks n_Canal_Pvt n_Canal_Govt n_Fertilizer

      Source |       SS           df       MS      Number of obs   =        25
-------------+----------------------------------   F(18, 6)        =      1.13
       Model |  7617572.36        18  423198.465   Prob > F        =    0.4763
    Residual |   2255341.4         6  375890.233   R-squared       =    0.7716
-------------+----------------------------------   Adj R-squared   =    0.0863
       Total |  9872913.76        24  411371.407   Root MSE        =     613.1

-----------------+----------------------------------------------------------------
     n_MaizeYield |      Coef.    Std. Err.       t    P>|t|      [95% Con f. Interval]
-----------------+----------------------------------------------------------------
n_Maize_ShellerG |    348.8587    265.8091      1.31    0.237     -301.5526     999.2701
n_Maize_ShellerP |     2.04311     2.30255      0.89    0.409     -3.591027     7.677248
    n_BulldozerP |    8.298136    3.684889      2.25    0.065     -.7184633     17.31474
    n_BulldozerG |   -16.98362    24.22486     -0.70    0.510     -76.25973     42.29248
     n_TractorsP |   -.7176328    .8196015     -0.88    0.415     -2.723125      1.28786
     n_TractorsG |   -24.59578    24.02369     -1.02    0.345     -83.37963     34.18808
        n_ElectP |   -.2478824    .4817324     -0.51    0.625     -1.426639     .9308744
        n_ElectG |    8.037826    5.960011      1.35    0.226     -6.545796     22.62145
       n_DesielP |   -4.773725    2.217444     -2.15    0.075     -10.19962     .6521657
       n_DesielG |    189.3155    92.60427      2.04    0.087     -37.27899       415.91
  n_Others_Irrig |   -.1655535     .147318     -1.12    0.304     -.5260277     .1949207
     n_Left_Pump |   -.2142666     .136099     -1.57    0.166     -.5472887     .1187556
         n_Wells |    .3201051    .1759097      1.82    0.119     -.1103305     .7505407
     n_Tubewells |   -.0224371    .0509068     -0.44    0.675     -.1470015     .1021273
         n_Tanks |   -.4549313     .395585     -1.15    0.294     -1.422893     .5130305
     n_Canal_Pvt |    .0098897    .0157689      0.63    0.554     -.0286953     .0484747
    n_Canal_Govt |    .0233338    .0191679      1.22    0.269     -.0235682     .0702359
    n_Fertilizer |    .0198573    .0156289      1.27    0.251     -.0183853     .0580999
           _cons |    1562.026    214.5454      7.28    0.000      1037.053         2087
-----------------+----------------------------------------------------------------

. log close
      name:  <unnamed>
       log:  C:\Users\Alveena\Desktop\SPROJ\Question1.smcl
  log type:  smcl
 closed on:   5 Apr 2020, 20:28:22
-------------