Scribd Logo
Upload

Welcome to Scribd!

  • 28 views

    Bank Loan

    Uploaded by

    Anonymous QHinf7yt4u
    The regression analysis found a strong positive linear relationship (R^2 = 0.978) between the independent X variable and the dependent variable based on 24 observations. The intercept was estimated at 261.123 and the coefficient for X Variable 1 was 36.743, both highly significant statistically. The model fits the data very well and Excel is deemed reliable for modeling this single variable linear relationship.

    Copyright:

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

    Bank Loan

    Uploaded by

    Anonymous QHinf7yt4u
    28 views6 pages
    The regression analysis found a strong positive linear relationship (R^2 = 0.978) between the independent X variable and the dependent variable based on 24 observations. The intercept was estimated at 261.123 and the coefficient for X Variable 1 was 36.743, both highly significant statistically. The model fits the data very well and Excel is deemed reliable for modeling this single variable linear relationship.

    Original Description:

    Bank Loan

    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 regression analysis found a strong positive linear relationship (R^2 = 0.978) between the independent X variable and the dependent variable based on 24 observations. The intercept was estimated at 261.123 and the coefficient for X Variable 1 was 36.743, both highly significant statistically. The model fits the data very well and Excel is deemed reliable for modeling this single variable linear relationship.

    Copyright:

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

    Bank Loan

    Uploaded by

    Anonymous QHinf7yt4u
    The regression analysis found a strong positive linear relationship (R^2 = 0.978) between the independent X variable and the dependent variable based on 24 observations. The intercept was estimated at 261.123 and the coefficient for X Variable 1 was 36.743, both highly significant statistically. The model fits the data very well and Excel is deemed reliable for modeling this single variable linear relationship.

    Copyright:

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

    SUMMARY OUTPUT

    Regression Statistics
    Multiple R 0.989028
    R Square 0.978177
    Adjusted R Squar 0.977185
    Standard Error 39.67949
    Observations 24

    ANOVA
    df SS MS F Significance F
    Regression 1 1552596 1552596 986.112 9.08E-20
    Residual 22 34638.16 1574.462
    Total 23 1587234

    Coefficients
    Standard Error t Stat P-value Lower 95%Upper 95%
    Lower 95.0%
    Upper 95.0%
    Intercept 261.1232 16.71897 15.61838 2.17E-13 226.4502 295.7962 226.4502 295.7962
    X Variable 1 36.74348 1.170084 31.40242 9.08E-20 34.31687 39.17008 34.31687 39.17008
    Upper 95.0%
    SUMMARY OUTPUT

    Regression Statistics
    Multiple R 0.989028325
    R Square 0.978177028
    Adjusted R Square 0.977185075
    Standard Error 39.6794883
    Observations 24

    ANOVA
    df SS MS F Significance F
    Regression 1 1552596 1552596 986.112 9.08E-20
    Residual 22 34638.16 1574.462
    Total 23 1587234

    CoefficientsStandard Error t Stat P-value Lower 95%Upper 95%


    Lower 95.0%
    Upper 95.0%
    Intercept 261.1231884 16.71897 15.61838 2.17E-13 226.4502 295.7962 226.4502 295.7962
    X Variable 1 36.74347826 1.170084 31.40242 9.08E-20 34.31687 39.17008 34.31687 39.17008
    *Excel is reliable for a single variable.

    Upper 95.0%
    Month Year 1 Year2 Time Loan
    Jan 297 808 1 297
    Feb 249 809 2 249
    Mar 340 867 3 340
    Apr 406 855 4 406
    May 464 965 5 464
    Jun 481 921 6 481
    Jul 549 956 7 549 L
    Aug 553 990 8 553
    1200
    Sep 556 1019 9 556
    Oct 642 1021 10 642 1000
    Nov 670 1033 11 670
    800
    Dec 712 1127 12 712
    13 808 600
    14 809
    15 867 400

    16 855 200
    17 965
    18 921 0
    1 2 3 4 5 6 7 8 9 10 11
    19 956
    20 990
    21 1019
    22 1021
    23 1033
    24 1127
    Loan

    2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
    Loan

    You might also like