stock returns regression in excel

Рет қаралды 164,643

Codible

Күн бұрын

Пікірлер: 65

@2fingeredheshlife171 8 жыл бұрын

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!

@ImranSayed 9 жыл бұрын

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

@danialkazi513 7 жыл бұрын

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

@taylorcallejabalbuena1412 Жыл бұрын

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

@thinklikerich 9 жыл бұрын

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?

@prabhleenkaurmarwah8941 6 жыл бұрын

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

@yuriiruban5986 4 жыл бұрын

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

@stephaniesoscia3336 7 жыл бұрын

THANK YOU. That was very helpful and easy to understand

@2011beverly 5 жыл бұрын

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

@irenelozano-barker2027 2 жыл бұрын

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

@warcatbattalion 6 жыл бұрын

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

@sisasethi6567 4 жыл бұрын

THIS SO AMAZING FOR MY ASSIGNMENT

@user-nu2vc9mp5j 4 жыл бұрын

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.

@chzouhri 2 жыл бұрын

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

@nouralmassry3592 8 жыл бұрын

thank you so much sir for being helpful

@yash8995 4 жыл бұрын

I LOVE THIS GUY!

@maijuvirtala2190 Жыл бұрын

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

@justbecause6472 5 жыл бұрын

Dude we love you❤️

@bry77008 7 жыл бұрын

thanks for the video and good explanation...

@aprilchin436 4 жыл бұрын

Great and informative video, thanks!!

@rabishrestha804 6 жыл бұрын

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.

@rajdixit3165 4 жыл бұрын

Excellent.. very much informative

@alanhill5337 3 жыл бұрын

Good explanation. Many thanks

@geeteshanand958 4 жыл бұрын

Thank you so much for this

@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

@imicca 6 жыл бұрын

thanks. great video

@tethc7580 4 жыл бұрын

so simple. thanks. mate !!!!!

@SherryXShi 6 жыл бұрын

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

@sabbirahmed8870 6 жыл бұрын

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.

@sabbirahmed8870 6 жыл бұрын

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)

@fatimaalbraiki3065 Жыл бұрын

thank you so much...great help

@eyad3774 4 жыл бұрын

and what is about the risk free return?

@saharsahli947 5 жыл бұрын

Shouldnt we first verify regression assumptions ?

@christopherthomas9976 4 жыл бұрын

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

@virajgawade8832 7 жыл бұрын

Good One.

@praburajadurai9750 3 жыл бұрын

What's the basis to take companies for making comparison

@antonischatzimarkos8858 3 жыл бұрын

you are the best love you

@Leo-tf3rw 3 жыл бұрын

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

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

@gemini22581 5 жыл бұрын

why subtract 1?

@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

@serajmehrabkhani7333 2 жыл бұрын

thank you

@abeed6690 7 жыл бұрын

good !

@Icecream-dv8oz 4 жыл бұрын

nice!

@modefish_ 7 жыл бұрын

legend

@jmcrapo32 8 жыл бұрын

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

@samhudson333 7 жыл бұрын

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.