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
Please help me with this question on statistics
Please help me with this statistics question
Please help me with the following statistics questionFor question (e), the options are:Assuming that the null hypothesis is (false/true), the probability of (other populations of 150/other samples of 150/equal to/more data/greater than) will result in (stronger evidence against the null hypothesis than the current data/stronger evidence in support of the null hypothesis than the current data/rejecting the null hypothesis/failing to reject the null hypothesis) is __.

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
College Algebra
Algebra
ISBN:9781337282291
Author:Ron Larson
Publisher:Cengage Learning
Text book image
Trigonometry (MindTap Course List)
Trigonometry
ISBN:9781337278461
Author:Ron Larson
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:9781305115545
Author:James Stewart, Lothar Redlin, Saleem Watson
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