Question: For problems 17-23, use the exponential_smoothing_data.csv dataset to answer the questions. The dataset provided is monthly data. Simple Exponential Smoothing What is the total error

For problems 17-23, use the exponential_smoothing_data.csv dataset to answer the questions. The dataset provided is monthly data.

Simple Exponential Smoothing

  1. What is the total error when alpha = 0.4?
  2. If alpha = 0.4, is the next forecast more heavily weighted toward the previous observed data or the previous smoothed data?

Holts Exponential Smoothing

  1. What is the total error when alpha = 0.4 and gamma = 0.4?
  2. What is Holts forecast when m = 1?

Winters Exponential Smoothing

  1. What is the total error when alpha = 0.4, gamma = 0.4 and beta = 0.6?
  2. What is Winters forecast when m=1? (one period into the future)
  3. What is Winters forecast when m = 2? (two periods into the future)

    Month

    Year

    Sales

    JAN

    2014

    372012

    FEB

    2014

    377748

    MAR

    2014

    382915

    APR

    2014

    387140

    MAY

    2014

    388205

    JUN

    2014

    390346

    JUL

    2014

    391052

    AUG

    2014

    394458

    SEP

    2014

    394025

    OCT

    2014

    396158

    NOV

    2014

    398452

    DEC

    2014

    399105

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!