Scribd Logo
Upload

Welcome to Scribd!

  • 26 views

    Regression Statistics

    Uploaded by

    neeta
    The document contains the results of a linear regression analysis with one predictor variable. It shows that the regression model has an R-squared value of 0.997, indicating that 99.7% of the variability in the response variable is explained by the predictor variable. The F-statistic of 3530.8 is highly significant with a p-value virtually equal to 0. The intercept is 9.75 and the coefficient for the predictor variable is 4.62.

    Copyright:

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

    Regression Statistics

    Uploaded by

    neeta
    26 views7 pages
    The document contains the results of a linear regression analysis with one predictor variable. It shows that the regression model has an R-squared value of 0.997, indicating that 99.7% of the variability in the response variable is explained by the predictor variable. The F-statistic of 3530.8 is highly significant with a p-value virtually equal to 0. The intercept is 9.75 and the coefficient for the predictor variable is 4.62.

    Original Description:

    q1

    Original Title

    Q1

    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 contains the results of a linear regression analysis with one predictor variable. It shows that the regression model has an R-squared value of 0.997, indicating that 99.7% of the variability in the response variable is explained by the predictor variable. The F-statistic of 3530.8 is highly significant with a p-value virtually equal to 0. The intercept is 9.75 and the coefficient for the predictor variable is 4.62.

    Copyright:

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

    Regression Statistics

    Uploaded by

    neeta
    The document contains the results of a linear regression analysis with one predictor variable. It shows that the regression model has an R-squared value of 0.997, indicating that 99.7% of the variability in the response variable is explained by the predictor variable. The F-statistic of 3530.8 is highly significant with a p-value virtually equal to 0. The intercept is 9.75 and the coefficient for the predictor variable is 4.62.

    Copyright:

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

    SUMMARY OUTPUT

    Regression Statistics
    Multiple R 0.9985868822
    R Square 0.9971757613
    Adjusted R Square 0.9968933375
    Standard Error 14.9536874525
    Observations 12

    ANOVA
    df SS MS F
    Regression 1 789526.87231574 789526.872315736 3530.777235
    Residual 10 2236.1276842638 223.6127684264
    Total 11 791763

    Coefficients Standard Error t Stat P-value


    Intercept 9.7537392478 9.7994467366 0.9953357072 0.343047097
    X Variable 1 4.6158610221 0.0776814933 59.4203436161 4.427099E-14

    RESIDUAL OUTPUT

    Observation Predicted Y Residuals Standard Residuals


    1 102.0709596897 11.9290403103 0.8366687526
    2 914.4624995783 6.5375004217 0.4585215726
    3 540.5777567887 19.4222432113 1.3622205624
    4 240.5467903525 4.4532096475 0.3123353819
    5 572.8887839433 2.1112160567 0.148074653
    6 471.3398414572 3.6601585428 0.2567130467
    7 162.0771529769 -24.0771529769 -1.6887026134
    8 720.5963366504 6.4036633496 0.4491346234
    9 379.0226210153 -4.0226210153 -0.2821351273
    10 688.2853094957 -18.2853094957 -1.2824792849
    11 849.840445269 -21.840445269 -1.5318263351
    12 748.2915027829 13.7084972171 0.9614747682
    Normal Probability Plot
    1000
    800
    600
    400

    Y
    200
    0
    0 20 40 60 80 100 120
    Sample Percentile
    Significance F
    4.427099E-14

    Lower 95% Upper 95% Lower 90.0% Upper 90.0%


    -12.08078875 31.588267 -8.007376987 27.514855483
    4.4427758689 4.7889462 4.475066336 4.7566557086

    PROBABILITY OUTPUT

    Percentile Y
    4.1666666667 114
    12.5 138
    20.833333333 245
    29.166666667 375
    37.5 475
    45.833333333 560
    54.166666667 575
    62.5 670
    70.833333333 727
    79.166666667 762
    87.5 828
    95.833333333 921
    bility Plot

    80 100 120
    centile
    Total Working Hours Sales (RM1000)
    20 114
    196 921
    115 560
    50 245
    122 575
    100 475 1000
    33 138 900
    154 727 f(x) = 4.6158610221x + 9.753739
    800 R² = 0.9971757613
    80 375 700
    147 670
    600
    182 828
    500
    160 762 Axis Title
    400
    300
    200
    100
    0
    0 50 100 150 200 250
    Axis Title
    = 4.6158610221x + 9.7537392478
    = 0.9971757613

    Sales (RM1000)
    Linear (Sales (RM1000))

    100 150 200 250


    Axis Title
    Expenditure Income
    2400 41200
    2650 50100
    2350 52000
    4950 66000
    3100 44500
    2500 37700
    5106 73500 Income
    3100 37500
    2900 56700 80000
    1750 35600 70000
    1450 37500 60000
    2020 36900
    50000
    3750 48200
    40000
    30000
    20000
    10000
    0
    1000 1500 2000 2500 3000 3500 4000 4500 5
    Income

    Income

    3000 3500 4000 4500 5000 5500

    You might also like