Scribd Logo
Upload

Welcome to Scribd!

  • 76 views

    Worksheet Econometrics - Regression Analysis

    Uploaded by

    Sushant Fotedar
    The document appears to contain statistical data for various Indian states including EDI (economic development index), per capita income, and other economic indicators. It includes the average per capita income for all states as well as calculations for regression analysis, including errors, sums of errors squared, and R-squared value. The regression finds the relationship between EDI and other economic indicators with an R-squared value of 0.62, meaning the model explains 62% of the variation in the data.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Worksheet Econometrics - Regression Analysis

    Uploaded by

    Sushant Fotedar
    76 views3 pages
    The document appears to contain statistical data for various Indian states including EDI (economic development index), per capita income, and other economic indicators. It includes the average per capita income for all states as well as calculations for regression analysis, including errors, sums of errors squared, and R-squared value. The regression finds the relationship between EDI and other economic indicators with an R-squared value of 0.62, meaning the model explains 62% of the variation in the data.

    Original Description:

    Worksheet Econometrics - Regression Analysis

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document appears to contain statistical data for various Indian states including EDI (economic development index), per capita income, and other economic indicators. It includes the average per capita income for all states as well as calculations for regression analysis, including errors, sums of errors squared, and R-squared value. The regression finds the relationship between EDI and other economic indicators with an R-squared value of 0.62, meaning the model explains 62% of the variation in the data.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    76 views3 pages

    Worksheet Econometrics - Regression Analysis

    Uploaded by

    Sushant Fotedar
    The document appears to contain statistical data for various Indian states including EDI (economic development index), per capita income, and other economic indicators. It includes the average per capita income for all states as well as calculations for regression analysis, including errors, sums of errors squared, and R-squared value. The regression finds the relationship between EDI and other economic indicators with an R-squared value of 0.62, meaning the model explains 62% of the variation in the data.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 3

    STATES EDI NSDP(percapita) Xi- Yi-

    A.P 0.67 22835 1319.8823529412 0.0768823529


    Assam 0.477 15623 -5892.1176470588 -0.1161176471
    Bihar 0.321 7598 -13917.1176470588 -0.2721176471
    Haryana 0.612 35779 14263.8823529412 0.0188823529
    H.p 0.707 28415 6899.8823529412 0.1138823529
    Jharkhand 0.381 15904 -5611.1176470588 -0.2121176471
    Kerela 0.772 27824 6308.8823529412 0.1788823529
    M.p 0.481 12577 -8938.1176470588 -0.1121176471
    Manipur 0.598 19625 -1890.1176470588 0.0048823529
    Mizoram 0.661 20618 -897.1176470588 0.0678823529
    Orissa 0.487 15096 -6419.1176470588 -0.1061176471
    Puducherry 0.771 38488 16972.8823529412 0.1778823529
    Punjab 0.634 30158 8642.8823529412 0.0408823529
    Rajasthan 0.582 15420 -6095.1176470588 -0.0111176471
    Sikkim 0.662 22001 485.8823529412 0.0688823529
    T.N 0.741 25898 4382.8823529412 0.1478823529
    U.P 0.526 11898 -9617.1176470588 -0.0671176471
    Average 0.5931176471 21515.1176470588
    BASIC ECONOMETRICS

    (xi.yi) [Xi- ]2 EDI^ Errors= Yi-Y

    101.4756608997 1742089.42560553 0.6090107747 0.0609892253


    684.1788373702 34717050.366782 0.5221687645 -0.0451687645
    3787.0933079585 193686163.602076 0.42553716 -0.10453716
    269.3356608997 203458339.778547 0.7648736394 -0.1528736394
    785.7748373702 47608376.484429 0.6762013483 0.0307986517
    1190.2170726644 31484641.249135 0.5255523759 -0.1445523759
    1128.5477197232 39801996.5432526 0.6690849274 0.1029150726
    1002.1207197232 79889947.0726644 0.4854908994 -0.0044908994
    -9.2282214533 3572544.71972319 0.5703581329 0.0276418671
    -60.8984567474 804820.072664363 0.5823151651 0.0786848349
    681.1816608997 41205071.366782 0.5158229881 -0.0288229881
    3019.176249135 288078735.366782 0.7974935792 -0.0264935792
    353.341366782 74699415.366782 0.6971893716 -0.0631893716
    67.763366782 37150459.1314879 0.5197243763 0.0622756237
    33.4687197232 236081.660899652 0.5989683127 0.0630316873
    648.1509550173 19209657.7197232 0.6458933423 0.0951066577
    645.4783079585 92488951.8373703 0.4773148422 0.0486851578
    14327.1777647059 1189834341.76471 8.881784197E-16

    BETA 2 1.20413214359375E-05 (Beta2 ) 2 1.449934219E-10


    BETA 1 0.3340471997 R2 0.6233047886
    Sum(yi 2 ) Errors 2

    0.0059108962 0.0037196856
    0.013483308 0.0020402173
    0.0740480138 0.0109280178
    0.0003565433 0.0233703496
    0.0129691903 0.0009485569
    0.0449938962 0.0208953894
    0.0319988962 0.0105915122
    0.0125703668 2.01681777654916E-05
    2.383737024E-05 0.0007640728
    0.0046080138 0.0061913032
    0.011260955 0.0008307646
    0.0316421315 0.0007019097
    0.0016713668 0.0039928967
    0.0001236021 0.0038782533
    0.0047447785 0.0039729936
    0.0218691903 0.0090452763
    0.0045047785 0.0023702446
    0.2767797647 0.104261612

    Sum (Errors 2)/Sum(yi2) 0.3766952114


    R 2
    0.6233047886

    You might also like