Learn how to use a damping factor on simple moving averages to obtain a more aesthetically pleasing representation of future forecasts.
- [Instructor] Another technique we can use…to make some predictions using just revenue…is called exponential smoothing.…Exponential smoothing is analogous to a rolling average…but it's not quite the same thing.…Let's get started and you'll be able to see the difference.…I'm in the 02_05_Begin exercise files.…We'll use columns J and again, so I'm going to scroll over…to the right, this is our quarter and sales.…Now, we're going to be using a built-in function, and to do…this, you'll have to install the analysis tool pack.…
On Windows, I believe you can access the tool pack…by going to file, options, and then under add-ins,…you can choose the analysis tool pack and click go.…On Mac, it's a bit different, so let me just show you…how to do that here.…Go up to tools, Excel add-ins, and then click on…the analysis tool pack checkbox for the add-ins available…and then press OK.…So now, when I go into the data tab,…I should have a data analysis option.…And the same thing should hold true for Windows users.…
So let's go ahead and go to it.…
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.
- Explain the four different types of financial statements.
- Distinguish between the types of moving averages.
- Determine a seasonal adjusted trend.
- Break down pro-forma financial statements.
- Identify cash flows, and what increased liabilities and decreased earnings generally indicate.
- Tell what a regression is.
- Outline the naive approach.