Join Michael McDonald for an in-depth discussion in this video Use Excel for regressions, part of Financial Forecasting with Big Data.
- [Instructor] It's time to use a hedonic prediction.…I'm in the 03_04 folder looking at…the begin employee theft file.…We've got a basic question.…Jack has assigned employees one, three, six and seven…to work today in the store.…Manager three is also working.…What should we expect the over/under on the register…to be at the end of the day?…In other words, should we expect the register…to have more cash in it versus sales?…Or should we expect the register to have less cash?…We're going to use the regression…that we ran previously to answer this question.…
So, I'm going to set up our variables as follows.…Cash in register is going to be the variable…that we're trying to predict.…Employee one, employee three, employee six…and employee seven are all working.…And manager three is working.…Now, I've got my values.…
I'm going to use my Y and my Xs here.…In this case, employee one, three, six and seven…and manager three are all working…so each of them get a one.…I'm not showing this, but if we wanted to add,…say, manager two, we could.…
Author
Michael McDonald
Released
7/19/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.
LinkedIn Learning (Lynda.com) is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- List the two methods of making decisions.
- Identify the most common method of conventional financial forecasting.
- Describe common challenges that come when trying to merge data.
- Assess the types of questions that business intelligence is best suited to answer.
- Distinguish the statistic that is most useful for estimating the impact of an X variable on a Y variable.
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: Use Excel for regressions