How you can… Guess Taking advantage of Rapid Remodeling in Excel right now

Learn how to use exponential smoothing to forecast future needs in Excel 2013 for Time Series Analysis.

Exponential Smoothing forecasts demand in the next time period by taking into account the actual demand in the current period and the forecasted demand for the current time period.

Please visit (and subscribe to) my YouTube Channel to view methods of forecasting such as the Simple Moving Average and Weighted Moving Average methods.
Video Rating: / 5

In this video I explain how to create a forecasting model in Excel for a data set that involves both trend and seasonality. I chose not to de-seasonalize data set before finding the trend parameters.
Dataset URL: Copy and Paste it into Excel or work in Google Sheets
https://docs.google.com/spreadsheets/d/1BCEwiX4si5Zzkgcc51rkwaAIAOhMpr1V1U7qRaV7C0g/edit?usp=sharing

An alternative method could be to use a multiple linear regression model. And I think the regression model is more practical. Yes, I have recorded a video for that as well. The link for the video is https://youtu.be/KE_mk9wvu6U

These videos are created for the students at The College at Brockport, State University of New York. However anyone can benefit from them as they should work for any Operations Management class.

40 Antworten auf „How you can… Guess Taking advantage of Rapid Remodeling in Excel right now“

  1. How do you find week 16 forecast? You have ran out of actual values so you cannot use the formula. Trying to understand how to forecast several periods into the future.

  2. Super helpful video, I am requesting you make more video other forecast methods or help with link if it's already available somewhere. Thanks a Ton Mustafa

  3. Hi I have tried your working but in my working my linear trend did not capture the trend?? I worked on sales from 2017 to 2018 sep. can u help me or tell me how to make quarterly sales forecast. Please

  4. Can you provide some information or video regarding the identification of seasonal as well as other variables. I am required to make a single model for forecasting different variables at one place. Please help.

Schreibe einen Kommentar

Deine E-Mail-Adresse wird nicht veröffentlicht. Erforderliche Felder sind mit * markiert.