Before attempting quizzes and assignments, please first watch the video clip. Sometimes, you may need to go over the video multiple times to understand all details. The courses are designed in a specific order. We recommended you follow it in that order.

At the end of the course, a certificate will automatically be generated. Good luck and enjoy your course!

In this topic, we see where fluctuations in arrivals come from. Please watch the clip and repeat the demo with 100 customers, each having a 0.01 probability of calling. Then submit the resulting Excel sheet.

In this topic we continue the Excel demo and analyse the resulting distribution. Please repeat again the demo and submit the Excel sheet.

In this topic we discuss the practical implications of the theory presented. Please watch the video and then make the final assignment.

•  forecast error = FCE = forecast - actual 
  
•  percentage error = PE = FCE / actual 
  
•  absolute percentage error = APE = absolute value of PE (i.e., without the minus sign)
  
•  mean average percentage error = MAPE = average APE over all forecasted periods
  

Calculate the APE for the overall call volume and the MAPE for every line separate and all lines aggregated.
Additionally, which lines have a forecasting error based on the following rule of thumb: 

• A line has a forecasting error if there are two consecutive periods with an error larger than twice the square root of the forecast
  

• A line has a forecasting error if there are three consecutive periods with an error larger than the square root of the forecast in the same direction.
  

To obtain this Certificate of Completion you must score 60% or higher on every assignment and quiz. The final assignment must be 80% or higher. You can retry every single topic as much as you would like. There is no limit in time or number of tries.
Before you move on to the next course, please give us feedback on this course!