Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN: 9781305627734
Author: Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 8, Problem 6P
Consider the following time series data:
- 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 MSE and a forecast for week 8.
- c. Use α = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for week 8.
- d. Compare the three-week moving average forecast with the exponential smoothing forecast using α = 0.2. Which appears to provide the better forecast based on MSE?
- e. Use trial and error to find a value of the exponential smoothing coefficient α that results in a smaller MSE than what you calculated for α = 0.2.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
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.
For the Texas Shipping Company, the monthly percentages of all shipments received on time over the past 12 months are 82, 86, 87, 89, 84, 85, 84, 86, 75, 95,
90, and 92.
a. Construct a time series plot (you can include it in the work file question at the end, not here). Identify what type of pattern, if any, exists in the data?
Compare the three-month moving average forecast with an exponential smoothing forecast for alpha= 0.25 and answer the following:
b. MSE for 3-month moving average method
c. MSE for exponential-smoothing method :
d. Which method should be preferred? Answer "3-month MA" or "Exponential Smoothing":
e. What is the forecast for next month using the preferred method?
consider the following time series data.Month 1 2 3 4 5 6 7Value 24 13 20 12 19 23 15construct a time series plot. What type of pattern exists in the data?a. develop the three-week moving average forecasts for this time series. compute MSeand a forecast for week 8.b. Use a = .2 to compute the exponential smoothing forecasts for the time series. compute MSe and a forecast for week 8.c. compare the three-week moving average approach with the exponential smoothing approach using a = .2. Which appears to provide more accurate forecasts based on MSe?d. Use a smoothing constant of a = .4 to compute the exponential smoothing forecasts.does a smoothing constant of .2 or .4 appear to provide more accurate forecasts basedon MSe? explain
Chapter 8 Solutions
Essentials of Business Analytics (MindTap Course List)
Ch. 8 - Consider the following time series data:
Using...Ch. 8 - Refer to the time series data in Problem 1. Using...Ch. 8 - Problems 1 and 2 used different forecasting...Ch. 8 - Consider the following time series data:
Compute...Ch. 8 - Consider the following time series...Ch. 8 - Consider the following time series...Ch. 8 - Refer to the gasoline sales time series data in...Ch. 8 - Prob. 8PCh. 8 - Prob. 9PCh. 8 - Prob. 10P
Ch. 8 - For the Hawkins Company, the monthly percentages...Ch. 8 - Corporate triple A bond interest rates for 12...Ch. 8 - The values of Alabama building contracts (in...Ch. 8 - The following time series shows the sales of a...Ch. 8 - Prob. 15PCh. 8 - The following table reports the percentage of...Ch. 8 - Consider the following time series: a. Construct a...Ch. 8 - Consider the following time series:
Construct a...Ch. 8 - Because of high tuition costs at state and private...Ch. 8 - The Seneca Children’s Fund (SCF) is a local...Ch. 8 - The president of a small manufacturing firm is...Ch. 8 - Consider the following time series: a. Construct a...Ch. 8 - Consider the following time series...Ch. 8 - The quarterly sales data (number of copies sold)...Ch. 8 - Prob. 25PCh. 8 - South Shore Construction builds permanent docks...Ch. 8 - Hogs & Dawgs is an ice cream parlor on the border...Ch. 8 - Donna Nickles manages a gasoline station on the...Ch. 8 - The Vintage Restaurant, on Captiva Island near...
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.Similar questions
- What does the y -intercept on the graph of a logistic equation correspond to for a population modeled by that equation?arrow_forwardOlympic Pole Vault The graph in Figure 7 indicates that in recent years the winning Olympic men’s pole vault height has fallen below the value predicted by the regression line in Example 2. This might have occurred because when the pole vault was a new event there was much room for improvement in vaulters’ performances, whereas now even the best training can produce only incremental advances. Let’s see whether concentrating on more recent results gives a better predictor of future records. (a) Use the data in Table 2 (page 176) to complete the table of winning pole vault heights shown in the margin. (Note that we are using x=0 to correspond to the year 1972, where this restricted data set begins.) (b) Find the regression line for the data in part ‚(a). (c) Plot the data and the regression line on the same axes. Does the regression line seem to provide a good model for the data? (d) What does the regression line predict as the winning pole vault height for the 2012 Olympics? Compare this predicted value to the actual 2012 winning height of 5.97 m, as described on page 177. Has this new regression line provided a better prediction than the line in Example 2?arrow_forwardFind the mean hourly cost when the cell phone described above is used for 240 minutes.arrow_forward
- Find the equation of the regression line for the following data set. x 1 2 3 y 0 3 4arrow_forwardConsider the following time series data. Month 2 3 4 5 6 7 Value 24 13 20 12 19 23 15 Construct a time series plot. What type of pattern exists in the data? Develop the three-week moving average forecasts for this time series. Compute MSE and a forecast for week 8. b. Use a = .2 to compute the exponential smoothing forecasts for the time series. Com- pute MSE and a forecast for week 8. Compare the three-week moving average approach with the exponential smoothing ap- proach using a = .2. Which appears to provide more accurate forecasts based on MSE? d. Use a smoothing constant of a = .4 to compute the exponential smoothing forecasts. Does a smoothing constant of .2 or .4 appear to provide more accurate forecasts based on MSE? Explain.arrow_forwardConsider the following time series data.arrow_forward
- 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.arrow_forwardthe costello Music company has been in business for five years. during that time, salesof pianos increased from 12 units in the first year to 76 units in the most recent year. Fredcostello, the firm’s owner, wants to develop a forecast of piano sales for the coming year.the historical data follow.Year 1 2 3 4 5Sales 12 28 34 50 76a. construct a time series plot. What type of pattern exists in the data?b. develop the linear trend equation for the time series. What is the average increase insales that the firm has been realizing per year?c. Forecast sales for years 6 and 7.arrow_forwardRefer to the gasoline sales time series data in the given table. Compute four-week and five-week moving averages for the time series. Round your answers to two decimal places. Compute the MSE for the four-week and five-week moving average forecasts. Round your intermediate calculations and final answers to two decimal places. What appears to be the best number of weeks of past data (three, four, or five) to use in the moving average computation? Recall that MSE for the three-week moving average is 12.89.arrow_forward
- Consider the following time series data: 1 2 3 4 5 6 7 26 15 22 14 21 25 17 PART 1.Compute MSE using the most recent value as the forecast for the next period and then calculate the forecast for month 8. PART 2.Compute MSE using the average of all the data available as the forecast for the next period. What is the forecast for month 8?arrow_forwardIn retail, a store manager uses time series models to understand shopping trends. Review the scatter plot of the store’s sales from 2010 through 2021 to answer the questions. See attached as image. Here is the data for Fiscal Year and Sales: Fiscal Year Sales 2010 $260,123.00 2011 $256,853.00 2012 $274,366.00 2013 $290,525.00 2014 $322,318.00 2015 $380,921.00 2016 $541,925.00 2017 $909,050.00 2018 $1,817,521.00 2019 $3,206,564.00 2020 $4,921,005.00 2021 $5,686,338.00 Time series decomposition seeks to separate the time series (Y) into 4 components: trend (T), cycle (C), seasonal (S), and irregular (I). What is the difference between these components? The model can be additive or multiplicative. When do you use each? Review the scatter plot of the exponential trend of the time series data. Do you observe a trend? If so, what type of trend do you observe? What predictions might you make about the store’s annual sales over the next few years?arrow_forwardConsider the following quarterly time series. Quarter 1 2 3 4 Year 1 923 Year 2 1,112 1,056 1,156 992 Year 3 1,078 1,243 1,124 1,124 1,254 1,301 1,198 a. Construct a time series plot. What type of pattern exists in the data? b. Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. Qtr1 = 1 if quarter 1, 0 otherwise; Qtr2 = 1 if quarter 2, 0 otherwise; Qtr3 = 1 if quarter 3, 0 otherwise. c. Compute the quarterly forecasts for next year based on the model developed in part b.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Linear Algebra: A Modern IntroductionAlgebraISBN:9781285463247Author:David PoolePublisher:Cengage LearningCollege AlgebraAlgebraISBN:9781305115545Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage LearningBig Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillAlgebra and Trigonometry (MindTap Course List)AlgebraISBN:9781305071742Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage Learning
Linear Algebra: A Modern Introduction
Algebra
ISBN:9781285463247
Author:David Poole
Publisher:Cengage Learning
College Algebra
Algebra
ISBN:9781305115545
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Algebra and Trigonometry (MindTap Course List)
Algebra
ISBN:9781305071742
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