Chapter 59. Winters’s Method

You often need to predict future values of a time series, such as monthly costs or monthly product revenues. This is usually difficult because the characteristics of any time series are constantly changing. Smoothing or adaptive methods are usually best suited for forecasting future values of a time series. In this chapter, I describe the most powerful smoothing method: Winters’s method. To help you understand how Winters’s method works, I’ll use it to forecast monthly housing starts in the United States. Housing starts are simply the number of new homes whose construction begins during a month. I’ll begin by describing the three key characteristics of a time series.

Time Series Characteristics

The behavior ...

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

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.