Scribd Logo
Upload

Welcome to Scribd!

  • 33 views

    Regression Statistics

    Uploaded by

    Abhishek Negi
    The regression analysis found a strong positive linear relationship between the number of ads (x) and sales (y). The multiple R-squared value was 0.86, indicating that 86% of the variability in sales is explained by the number of ads. The regression equation to predict sales is y = 1.211 + 0.199x.

    Copyright:

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

    Regression Statistics

    Uploaded by

    Abhishek Negi
    33 views14 pages
    The regression analysis found a strong positive linear relationship between the number of ads (x) and sales (y). The multiple R-squared value was 0.86, indicating that 86% of the variability in sales is explained by the number of ads. The regression equation to predict sales is y = 1.211 + 0.199x.

    Original Description:

    ds

    Original Title

    d.s

    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 between the number of ads (x) and sales (y). The multiple R-squared value was 0.86, indicating that 86% of the variability in sales is explained by the number of ads. The regression equation to predict sales is y = 1.211 + 0.199x.

    Copyright:

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

    Regression Statistics

    Uploaded by

    Abhishek Negi
    The regression analysis found a strong positive linear relationship between the number of ads (x) and sales (y). The multiple R-squared value was 0.86, indicating that 86% of the variability in sales is explained by the number of ads. The regression equation to predict sales is y = 1.211 + 0.199x.

    Copyright:

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

    SUMMARY OUTPUT

    Regression Statistics
    Multiple R 0.927906
    R Square 0.86101
    Adjusted R 0.833212
    Standard E 1.33084
    Observatio 7

    ANOVA
    df SS MS F Significance F
    Regression 1 54.85862 54.85862 30.97372 0.002578
    Residual 5 8.85567 1.771134
    Total 6 63.71429

    Coefficients
    Standard Error t Stat P-value Lower 95%Upper 95%
    Lower 95.0%
    Upper 95.0%
    Intercept 1.21134 2.427577 0.498992 0.63896 -5.02894 7.451625 -5.02894 7.451625
    30 0.198969 0.035751 5.565404 0.002578 0.107068 0.29087 0.107068 0.29087
    SUMMARY OUTPUT

    Regression Statistics
    Multiple R 0.927906
    R Square 0.86101
    Adjusted R 0.833212
    Standard E 6.206463
    Observatio 7

    ANOVA
    df SS MS F Significance F
    Regression 1 1193.113 1193.113 30.97372 0.002578
    Residual 5 192.6009 38.52018
    Total 6 1385.714

    Coefficients
    Standard Error t Stat P-value Lower 95%Upper 95%
    Lower 95.0%
    Upper 95.0%
    Intercept 3.991031 11.4615 0.348212 0.741862 -25.4717 33.45375 -25.4717 33.45375
    7 4.327354 0.777545 5.565404 0.002578 2.32861 6.326098 2.32861 6.326098
    SUMMARY OUTPUT

    Regression Statistics
    Multiple R 0.927906
    R Square 0.86101
    Adjusted R 0.833212
    Standard E 6.206463
    Observatio 7

    ANOVA
    df SS MS F Significance F
    Regression 1 1193.113 1193.113 30.97372 0.002578
    Residual 5 192.6009 38.52018
    Total 6 1385.714

    Coefficients
    Standard Error t Stat P-value Lower 95%Upper 95%
    Lower 95.0%
    Upper 95.0%
    Intercept 3.991031 11.4615 0.348212 0.741862 -25.4717 33.45375 -25.4717 33.45375
    7 4.327354 0.777545 5.565404 0.002578 2.32861 6.326098 2.32861 6.326098
    8igf

    Regression Statistics
    Multiple R 0.9595796808
    R Square 0.9207931639
    Adjusted R Square 0.9075920245
    Standard Error 5.7984180416
    Observations 8

    ANOVA
    df SS MS F
    Regression 1 2345.1450892857 2345.1450893 69.7510373444
    Residual 6 201.7299107143 33.621651786
    Total 7 2546.875

    Coefficients Standard Error t Stat P-value


    Intercept 0.1004464286 7.6754764644 0.0130866701 0.9899829385
    no. of ads(x) 4.5758928571 0.5478990048 8.3517086482 0.0001601325

    RESIDUAL OUTPUT

    Observation Predicted sales(y) Residuals


    1 32.1316964286 -2.1316964286
    2 50.4352678571 -5.4352678571
    3 45.859375 4.140625
    4 68.7388392857 6.2611607143
    5 59.5870535714 0.4129464286
    6 77.890625 7.109375
    7 87.0424107143 -7.0424107143
    8 73.3147321429 -3.3147321429
    Significance F
    0.0001601325

    Lower 95% Upper 95% Lower 95.0% Upper 95.0%


    -18.6807678952 18.8816607524 -18.6807678952 18.8816607524
    3.2352322889 5.9165534253 3.2352322889 5.9165534253
    SUMMARY OUTPUT

    Regression Statistics
    Multiple R 0.9647027938
    R Square 0.9306514803
    Adjusted R Square 0.8844191338
    Standard Error 6.1524575322
    Observations 6

    ANOVA
    df SS MS F
    Regression 2 1523.9417989418 761.9708994709 20.1298776937
    Residual 3 113.5582010582 37.8527336861
    Total 5 1637.5

    Coefficients Standard Error t Stat P-value


    Intercept 8.253968254 26.0335203938 0.31705156 0.7719878705
    no. of ads 3.5582010582 0.7075998414 5.0285498245 0.0151539508
    price 0.0529100529 1.6135758999 0.0327905572 0.9759012487

    RESIDUAL OUTPUT

    Observation Predicted sale Residuals


    1 33.8492063492 1.1507936508
    2 51.5343915344 3.4656084656
    3 44.6296296296 -4.6296296296
    4 79.9470899471 -4.9470899471
    5 72.9365079365 7.0634920635
    6 62.1031746032 -2.1031746032
    8u6

    Significance F
    0.0182623135

    Lower 95% Upper 95% Lower 95.0% Upper 95.0%


    -74.5963125367 91.1042490447 -74.5963125367 91.1042490447
    1.3063025574 5.810099559 1.3063025574 5.810099559
    -5.082208608 5.1880287139 -5.082208608 5.1880287139
    sale no. of ads price
    35 7 13
    55 12 11
    40 10 15
    75 20 10
    80 18 12
    60 15 9
    SUMMARY OUTPUT

    Regression Statistics
    Multiple R 0.9182948894
    R Square 0.8432655039
    Adjusted R Square 0.8119186047
    Standard Error 0.936863479
    Observations 7

    ANOVA
    df SS MS F
    Regression 1 23.6114341085 23.6114341085 26.9010819165
    Residual 5 4.3885658915 0.8777131783
    Total 6 28

    Coefficients Standard Error t Stat P-value


    Intercept 2000.8798449612 2.3634859935 846.5799460721 4.364731030574E-14
    sales 0.0800387597 0.0154317606 5.1866252917 0.0035058858

    RESIDUAL OUTPUT

    Observation Predicted year Residuals


    1 2009.6841085271 0.3158914729
    2 2011.6850775194 -0.6850775194
    3 2013.2858527132 -1.2858527132
    4 2012.0852713178 0.9147286822
    5 2014.0862403101 -0.0862403101
    6 2015.2868217054 -0.2868217054
    7 2014.886627907 1.113372093
    Significance F
    0.0035058858

    Lower 95% Upper 95% Lower 95.0% Upper 95.0%


    1994.8043107975 2006.955379125 1994.8043107975 2006.955379125
    0.0403701563 0.1197073631 0.0403701563 0.1197073631
    SUMMARY OUTPUT

    Regression Statistics
    Multiple R 0.9182948894
    R Square 0.8432655039
    Adjusted R Square 0.8119186047
    Standard Error 10.7487540806
    Observations 7

    ANOVA
    df SS MS F
    Regression 1 3108.0357142857 3108.0357142857 26.9010819165
    Residual 5 577.6785714286 115.5357142857
    Total 6 3685.7142857143

    Coefficients Standard Error t Stat P-value


    Intercept -21056.9642857143 4089.0563964086 -5.1495900874 0.0036161296
    year 10.5357142857 2.0313235858 5.1866252917 0.0035058858

    RESIDUAL OUTPUT

    Observation Predicted sales Residuals


    1 119.8214285714 -9.8214285714
    2 130.3571428571 4.6428571429
    3 140.8928571429 14.1071428571
    4 151.4285714286 -11.4285714286
    5 161.9642857143 3.0357142857
    6 172.5 7.5
    7 183.0357142857 -8.0357142857
    Significance F
    0.0035058858

    Lower 95% Upper 95% Lower 95.0% Upper 95.0%


    -31568.2183832148 -10545.7101882138 -31568.2183832148 -10545.7101882138
    5.3140307738 15.7573977977 5.3140307738 15.7573977977
    year sales
    2010 110
    2011 135
    2012 155
    2013 140
    2014 165
    2015 180
    2016 175
    no. of ads(x) sales(y) x Yest=0.1 tg
    7 30
    11 45
    10 50
    15 75
    13 60
    17 85
    19 80
    16 70

    You might also like