In this video, the instructor demonstrates the meaning of confidence intervals around a forecast.
- [Instructor] Now we've run our regression…and we have coefficients that we can use…to make a prediction,…but what we don't know yet…is how confident we can be in those coefficients.…We don't have a way to stress test those coefficients…to figure out whether or not the predictions…that we're going to make based on them…are going to be particularly accurate or not.…That's what we're going to talk about in just a moment.…I'm in the 0402 folder using the begin financial data file.…
If you recall, we've got a variety of different data points…almost 400,000 rows of data,…and roughly a dozen different variables…covering various corporate financial characteristics…along with sales of the firm,…and we were trying to predict the sales…of a company based on that.…To that end, in sheet one we ran this regression,…and we saw that the regression was reasonable overall.…We had a 45% R squared…and our coefficients looked highly statistically significant…based on the P values.…
But what we don't know yet is whether or not…those coefficients are particularly precise or accurate.…
Author
Michael McDonald
Released
7/5/2017Join Professor Michael McDonald and discover how to use predictive analytics to forecast key performance indicators of interest, such as quarterly sales, projected cash flow, or even optimized product pricing. All you need is Microsoft Excel. Michael uses the built-in formulas, functions, and calculations to perform regression analysis, calculate confidence intervals, and stress test your results. You'll walk away from the course able to immediately begin creating forecasts for your own business needs.
- Understanding big data and predictive analytics
- Gathering financial data
- Cleaning up your data
- Calculating key financial metrics
- Using regression analysis for business-specific forecasts
- Performing scenario analysis
- Calculating confidence intervals
- Stress testing
Skill Level Intermediate
Duration
Views
-
Introduction
-
Welcome1m 11s
-
What you should know1m 40s
-
Exercise files38s
-
-
1. The Basics
-
What is big data?4m 5s
-
-
2. Forecasting in Finance
-
Gather financial data6m 48s
-
Clean financial data7m 33s
-
3. Performing Forecasting
-
Regressions for forecasting2m 30s
-
Use Excel for regressions4m 26s
-
4. Interpreting Forecast Results
-
What do the results mean?5m 46s
-
Perform stress testing4m 9s
-
-
Conclusion
-
Wrap up1m 16s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Confidence intervals around the result