Рет қаралды 10,319
Investing in the stock market means trying to forecast or do some prediction on where the market will go. One way to do predictions is with regression, more specifically basic linear regression or simple linear regression. Applying simple linear regression to an individual stock may not work out, but for an index of stocks, that might work.
This video will use the S&P500 index as an example of how we can use regression to forecast the index value in the future. As a bonus we can see what the Compounded Annual Growth Rate (CAGR) of the return is to get an idea of what an "annual" return could be based on almost a decade of holding the investment.
0:00 Intro
1:16 Create Scatter X Y Chart
2:11 Add Trendline
2:38 Display Regression Equation
3:10 Functions to get Slope and Y Intercept
3:39 R Squared Explained
4:39 Forecast Example from Regression Equation
5:50 Bonus - Calculation CAGR
8:15 Warren Buffet Strategy
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltraining101.com/p/tr...
📚 Excel Books & Tech Gear ➜ www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ www.tubebuddy.com/et101
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to www.buymeacoffee.com/dough
#excel
#msexcel
#doughexcel