Scribd Logo
Upload

Welcome to Scribd!

  • 2 views

    Statistics Data

    Uploaded by

    ammaraazam169
    project of business statistics

    Copyright:

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

    Statistics Data

    Uploaded by

    ammaraazam169
    2 views9 pages
    project of business statistics

    Original Title

    Statistics Data (3) (2)

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    project of business statistics

    Copyright:

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

    Statistics Data

    Uploaded by

    ammaraazam169
    project of business statistics

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 9

    Year TC ( Billions Rs.

    ) IR(%)

    1993 147.7 9.97


    1994 186.2 12.37
    1995 232 12.34
    1996 273.5 10.37
    1997 284.1 11.38
    1998 308 6.23
    1999 348 4.14
    2000 392.3 4.37
    2001 392 3.15
    2002 404 3.29
    2003 520.8 2.91
    2004 590.4 7.44
    2005 713.5 9.06
    2006 847.2 7.92
    2007 1008.1 7.6
    2008 1161.2 20.29
    2009 1327.4 13.65
    2010 1558 12.94
    2011 1882.7 11.92
    2012 1946.4 9.68
    2013 2254.5 7.69
    2014 2590 7.19
    2015 3112.5 2.53
    2016 3367.9 3.77
    2017 3843.8 4.09
    2018 3828.5 5.08
    2019 3996.7 10.58
    2020 4734 9.74
    2021 6126.1 9.5
    2022 7163.8 19.87
    Mean 1851.38 8.70
    Standard Deviation 1887.76 4.55
    Minimum 147.7 2.53
    Maximum 7163.8 20.29
    Quartile 1 392.08 4.5
    Quartile 3 2981.88 11.18
    Quartile 2(Median) 1084.65 8.49
    n 30 30
    Average/mean 1851.38 8.70
    df 29 29
    LOS 0.05 0.05
    S 1887.76 4.55
    t-tab 2.05 2.05
    S.E 344.66 0.83
    M.E 704.90 1.70
    LCL 1146.48 7.00
    UCL 2556.28 10.40
    T-Cal 5.372 10.485
    Co- Variance
    TC ( Billions Rs.) IR(%)
    TC ( Billions Rs.) 3444845.5
    IR(%) 1584.3 20.0
    PCGDP 668938.6 139.3
    Unemp R (%) 3189.2 0.8
    ED 56853353709285.4 27071252910.5

    Co - Relation
    TC ( Billions Rs.) IR(%)
    TC ( Billions Rs.) 1
    IR(%) 0.191 1
    PCGDP 0.873 0.0755
    Unemp R (%) 0.922 0.0957
    ED 0.975 0.1929

    Regression
    SUMMARY OUTPUT

    Regression Statistics
    Multiple R 0.979245535679651
    R Square 0.958921819148528
    Adjusted R Square 0.952349310212292
    Standard Error 412.079582869043
    Observations 30

    ANOVA
    df SS
    Regression 4 99100124.7482286
    Residual 25 4245239.56543811
    Total 29 103345364.313667
    Coefficients Standard Error
    Intercept -1497.54608006286 256.436619276899
    IR(%) 14.1963577149135 18.2211044739469
    PCGDP 0.607932176932415 0.403818824511493
    Unemp R (%) 211.323420652419 112.000052424148
    ED 3.87E-08 9.2369792253474E-09

    Y = a + bx
    Tax collection = -1497.5+14.196(inflation rate)
    Tax collection = -1497.5+0.6079(Per capita GDP)
    Tax collection = -1497.5+211.32(unemployment rate)
    Tax Collection =-1497.5+3.87(External debt)
    PCGDP Unemp R (%) ED
    413 0.59 24551561529.00
    405 0.59 27390827117.00
    456 0.59 30241086483.00
    461 0.59 29850953918.00
    442 0.59 30095124742.00
    428 0.59 32310194704.00
    421 0.59 34190096147.00
    644 0.59 33109821460.00
    610 0.59 32367945483.00
    600 0.59 34320831456.00
    673 0.58 37037199281.00
    775 0.58 36934077635.00
    833 0.58 34578129332.00
    909 0.58 37723507984.00
    1012 0.4 42604467681.00
    1088 0.42 50185422684.00
    985 0.54 57000598839.00
    1012 0.65 63482952104.00
    1161 0.8 65088322905.00
    1237 3.67 63954134989.00
    1260 2.95 60297830475.00
    1303 1.83 64359863498.00
    1422 3.57 68749830505.00
    1469 2.29 75206431382.00
    1568 3.19 93158143047.00
    1621 3.19 100199117658.00
    1437 4.83 110177707177.00
    1322 6.22 118049163003.00
    1506 6.34 130872548059.00
    1589.00 5.6 126942238477.00
    968.73 1.8 58167670991.8
    420.01 1.90 31939831454.6792
    405 0.4 24551561529
    1621 6.34 130872548059
    602.5 0.59 33379890131.75
    1317.25 3.13 67834453605
    998.5 0.59 46394945182.5
    30 30 30
    968.73 1.82 58167670991.80
    29 29 29
    0.05 0.05 0.05
    420.01 1.90 31939831454.68
    2.05 2.05 2.05
    76.68 0.35 5831388723.55
    156.83 0.71 11926529072.20
    811.90 1.12 46241141919.60
    1125.57 2.53 70094200064
    12.633 5.270 9.975
    ce
    PCGDP Unemp R (%) ED

    170524.9
    585.8 3.5
    11356460292390.7 53952102549.6 986147738908204000000.0

    on
    PCGDP Unemp R (%) ED

    1
    0.7613 1
    0.8757 0.922 1

    MS F Significance F
    24775031.1870571 145.89889925623 6.0762119276141E-17
    169809.582617524
    t Stat P-value Lower 95% Upper 95%Lower 95.0%
    Upper 95.0%
    -5.83982928914616 4.32E-06 -2025.68718380135 -969.405 -2025.687 -969.405
    0.779116202050864 0.4432243543214 -23.3307094229257 51.72342 -23.33071 51.72342
    1.5054577449871 0.1447376840358 -0.223748260476523 1.439613 -0.223748 1.439613
    1.88681537265831 0.0708509371924 -19.3450052255041 441.9918 -19.34501 441.9918
    4.18966191180939 0.0003040095385 1.96759052150284E-08 5.772E-08 1.968E-08 5.772E-08
    Upper 95.0%
    Tax Collection Inflation Rate
    Difference
    Min 147.7 147.7 Min 2.53
    Q1 392.08 244.38 Q1 4.5
    Med 1084.65 692.57 Med 8.49
    Q3 2981.88 1897.23 Q3 11.81
    Max 7163.8 4181.92 Max 20.29

    Box Plot Ch

    0 1000 2000 3000 4000 5000 6000 7000 8000


    0 5 1
    Difference
    2.53
    1.97
    3.99
    3.32
    8.48

    Chart Title

    5 10 15 20 25

    You might also like