stock returns regression in excel

Поділитися
Вставка
  • Опубліковано 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

  • @ImranSayed
    @ImranSayed 9 років тому +12

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

  • @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.

  • @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?

  • @maijuvirtala2190
    @maijuvirtala2190 Рік тому

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

  • @yuriiruban5986
    @yuriiruban5986 4 роки тому +1

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

  • @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 5 років тому +1

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

  • @irenelozano-barker2027
    @irenelozano-barker2027 2 роки тому

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

  • @danialkazi513
    @danialkazi513 7 років тому

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

  • @chzouhri
    @chzouhri 2 роки тому

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

  • @fatimaalbraiki3065
    @fatimaalbraiki3065 Рік тому

    thank you so much...great help

  • @Emotekofficial
    @Emotekofficial Рік тому

    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.

  • @prabhleenkaurmarwah8941
    @prabhleenkaurmarwah8941 6 років тому

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

  • @stephanie3336
    @stephanie3336 7 років тому

    THANK YOU. That was very helpful and easy to understand

  • @alanhill5337
    @alanhill5337 3 роки тому

    Good explanation. Many thanks

  • @yash8995
    @yash8995 4 роки тому

    I LOVE THIS GUY!

  • @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).

  • @serajmehrabkhani7333
    @serajmehrabkhani7333 2 роки тому

    thank you

  • @nouralmassry3592
    @nouralmassry3592 8 років тому +1

    thank you so much sir for being helpful

  • @rajdixit3165
    @rajdixit3165 4 роки тому

    Excellent.. very much informative

  • @aprilchin436
    @aprilchin436 4 роки тому

    Great and informative video, thanks!!

  • @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

  • @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)

  • @tethc7580
    @tethc7580 4 роки тому

    so simple. thanks. mate !!!!!

  • @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.

  • @antonischatzimarkos8858
    @antonischatzimarkos8858 3 роки тому

    you are the best love you

  • @bry77008
    @bry77008 7 років тому

    thanks for the video and good explanation...

  • @geeteshanand958
    @geeteshanand958 4 роки тому

    Thank you so much for this

  • @praburajadurai9750
    @praburajadurai9750 3 роки тому

    What's the basis to take companies for making comparison

  • @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

  • @justbecause6472
    @justbecause6472 5 років тому

    Dude we love you❤️

  • @eyad3774
    @eyad3774 4 роки тому

    and what is about the risk free return?

  • @Leo-tf3rw
    @Leo-tf3rw 3 роки тому

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

  • @imicca
    @imicca 6 років тому

    thanks. great video

  • @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.

  • @virajgawade8832
    @virajgawade8832 7 років тому

    Good One.

  • @gemini22581
    @gemini22581 5 років тому

    why subtract 1?

  • @Icecream-dv8oz
    @Icecream-dv8oz 4 роки тому

    nice!

  • @abeed6690
    @abeed6690 7 років тому

    good !

  • @jmcrapo32
    @jmcrapo32 8 років тому +1

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

    • @samhudson333
      @samhudson333 7 років тому +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.

  • @modefish_
    @modefish_ 7 років тому

    legend

  • @parfinanceph
    @parfinanceph 3 роки тому

    10.56% correlation isn't strong enough

  • @solomonrani7566
    @solomonrani7566 4 роки тому

    Rsquare value is 0.1 and this model sucks

  • @tomboyax7098
    @tomboyax7098 6 років тому

    hard :(