stock returns regression in excel

Поделиться
HTML-код
  • Опубликовано: 25 ноя 2024

Комментарии • 65

  • @2fingeredheshlife171
    @2fingeredheshlife171 8 лет назад +4

    I don't see why this doesn't have a million views. This is one gnarly video. I was able to do it for my paper!

  • @taylorcallejabalbuena1412
    @taylorcallejabalbuena1412 Год назад

    Words cant explain how much this helped me with my research paper. Thank you so much for the great explanation and details

  • @AdvImranAsgar
    @AdvImranAsgar 9 лет назад +12

    Keep it up, u r really contributing to youtube, its creating value

  • @maijuvirtala2190
    @maijuvirtala2190 Год назад

    Thank you, this helped me through my Finance 101 class!

  • @yuriiruban5986
    @yuriiruban5986 5 лет назад +1

    Excellent video and perfect explanation. Many thanks for the video and time dedicated to making this video!

  • @thinklikerich
    @thinklikerich 9 лет назад +6

    Very well done! you have explained some complex concepts in very simple terms. Can you also suggest me some resources from where I may learn statistical terms and their implementation in excel?

  • @irenelozano-barker2027
    @irenelozano-barker2027 2 года назад

    Thank you for your excellent videos, very educational and direct to the point! keep up the good work :)

  • @chzouhri
    @chzouhri 3 года назад

    Thank you a lot for this video! You helped me to save a lot of time

  • @sisasethi6567
    @sisasethi6567 5 лет назад +3

    THIS SO AMAZING FOR MY ASSIGNMENT

  • @warcatbattalion
    @warcatbattalion 6 лет назад +1

    THANKS!I REALLY NEED THIS! I ALMOST FAILED MY COURSE T_T

  • @2011beverly
    @2011beverly 6 лет назад +1

    Thank you helped me a lot, with an assignment I am about to do.

  • @alanhill5337
    @alanhill5337 4 года назад

    Good explanation. Many thanks

  • @danialkazi513
    @danialkazi513 7 лет назад

    Genius! made it soo easy to follow! huge help for my securities analysis class!

  • @rajdixit3165
    @rajdixit3165 4 года назад

    Excellent.. very much informative

  • @fatimaalbraiki3065
    @fatimaalbraiki3065 Год назад

    thank you so much...great help

  • @prabhleenkaurmarwah8941
    @prabhleenkaurmarwah8941 7 лет назад

    Very well explained. It helped me a lot in my project. Thank you!

  • @aprilchin436
    @aprilchin436 4 года назад

    Great and informative video, thanks!!

  • @stephanie3336
    @stephanie3336 8 лет назад

    THANK YOU. That was very helpful and easy to understand

  • @yash8995
    @yash8995 5 лет назад

    I LOVE THIS GUY!

  • @antonischatzimarkos8858
    @antonischatzimarkos8858 4 года назад

    you are the best love you

  • @tethc7580
    @tethc7580 4 года назад

    so simple. thanks. mate !!!!!

  • @user-nu2vc9mp5j
    @user-nu2vc9mp5j 4 года назад +3

    why is s&p the independent variable? it should be the other way around since s&p is the representation off of the rest of market movements depending on the performances of top 500 companies.

  • @nouralmassry3592
    @nouralmassry3592 8 лет назад +1

    thank you so much sir for being helpful

  • @bry77008
    @bry77008 7 лет назад

    thanks for the video and good explanation...

  • @saharsahli947
    @saharsahli947 5 лет назад +2

    Shouldnt we first verify regression assumptions ?

    • @christopherthomas9976
      @christopherthomas9976 4 года назад +1

      Why would you do that though? This is such a powerful method for getting the answer you want (shakes magic 8 ball).

  • @praburajadurai9750
    @praburajadurai9750 3 года назад

    What's the basis to take companies for making comparison

  • @mrskhan8353
    @mrskhan8353 2 года назад

    when we are using daily data of stock index and comparing it with some other variable for which you have also daily data available. For instance, I have been encounavailableterd a problem that daily data of stock is not available as Sat and Sun are off days. What should i do

  • @justbecause6472
    @justbecause6472 6 лет назад

    Dude we love you❤️

  • @serajmehrabkhani7333
    @serajmehrabkhani7333 2 года назад

    thank you

  • @ANA-db9yn
    @ANA-db9yn 4 года назад

    Your chart needs to be colored, for example dots on the Y axis takes RED color and the Y axis BLUE to ease your explanation ! Thanks

  • @Emotekofficial
    @Emotekofficial 2 года назад

    This is good but with R squared of 0.10 interprets there is no Determination i.e. only 10% of variance is identified by the model equation and further with very weak correlation R of 0.31.

  • @SherryXShi
    @SherryXShi 6 лет назад +1

    hi, Codible why did you use adj close price not the close price?

    • @sabbirahmed8870
      @sabbirahmed8870 6 лет назад +2

      Closing price is just the last price in trading day. so if stock split than you could find your stock half at closing and you would die if see your stock price got down from 20 to 10 but you won't find this prom in adjusted price. So it is more acceptable for traders.

  • @geeteshanand958
    @geeteshanand958 5 лет назад

    Thank you so much for this

  • @eyad3774
    @eyad3774 5 лет назад

    and what is about the risk free return?

  • @rabishrestha804
    @rabishrestha804 7 лет назад

    so i download s&p and its one of the company IBM one years or so record right? Hello Sir can you interpret one of the data i prepared... This is from my countries stock exchange.

  • @Leo-tf3rw
    @Leo-tf3rw 3 года назад

    How come the return is negative? did you get the formula right?

  • @imicca
    @imicca 6 лет назад

    thanks. great video

  • @sabbirahmed8870
    @sabbirahmed8870 6 лет назад +2

    Bro, why did you choose IBM with S&P-500. Why the independent variables are S&P and why Dependent variable is IBM?? Btw, Wishes for keeping up.. (y)

  • @virajgawade8832
    @virajgawade8832 7 лет назад

    Good One.

  • @gemini22581
    @gemini22581 5 лет назад

    why subtract 1?

  • @Icecream-dv8oz
    @Icecream-dv8oz 4 года назад

    nice!

  • @abeed6690
    @abeed6690 7 лет назад

    good !

  • @modefish_
    @modefish_ 7 лет назад

    legend

  • @par4tech
    @par4tech 3 года назад

    10.56% correlation isn't strong enough

  • @jmcrapo32
    @jmcrapo32 8 лет назад +1

    should not the S&P 500 be your Y variable?

    • @samhudson333
      @samhudson333 8 лет назад +4

      I don't think so, because it is the independent variable. IBM's growth is dependent on the growth of the market as a whole to an extent, so it is the dependent variable, y.

  • @solomonrani7566
    @solomonrani7566 4 года назад

    Rsquare value is 0.1 and this model sucks

  • @tomboyax7098
    @tomboyax7098 7 лет назад

    hard :(