Statistics for Business & Economics
Statistics for Business & Economics
12th Edition
ISBN: 9781285528830
Author: David R. Anderson
Publisher: Cengage Learning US
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
The average number of minutes Americans commute to work is 27.7 minutes (Sterling's Best Places, April 13, 2012). The average commute time in minutes for 48 cities are as follows: Click on the datafile logo to reference the data. DATA file Albuquerque 23.3 Jacksonville 26.2 Phoenix 28.3 Atlanta 28.3 Kansas City 23.4 Pittsburgh 25.0 Austin 24.6 Las Vegas 28.4 Portland 26.4 Baltimore 32.1 Little Rock 20.1 Providence 23.6 Boston 31.7 Los Angeles 32.2 Richmond 23.4 Charlotte 25.8 Louisville 21.4 Sacramento 25.8 Chicago 38.1 Memphis 23.8 Salt Lake City 20.2 Cincinnati 24.9 Miami 30.7 San Antonio 26.1 Cleveland 26.8 Milwaukee 24.8 San Diego 24.8 Columbus 23.4 Minneapolis 23.6 San Francisco 32.6 Dallas 28.5 Nashville 25.3 San Jose 28.5 Denver 28.1 New Orleans 31.7 Seattle 27.3 Detroit 29.3 New York 43.8 St. Louis 26.8 El Paso 24.4 Oklahoma City 22.0 Tucson 24.0 Fresno 23.0 Orlando 27.1 Tulsa 20.1 Indianapolis 24.8 Philadelphia 34.2 Washington, D.C. 32.8 a. What is the mean commute time for…
Morningstar tracks the total return for a large number of mutual funds. The following table shows the total return and the number of funds for four categories of mutual funds. Click on the datafile logo to reference the data. DATA file Type of Fund Domestic Equity Number of Funds Total Return (%) 9191 4.65 International Equity 2621 18.15 Hybrid 1419 2900 11.36 6.75 Specialty Stock a. Using the number of funds as weights, compute the weighted average total return for these mutual funds. (to 2 decimals) % b. Is there any difficulty associated with using the "number of funds" as the weights in computing the weighted average total return in part (a)? Discuss. What else might be used for weights? The input in the box below will not be graded, but may be reviewed and considered by your instructor. c. Suppose you invested $10,000 in this group of mutual funds and diversified the investment by placing $2000 in Domestic Equity funds, $4000 in International Equity funds, $3000 in Specialty Stock…
The days to maturity for a sample of five money market funds are shown here. The dollar amounts invested in the funds are provided. Days to Maturity 20 Dollar Value ($ millions) 20 12 30 7 10 5 6 15 10 Use the weighted mean to determine the mean number of days to maturity for dollars invested in these five money market funds (to 1 decimal). days

Chapter 17 Solutions

Statistics for Business & Economics

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