Scribd Logo
Upload

Welcome to Scribd!

  • 18 views

    July July: Aboitiz Equity Ventures

    Uploaded by

    Miko Arniño
    The document contains stock price data for Abioutiz Equity Ventures from July 1-28. A linear regression was performed, finding a significant positive relationship between price (y) and date (x) for the first data set with a slope of 0.301 and intercept of 47.06. However, the second data set showed no significant relationship between price (y) and date (x).

    Copyright:

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

    July July: Aboitiz Equity Ventures

    Uploaded by

    Miko Arniño
    18 views3 pages
    The document contains stock price data for Abioutiz Equity Ventures from July 1-28. A linear regression was performed, finding a significant positive relationship between price (y) and date (x) for the first data set with a slope of 0.301 and intercept of 47.06. However, the second data set showed no significant relationship between price (y) and date (x).

    Original Title

    ABOITIZ.xlsx

    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 stock price data for Abioutiz Equity Ventures from July 1-28. A linear regression was performed, finding a significant positive relationship between price (y) and date (x) for the first data set with a slope of 0.301 and intercept of 47.06. However, the second data set showed no significant relationship between price (y) and date (x).

    Copyright:

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

    July July: Aboitiz Equity Ventures

    Uploaded by

    Miko Arniño
    The document contains stock price data for Abioutiz Equity Ventures from July 1-28. A linear regression was performed, finding a significant positive relationship between price (y) and date (x) for the first data set with a slope of 0.301 and intercept of 47.06. However, the second data set showed no significant relationship between price (y) and date (x).

    Copyright:

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

    ABOITIZ EQUITY VENTURES

    July x y x y July x y
    1 1 46.50 11 50.3740 15 11 48.20
    2 2 46.95 12 50.6750 16 12 49.25
    3 3 48.50 13 50.9760 17 13 49.75
    6 4 49.00 14 51.2770 20 14 49.55
    7 5 49.30 15 51.5780 21 15 51.60
    8 6 49.60 16 51.8790 22 16 49.50
    9 7 49.20 17 52.1800 23 17 49.45
    10 8 49.30 18 52.4810 24 18 50.00
    13 9 48.85 19 52.7820 27 19 49.00
    14 10 50.00 20 53.0830 28 20 49.50

    y= 47.063+0.301x y= 57.092+0.177

    SLOPE 0.301212 SLOPE 0.1771871539


    INTERCEPT 47.06333 INTERCEPT 40.414374308

    SUMMARY OUTPUT

    Regression Statistics
    Multiple R 0.8060358
    R Square 0.64969371
    Adjusted R 0.60590542
    Standard E 0.71027097
    Observatio 10

    ANOVA
    df SS MS F Significance F
    Regression 1 7.485121 7.485121 14.83716 0.004864 This is < 0.05, that's why there is significance
    Residual 8 4.035879 0.504485
    Total 9 11.521

    Coefficients
    Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0%
    bo Intercept 47.0633333 0.485207 96.99631 1.425E-13 45.94444 48.1822237 45.944442964
    b1 X Variable 0.30121212 0.078198 3.851903 0.004864 0.120887 0.48153763 0.1208866104

    Intercept= Significant
    X Variable= Significant
    x y
    50.3740 48.20
    50.6750 49.25
    50.9760 49.75
    51.2770 49.55
    51.5780 51.60
    51.8790 49.50
    52.1800 49.45
    52.4810 50.00
    52.7820 49.00
    53.0830 49.50

    092+0.177

    SUMMARY OUTPUT

    Regression Statistics
    Multiple R 0.187626
    R Square 0.035204
    Adjusted R-0.085396
    Standard E 0.896614
    Observatio 10

    ANOVA
    df SS MS F Significance F
    at's why there is significance Regression 1 0.234667 0.234667 0.291904 0.603714 This is > 0.05, that's why
    Residual 8 6.431333 0.803917
    Total 9 6.666

    Upper 95.0% Coefficients


    Standard Error t Stat P-value Lower 95%Upper 95%
    48.18222 bo Intercept 40.41437 16.9669 2.381954 0.04441 1.288626 79.54012
    0.481538 b1 X Variable 0.177187 0.327953 0.540282 0.603714 -0.579075 0.933449

    Intercept= Significant
    X Variable=Not Significant
    This is > 0.05, that's why there is no significance

    Lower 95.0%
    Upper 95.0%
    1.288626 79.54012
    -0.579075 0.933449

    You might also like