QUESTION 4 Use the International Labor database Time series database on "Excel Databases.xls" showing the unemployment rate (%) over the past 40 years in various countries. Specifically for the US, create two different forecasts using exponential smoothing. Let forecast A use an exponential smoothing constant, a = 0.2, and forecast B use an exponential smoothing constant, a 0.8. What is the MAD for Forecast B? Round your answer to 2 decimal place.
QUESTION 4 Use the International Labor database Time series database on "Excel Databases.xls" showing the unemployment rate (%) over the past 40 years in various countries. Specifically for the US, create two different forecasts using exponential smoothing. Let forecast A use an exponential smoothing constant, a = 0.2, and forecast B use an exponential smoothing constant, a 0.8. What is the MAD for Forecast B? Round your answer to 2 decimal place.
Chapter4: Linear Functions
Section4.3: Fitting Linear Models To Data
Problem 24SE: Table 6 shows the year and the number ofpeople unemployed in a particular city for several years....
Related questions
Question
| Year | U.S. | Canada | Australia | Japan | France | Germany | Italy |
| 1 | 5.5 | 5.6 | 2.1 | 2.3 | 1.6 | 2 | 4.8 |
| 2 | 5.5 | 6.5 | 1.6 | 1.7 | 1.5 | 1.1 | 3.7 |
| 3 | 6.7 | 6.7 | 3.0 | 1.5 | 1.2 | 0.6 | 3.2 |
| 4 | 5.5 | 5.5 | 2.9 | 1.3 | 1.4 | 0.6 | 2.8 |
| 5 | 5.7 | 5.2 | 2.3 | 1.3 | 1.6 | 0.5 | 2.4 |
| 6 | 5.2 | 4.4 | 1.4 | 1.2 | 1.2 | 0.4 | 2.7 |
| 7 | 4.5 | 3.6 | 1.3 | 1.2 | 1.6 | 0.3 | 3.5 |
| 8 | 3.8 | 3.4 | 1.6 | 1.4 | 1.6 | 0.3 | 3.7 |
| 9 | 3.8 | 3.8 | 1.9 | 1.3 | 2.1 | 1.3 | 3.4 |
| 10 | 3.6 | 4.5 | 1.8 | 1.2 | 2.7 | 1.1 | 3.5 |
| 11 | 3.5 | 4.4 | 1.8 | 1.1 | 2.3 | 0.6 | 3.5 |
| 12 | 4.9 | 5.7 | 1.6 | 1.2 | 2.5 | 0.5 | 3.2 |
| 13 | 5.9 | 6.2 | 1.9 | 1.3 | 2.8 | 0.6 | 3.3 |
| 14 | 5.6 | 6.2 | 2.6 | 1.4 | 2.9 | 0.7 | 3.8 |
| 15 | 4.9 | 5.5 | 2.3 | 1.3 | 2.8 | 0.7 | 3.7 |
| 16 | 5.6 | 5.3 | 2.7 | 1.4 | 2.9 | 1.6 | 3.1 |
| 17 | 8.5 | 6.9 | 4.9 | 1.9 | 4.2 | 3.4 | 3.4 |
| 18 | 7.7 | 7.2 | 4.8 | 2 | 4.6 | 3.4 | 3.9 |
| 19 | 7.1 | 8.1 | 5.6 | 2 | 5.2 | 3.4 | 4.1 |
| 20 | 6.1 | 8.4 | 6.3 | 2.3 | 5.4 | 3.3 | 4.1 |
| 21 | 5.8 | 7.5 | 6.3 | 2.1 | 6.1 | 2.9 | 4.4 |
| 22 | 7.1 | 7.5 | 6.1 | 2 | 6.5 | 2.8 | 4.4 |
| 23 | 7.6 | 7.6 | 5.8 | 2.2 | 7.6 | 4 | 4.9 |
| 24 | 9.7 | 11 | 7.2 | 2.4 | 8.3 | 5.6 | 5.4 |
| 25 | 9.6 | 11.9 | 10.0 | 2.7 | 8.6 | 6.9 | 5.9 |
| 26 | 7.5 | 11.3 | 9.0 | 2.8 | 10 | 7.1 | 5.9 |
| 27 | 7.2 | 10.5 | 8.3 | 2.6 | 10.5 | 7.2 | 6 |
| 28 | 7 | 9.6 | 8.1 | 2.8 | 10.6 | 6.6 | 7.5 |
| 29 | 6.2 | 8.9 | 8.1 | 2.9 | 10.8 | 6.3 | 7.9 |
| 30 | 5.5 | 7.8 | 7.2 | 2.5 | 10.3 | 6.3 | 7.9 |
| 31 | 5.3 | 7.5 | 6.2 | 2.3 | 9.6 | 5.7 | 7.8 |
| 32 | 5.6 | 8.1 | 6.9 | 2.1 | 9.1 | 5 | 7 |
| 33 | 6.8 | 10.4 | 9.6 | 2.1 | 9.6 | 4.3 | 6.9 |
| 34 | 7.5 | 11.3 | 10.8 | 2.2 | 10.4 | 4.6 | 7.3 |
| 35 | 6.9 | 11.2 | 10.9 | 2.5 | 11.8 | 5.7 | 10.2 |
| 36 | 6.1 | 10.4 | 9.7 | 2.9 | 12.3 | 6.5 | 11.3 |
| 37 | 5.6 | 9.5 | 8.5 | 3.2 | 11.8 | 6.5 | 12 |
| 38 | 5.4 | 9.7 | 8.6 | 3.4 | 12.5 | 7.2 | 12.1 |
| 39 | 4.9 | 9.2 | 8.6 | 3.4 | 12.4 | 7.8 | 12.3 |
| 40 | 4.5 | 8.3 | 8.0 | 4.1 | 11.8 | 7.5 | 12.3 |
Transcribed Image Text:QUESTION 4
Use the International Labor database Time series database on "Excel Databases.xls" showing the unemployment rate (%) over the past 40 years in various countries.
Specifically for the US, create two different forecasts using exponential smoothing. Let forecast A use an exponential smoothing constant, a = 0.2, and forecast B use an
exponential smoothing constant, a = 0.8. What is the MAD for Forecast B? Round your answer to 2 decimal place.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
Knowledge Booster
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.Recommended textbooks for you
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
College Algebra
Algebra
ISBN:
9781305115545
Author:
James Stewart, Lothar Redlin, Saleem Watson
Publisher:
Cengage Learning
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
College Algebra
Algebra
ISBN:
9781305115545
Author:
James Stewart, Lothar Redlin, Saleem Watson
Publisher:
Cengage Learning