Statistics for Business & Economics, Revised (MindTap Course List)
Statistics for Business & Economics, Revised (MindTap Course List)
12th Edition
ISBN: 9781285846323
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Publisher: South-Western College Pub
bartleby

Videos

Question
Book Icon
Chapter 17.4, Problem 18E
To determine

Develop a forecast for t=6 by using the Holt’s linear exponential smoothing method with α=0.3 and β=0.5.

Expert Solution & Answer
Check Mark

Answer to Problem 18E

The forecast for t=6 by using the Holt’s linear exponential smoothing method with α=0.3 and β=0.5 is 21.16.

Explanation of Solution

Calculation:

The given data represents time series data.

The equations for Holt’s linear exponential smoothing method is,

Lt=αYt+(1α)(Lt1+bt1)

bt=β(LtLt1)+(1β)bt1

Ft+1=Lt+btk

Where Lt represents the estimate of the level of the time series in period t, bt represents estimate of the slope of the time series in period t, α represents the smoothing constant for the level of the time series, Yt is the value of time series in period t, β is the smoothing constant for the slope the time series, Ft+1 is the forecast for k periods ahead and k represents the number of periods ahead to be forecast.

For week 1:

Consider

L1=Y1

From given data, it can be observed that Y1=6.

Therefore,

L1=6

Now,

b1=Y2Y1=116=5

Consider k=1 the Ft+1 is

Ft+1=Lt+bt

The equation Ft+1=Lt+bt at t=1 is

F1+1=L1+b1F2=6+5=11

For week 2:

The equation Lt=αYt+(1α)(Lt1+bt1) at t=2 is,

L2=αY2+(1α)(L21+b21)=αY2+(1α)(L1+b1)

Substitute α=0.3, Y2=11, L1=6 and b1=5

L2=(0.3)(11)+(10.3)(6+5)=3.3+7.7=11

The equation bt=β(LtLt1)+(1β)bt1 at t=2 is,

b2=β(L2L21)+(1β)b21=β(L2L1)+(1β)b1

Substitute L1=6, L2=11, β=0.5 and b1=5

b2=0.5(116)+(10.5)5=0.5(5)+0.5(5)=2.5+2.5=5

The equation Ft+1=Lt+bt at t=2 is,

F2+1=L2+b2=11+5=16

Similarly the remaining estimated levels, estimated trend and forecasts are obtained as follows:

tValueEstimated LevelEstimated trendForecast
1665 
21111511
3913.903.9516
41416.703.3717.85
51518.552.6120.07

The forecast for week 6 is,

Ft+1=Lt+btF5+1=L5+b5F6=L5+b5

Substitute L5=18.55 and b5=2.61

F6=L5+b5=18.55+2.61=21.16

Thus, the forecast for t=6 by using the Holt’s linear exponential smoothing method with α=0.3 and β=0.5 is 21.16.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
hudson Marine has been an authorized dealer for c&d marine radios for the past sevenyears. the following table reports the number of radios sold each year.Year 1 2 3 4 5 6 7Number Sold 35 50 75 90 105 110 130a. construct a time series plot. does a linear trend appear to be present?b. Using Minitab or excel, develop a linear trend equation for this time series.c. Use the linear trend equation developed in part (b) to develop a forecast for annualsales in year 8.
Consider the time series data in the table below (a-c all count as one problem) a. Construct a time series plot. What type of pattern exists in the data?b. Develop a three-week moving average for this time series. Compute MSEand a forecast for week 8. c. Use α = 0.2 to compute the exponential smoothing value for the time series.Compute MSE and a forecast for week 8.
Consider the following time series data. Week 1   2  3  4  5  6 Value 18 13 16 11 17 14   Construct a time series plot. What type of pattern exist in the data? Develop a three-week moving average for this time series. Compute MSE and forecast for week 7. Use a = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and forecast for week 7.

Chapter 17 Solutions

Statistics for Business & Economics, Revised (MindTap Course List)

Ch. 17.3 - For the Hawkins Company, the monthly percentages...Ch. 17.3 - Corporate triple-A bond interest rates for 12...Ch. 17.3 - The values of Alabama building contracts (in ...Ch. 17.3 - The following time series shows the sales of a...Ch. 17.3 - Ten weeks of data on the Commodity Futures Index...Ch. 17.3 - The U.S. Census Bureau tracks the median price for...Ch. 17.4 - Consider the following time series data. a....Ch. 17.4 - Prob. 18ECh. 17.4 - Consider the following time series. a. Construct a...Ch. 17.4 - Prob. 20ECh. 17.4 - Prob. 21ECh. 17.4 - Prob. 22ECh. 17.4 - The president of a small manufacturing firm is...Ch. 17.4 - FRED (Federal Reserve Economic Data), a database...Ch. 17.4 - Automobile unit sales at B. J. Scott Motors, Inc.,...Ch. 17.4 - Giovanni Food Products produces and sells frozen...Ch. 17.4 - Prob. 27ECh. 17.5 - Consider the following time series. a. Construct a...Ch. 17.5 - Consider the following time series data. a....Ch. 17.5 - The quarterly sales data (number of copies sold)...Ch. 17.5 - Air pollution control specialists in southern...Ch. 17.5 - South Shore Construction builds permanent docks...Ch. 17.5 - Prob. 33ECh. 17.5 - Three years of monthly lawn-maintenance expenses...Ch. 17.6 - Consider the following time series data. a....Ch. 17.6 - Refer to exercise 35. a. Deseasonalize the time...Ch. 17.6 - The quarterly sales data (number of copies sold)...Ch. 17.6 - Three years of monthly lawn-maintenance expenses...Ch. 17.6 - Air pollution control specialists in southern...Ch. 17.6 - Electric power consumption is measured in...Ch. 17 - The weekly demand (in cases) for a particular...Ch. 17 - The following table reports the percentage of...Ch. 17 - United Dairies. Inc., supplies milk to several...Ch. 17 - Prob. 44SECh. 17 - Prob. 45SECh. 17 - The Mayfair Department Store in Davenport, Iowa,...Ch. 17 - Canton Supplies, Inc., is a service firm that...Ch. 17 - The Costello Music Company has been in business...Ch. 17 - Consider the Costello Music Company problem in...Ch. 17 - Refer to the Costello Music Company problem in...Ch. 17 - Refer to the Costello Music Company time series in...Ch. 17 - Hudson Marine has been an authorized dealer for CD...Ch. 17 - Refer to the Hudson Marine problem in exercise 52....Ch. 17 - Refer to the Hudson Marine problem in exercise 53....Ch. 17 - Refer to the Hudson Marine data in exercise 53. a....Ch. 17 - Forecasting Food and Beverage Sales The Vintage...Ch. 17 - Forecasting Lost Sales The Carlson Department...
Knowledge Booster
Background pattern image
Statistics
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
College Algebra
Algebra
ISBN:9781938168383
Author:Jay Abramson
Publisher:OpenStax
Text book image
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning
Text book image
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Text book image
Algebra and Trigonometry (MindTap Course List)
Algebra
ISBN:9781305071742
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning
Text book image
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Text book image
College Algebra
Algebra
ISBN:9781337282291
Author:Ron Larson
Publisher:Cengage Learning
Time Series Analysis Theory & Uni-variate Forecasting Techniques; Author: Analytics University;https://www.youtube.com/watch?v=_X5q9FYLGxM;License: Standard YouTube License, CC-BY
Operations management 101: Time-series, forecasting introduction; Author: Brandoz Foltz;https://www.youtube.com/watch?v=EaqZP36ool8;License: Standard YouTube License, CC-BY