TSF StudyUnit 1 and 2
Q1ForecastingMoving average

1. Forecasting methods and moving averages

Question: Discuss qualitative and quantitative forecasting methods. Also calculate 3-year, 5-year and 7-year moving averages for the given yearly sales data.

Theory answer

Forecasting is the process of estimating future values of a variable by using past data, present information, and suitable assumptions. In time series analysis, forecasting helps in planning production, inventory, finance, staffing, sales targets, and policy decisions.

  1. Qualitative forecasting methods are judgement-based methods. They are used when past numerical data is limited, unreliable, or not directly relevant. Examples include expert opinion, Delphi method, market survey, consumer intention survey, sales-force composite method, and historical analogy. These methods are useful for new products, new markets, or long-term strategic decisions, but they may be subjective.
  2. Quantitative forecasting methods are data-based methods. They use numerical past observations and mathematical models. Examples include moving averages, weighted moving averages, exponential smoothing, decomposition, regression, and ARIMA models. These methods are objective and reproducible, but they require reliable historical data and may fail if the future pattern changes suddenly.
  3. Difference: qualitative methods depend mainly on experience and judgement, whereas quantitative methods depend mainly on recorded data and statistical calculations.

Numerical answer

Final answer:The 3-year moving averages are 107.00, 109.67, 110.67, 111.33, 112.00; the 5-year moving averages are 107.80, 110.60, 112.00; and the 7-year moving average is 109.57.
Q2ComponentsTrend plotting

2. Components of time series and moving-average trend

Question: Discuss the components of time series. Calculate 3-year, 4-year, 5-year and 7-year moving averages, and plot actual and trend values.

Theory answer

A time series is a set of observations recorded in time order. The observed value is usually affected by four components.

  1. Trend component: The long-term upward or downward movement in the data. It shows the general direction over a long period, such as increasing sales or falling demand.
  2. Seasonal component: A regular pattern that repeats within a fixed short period such as month, quarter, week, or day. Examples are festival sales, summer electricity demand, and quarterly demand patterns.
  3. Cyclical component: Wave-like movements around the trend over periods longer than one year. These are often connected with business cycles such as boom, recession, depression, and recovery.
  4. Irregular component: Random, accidental, or unpredictable variation caused by events such as strikes, floods, pandemics, sudden policy changes, or one-time market shocks.

The common models are additive model Y = T + S + C + I and multiplicative model Y = T x S x C x I. Additive model is preferred when seasonal variation is roughly constant; multiplicative model is preferred when seasonal variation changes in proportion to the level of the series.

Numerical answer

Final answer:Use the computed moving average values as trend points. For the 4-year moving average, the centered values are 159.38, 185.00, 211.88 and 257.50.
Q3Trend methodsMoving average

3. Methods of finding trend and moving averages

Question: Describe the methods of finding trend. Calculate 3-year, 4-year, 5-year and 7-year moving averages for the frequency series.

Theory answer

The trend is the long-term movement of a time series. The main methods used to find trend are:

  1. Graphic or freehand curve method: Plot the data on a graph and draw a smooth line through the points by judgement. It is simple, but subjective.
  2. Semi-average method: Divide the data into two equal parts, calculate the average of each part, plot these averages at their middle time points, and join them. It is easy, but it may be affected by unusual values.
  3. Moving average method: Calculate averages of fixed-size consecutive groups. It smooths short-term fluctuations and gives a clearer trend. It is useful when trend is not strictly linear.
  4. Method of least squares: Fit a mathematical trend equation, such as a straight line y = a + bx or parabola y = a + bx + cx^2, by minimizing the sum of squared errors. It is objective and suitable for forecasting.

Numerical answer

Final answer:The centered 4-year moving average values are 12.12, 12.00, 10.50 and 7.88. These trend values show a decline after the middle of the series.
Q4Least squaresStraight line and parabola

4. Fit straight line and parabola; estimate 1995

Question: Fit a straight line and a parabola by the method of least squares for 1982-1989 data, and estimate the value for 1995.

Numerical answer

For an even number of years, use coded values x = -7, -5, -3, -1, 1, 3, 5, 7. This keeps sum x = 0 and makes the normal equations easier.

Q5Least squaresForecasting

5. Fit straight line and parabola; estimate 2006

Question: Fit a straight line and a parabola for 2001-2005 data, and estimate the value for 2006.

Numerical answer

Since there are five years, take the middle year 2003 as origin. Therefore x values are -2, -1, 0, 1, 2 and for 2006 the coded value is x = 3.

Q6Least squaresForecasting

6. Fit straight line and parabola; estimate 2006

Question: Fit a straight line and a parabola for 1996-2002 data, and estimate the value for 2006.

Numerical answer

There are seven years, so take 1999 as origin. The coded values are x = -3, -2, -1, 0, 1, 2, 3. For 2006, coded x = 7.

Q7DecompositionAir passengers

7. Decomposition process for air-passenger data

Question: Discuss the decomposition process. Apply additive and multiplicative decomposition to the monthly air-passenger data for 1949 and 1950.

Theory answer

Decomposition is the process of separating a time series into its major components: trend, seasonal, cyclical, and irregular variations. This helps us understand the structure of the data and produce better forecasts.

  1. Choose the model. In additive decomposition, Y = T + S + C + I. In multiplicative decomposition, Y = T x S x C x I.
  2. Estimate the level or trend of the series. For this two-year monthly question, the yearly average is used as the level for each year.
  3. Estimate seasonal effects. For additive decomposition, subtract the yearly average from each month. For multiplicative decomposition, divide each monthly value by the yearly average.
  4. Average the same months across years to obtain the seasonal index for each month.
  5. Adjust the seasonal indices. Additive seasonal indices should sum to zero. Multiplicative seasonal indices should average to one.

Numerical answer

Air-passenger seasonality usually grows with the level, so the multiplicative model is generally more meaningful for interpretation.

Q8DecompositionRetail sales

8. Decomposition process for retail-sales data

Question: Discuss the decomposition process. Apply additive and multiplicative decomposition to monthly retail sales volume for 2021 and 2022.

Theory answer

In decomposition, the observed value is broken into systematic parts so that the seasonal pattern and trend pattern can be studied separately. The steps are: identify the model, estimate the annual or trend level, remove the level from each monthly value, average the same months, and adjust the indices.

Additive decomposition is used when seasonal changes are measured in the same units as the data. Multiplicative decomposition is used when seasonal changes are proportional to the level of the series.

Numerical answer

Retail sales have strong November and December peaks. Multiplicative indices are useful because the peak is better interpreted as a proportional seasonal lift.

Q9DecompositionElectric data

9. Decomposition process for electric data

Question: Discuss the decomposition process. Apply additive and multiplicative decomposition to monthly electric data for 2022 and 2023.

Theory answer

Decomposition separates the original time series into long-term movement and repeated seasonal effects. The additive form is Y = T + S + C + I, and the multiplicative form is Y = T x S x C x I. After seasonal indices are found, they can be used to seasonally adjust data or to prepare seasonal forecasts.

Numerical answer

The summer months have high positive seasonal effects and spring/autumn months have lower values. Additive indices are easy to read in original units, while multiplicative indices show proportional demand.

Q10DecompositionSaaS users

10. Decomposition process for SaaS user data

Question: Discuss the decomposition process. Apply additive and multiplicative decomposition to monthly SaaS product user data for 2023 and 2024.

Theory answer

The purpose of decomposition is to make a time series easier to understand by separating trend and seasonality. The analyst first estimates the base level, then measures how each month differs from that base. The repeated monthly pattern becomes the seasonal component.

For additive decomposition, seasonal effects are added to the level. For multiplicative decomposition, seasonal factors multiply the level. A multiplicative model is often suitable when the second year has a higher level and seasonal lifts also scale upward.

Numerical answer

For SaaS users, growth raises the base level from 2023 to 2024, so multiplicative indices are often the cleaner explanation for seasonal user changes.

Q11Exponential smoothingDouble smoothing

11. Types of exponential smoothing and DES forecast

Question: Discuss the types of exponential smoothing. Use double exponential smoothing for 1990-2000 data with alpha = 0.1, beta = 0.3 and alpha = 0.5, beta = 0.2.

Theory answer

  1. Single exponential smoothing: Used when data has level but no clear trend or seasonality. It updates the forecast using the latest forecast error.
  2. Double exponential smoothing or Holt's method: Used when data has a trend. It updates both level and trend, so it can forecast increasing or decreasing series.
  3. Triple exponential smoothing or Holt-Winters method: Used when data has both trend and seasonality. It may be additive or multiplicative depending on the seasonal pattern.
  4. Damped trend smoothing: A variation where the trend effect is gradually reduced for longer forecast horizons.

Numerical answer

Final answer:Forecast after 2000 is 46.73 for alpha = 0.1, beta = 0.3 and 34.82 for alpha = 0.5, beta = 0.2.
Q12Single exponential smoothingQuarterly data

12. Types of exponential smoothing and SES forecasts

Question: Discuss the types of exponential smoothing. Use single exponential smoothing for quarterly data with alpha = 0.1, 0.2 and 0.5.

Theory answer

Exponential smoothing methods give higher weight to recent observations and lower weight to older observations. The smoothing parameter alpha lies between 0 and 1. A small alpha gives a smoother forecast, while a large alpha reacts faster to recent changes.

The main types are single exponential smoothing for level-only data, double exponential smoothing for trend data, and triple exponential smoothing for trend plus seasonal data.

Numerical answer

Final answer:Forecast for the next quarter is 26.48 for alpha = 0.1, 34.69 for alpha = 0.2, and 47.40 for alpha = 0.5.
Q13Double exponential smoothingParameter comparison

13. Types of exponential smoothing and DES forecasts for 2001-2016

Question: Discuss the types of exponential smoothing. Use double exponential smoothing for 2001-2016 data with alpha = 0.1, 0.5 and beta = 0.2, 0.3 combinations.

Theory answer

Exponential smoothing methods are recursive forecasting methods. They are easy to update because each new forecast is obtained from the previous smoothed values and the latest actual observation.

  1. SES handles only a changing level.
  2. DES handles level and trend using alpha for level smoothing and beta for trend smoothing.
  3. Holt-Winters handles level, trend, and seasonality.

Numerical answer

Final answer:Forecasts after 2016 are 85.03 for alpha = 0.1, beta = 0.2; 80.23 for alpha = 0.1, beta = 0.3; 75.63 for alpha = 0.5, beta = 0.2; and 75.22 for alpha = 0.5, beta = 0.3.
Q14Single exponential smoothingLong series

14. Types of exponential smoothing and SES forecasts for 1990-2016

Question: Discuss the types of exponential smoothing. Use single exponential smoothing for 1990-2016 data with alpha = 0.1 and alpha = 0.5.

Theory answer

Single exponential smoothing is written as F_(t+1) = alpha y_t + (1 - alpha)F_t. It is best for data without a strong trend. A larger alpha places more weight on the latest observation and gives a more responsive forecast.

Double exponential smoothing adds a trend component, and triple exponential smoothing adds both trend and seasonal components.

Numerical answer

Final answer:Forecast after 2016 is 53.36 for alpha = 0.1 and 70.45 for alpha = 0.5.
Q15Double exponential smoothingTrend update

15. Types of exponential smoothing and DES forecast for 12 periods

Question: Discuss the types of exponential smoothing. Use double exponential smoothing for t = 1 to 12 with alpha = 0.1, beta = 0.3 and alpha = 0.5, beta = 0.2.

Theory answer

Exponential smoothing forecasts are weighted averages where recent observations receive more importance. The three core types are SES, DES, and Holt-Winters. DES is appropriate here because the question asks us to estimate both level and trend through Holt's recurrence equations.

Numerical answer

Final answer:Forecast for period 13 is 68.71 for alpha = 0.1, beta = 0.3 and 73.27 for alpha = 0.5, beta = 0.2.
Q16Double exponential smoothingSales forecast

16. Types of exponential smoothing and DES sales forecast

Question: Discuss the types of exponential smoothing. Use double exponential smoothing for Year 1 to Year 10 sales with alpha = 0.1, beta = 0.3 and alpha = 0.5, beta = 0.2.

Theory answer

The types of exponential smoothing are selected according to the pattern in the data. SES is used for level-only series, DES is used when the series has trend, and Holt-Winters is used when there is trend plus seasonality. Since this sales series has a general upward direction, double exponential smoothing is suitable.

Numerical answer

Final answer:Forecast for Year 11 is 30.11 for alpha = 0.1, beta = 0.3 and 30.47 for alpha = 0.5, beta = 0.2.