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
consider the following time series data.t 1 2 3 4 5 6 7yt10 9 7 8 6 4 4a. construct a time series plot. What type of pattern exists in the data?b. develop the linear trend equation for this time series.c. What is the forecast for t = 8?
Below you are given the first five values of a quarterly time series. The multiplicative model is appropriate and a four-quarter moving average will be used. Year Quarter Time Series Value Yt 1 1 36 2 24   3 16 2 4 20 1 44 An estimate of the combined trend-cycle component (T2Ct) for Quarter 3 of Year 1 (used for estimating the de-trended values), when a four-quarter moving average is used, is a. 24. b.  26. c. 28. d. 25.
consider the following time series data.Month 1 2 3 4 5 6 7Value 24 13 20 12 19 23 15a. compute MSe using the most recent value as the forecast for the next period. Whatis the forecast for month 8?b. compute MSe using the average of all the data available as the forecast for the nextperiod. What is the forecast for month 8?c. Which method appears to provide the better forecast?

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
MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc
Text book image
Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning
Text book image
Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning
Text book image
Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON
Text book image
The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman
Text book image
Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman
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