O'Reilly logo

Microsoft® Office Excel® 2007: Data Analysis and Business Modeling, Second Edition by Wayne L. Winston

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 54. Forecasting in the Presence of Special Events

  • 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, we 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

How can I determine whether specific factors influence customer traffic?

  • The data collected is contained in the Original worksheet in ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required