Chapter 61. Forecasting in the Presence of Special Events

Questions answered in this chapter:

  • How can I determine whether specific factors influence customer traffic?

  • How can I evaluate forecast accuracy?

  • How can I check whether my forecast errors are random?

For a student project, a class and I attempted to forecast the number of customers visiting the Eastland Plaza Branch of the Indiana University (IU) Credit Union each day. Interviews with the branch manager made it clear that the following factors affected the number of customers:

  • Month of the year

  • Day of the week

  • Whether the day was a faculty or staff payday

  • Whether the day before or the day after was a holiday

Answers to This Chapter’s Questions

How can I determine whether specific factors influence ...

Get Microsoft® Excel® 2010: Data Analysis and Business Modeling now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.