Modern Business Statistics with Microsoft Excel (MindTap Course List)
5th Edition
ISBN: 9781285433301
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 17.2, Problem 2E
Refer to the time series data in exercise 1. Using the average of all the historical data as a forecast for the next period, compute the following measures of forecast accuracy.
- a.
Mean absolute error. - b. Mean squared error.
- c. Mean absolute percentage error.
- d. What is the forecast for week 7?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Which of the following time series forecasting methods would not be used to forecast seasonal data?
Consider the following time series data:
Week
1
2
3
4
5
6
Value
18
13
16
11
17
14
Using the naïve method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy:
a. Mean absolute error
b. Mean squared error
c. Mean absolute percentage error
d. What is the forecast for week 7?
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?
Chapter 17 Solutions
Modern Business Statistics with Microsoft Excel (MindTap Course List)
Ch. 17.2 - 1. Consider the following time series...Ch. 17.2 - 2. Refer to the time series data in exercise 1....Ch. 17.2 - Prob. 3ECh. 17.2 - 4. Consider the following time series...Ch. 17.3 - Consider the following time series...Ch. 17.3 - Consider the following time series...Ch. 17.3 - Refer to the gasoline sales time series data in...Ch. 17.3 - Prob. 8ECh. 17.3 - 9. With the gasoline time series data from Table...Ch. 17.3 - 10. With a smoothing constant of α = .2, equation...
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 - Prob. 16ECh. 17.4 - Consider the following time series...Ch. 17.4 - Prob. 18ECh. 17.4 - Prob. 19ECh. 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 - Prob. 25ECh. 17.4 - Giovanni Food Products produces and sells frozen...Ch. 17.4 - The number of users of Facebook from 2004 through...Ch. 17.5 - Consider the following time series.
Construct a...Ch. 17.5 - Consider the following time series...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 - Prob. 34ECh. 17.6 - Consider the following time series...Ch. 17.6 - Refer to exercise 35.
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 - The Garden Avenue Seven sells CDs of its musical...Ch. 17 - The Mayfair Department Store in Davenport, Iowa,...Ch. 17 - Prob. 47SECh. 17 - The Costello Music Company has been in business...Ch. 17 - Consider the Costello Music Company problem in...Ch. 17 - Prob. 50SECh. 17 - Refer to the Costello Music Company time series in...Ch. 17 - Prob. 52SECh. 17 - Refer to the Hudson Marine problem in exercise 52....Ch. 17 - Refer to the Hudson Marine problem in exercise...Ch. 17 - Refer to the Hudson Marine data in exercise...Ch. 17 - Forecasting Food and Beverage Sales
The Vintage...Ch. 17 - The Carlson Department Store suffered heavy damage...
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
- For the hawkins company, the monthly percentages of all shipments received on timeover the past 12 months are 80, 82, 84, 83, 83, 84, 85, 84, 82, 83, 84, and 83.a. construct a time series plot. What type of pattern exists in the data?b. compare the three-month moving average approach with the exponential smoothing approach for a = .2. Which provides more accurate forecasts using MSe as themeasure of forecast accuracy?arrow_forwardconsider 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?arrow_forwardUse quantitativeforecast methods for the data shown below Period Observation 1 24 2 34 3 36 4 37 5 41 6 44 7 45 Plot the original time series and comment on appropriateness of a linear trend.arrow_forward
- a. In the Petroco Service Station problem, compute an exponentially smoothed forecast with an α value of .30. According to the result from Excel and/or POM-QM, the forecast for the month of August b.In the Petroco Service Station problem, for the exponentially smoothed forecast with an α value of .30, compute the mean absolute deviation (MAD) via Excel and/or POM-QM c. In the Petroco Service Station problem, compute an exponentially smoothed forecast with an α value of .50. According to the result from Excel and/or POM-QM, the forecast for the month of January would be d.In the Petroco Service Station problem, compute an exponentially smoothed forecast with an α value of .50. According to the result from Excel and/or POM-QM, the forecast for the month of Augustarrow_forwardUsing the time series data in the table, respond to the following items. Period Sales 1 $ 615 2 678 3 761 4 710 5 784 6 801 7 852 8 698 9 1,193 10 1,115 11 1,231 12 1,259 13 1,495 14 1,229 15 1,652 16 1,337 17 1,673 18 1,613 d-1. Compute all possible forecasts using a trend forecasting model using simple linear regression? (Round your answers to 3 decimal places.) Period Sales Predicted Sales Absolute Error 1 615 2 678 3 761 4 710 5 784 6 801 7 852 8 698 9 1,193 10 1,115 11 1,231 12 1,259 13 1,495 14 1,229 15 1,652 16 1,337 17 1,673 18 1,613 d-2. What is the MAD? (Round your answer to 3 decimal places.) d-3. What is the trend equation based on the regression analysis? (Round your answers to 3 decimal places.) Sales = __________ + _______________ time…arrow_forwardIn the article “The World's Longest Continued Series of Sea Level Observations” (M. Ekman, Paleogeography, 1988:73–77), the mean annual level of land uplift in Stockholm, Sweden, was estimated to be 4.93 ± 0.23 mm for the years 1774–1884 and to be 3.92 ± 0.19 mm for the years 1885–1984. Estimate the difference in the mean annual uplift between these two time periods, and find the uncertainty in the estimate.arrow_forward
- Match the following definitions to their appropriate terms: Group of answer choices based on an anlaysis of historical data concerning one or more time serie based on the assumption that the variable we are forecasting has a cause-effect relationship with one or more other variable a set of observations measured at successive points in time or over successive periods of time generally involve the use of expert judgment to develop forecasts A. Quantitative B. Qualitative C. time series methods D. Casual methodarrow_forwardConsider the following time seriesweek 1 2 3 4 5 6 value 18 13 16 11 17 14 a) Construct a time series plot? What type of pattern exists in the datab) Develop the three week moving average forecasts for this time series, then compute the measures of forecasts accurecyarrow_forwardConsider the following time series data. Week 1 2 3 4 5 6 Value 18 14 16 10 19 13 Using the naïve method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy. Mean absolute error. If required, round your answer to one decimal place. Mean squared error. If required, round your answer to one decimal place. Mean absolute percentage error. If required, round your intermediate calculations and final answer to two decimal places.arrow_forward
- Using excel. For the Hawkins Company, the monthly percentages of all shipments received on time over the past 12 months are 80, 82, 84, 83, 83, 84, 85, 84, 82, 83, 84, and 83. a. Construct a time series plot. What type of pattern exists in the data? b. Compare the three-month moving average approach with the exponential smoothing approach for α=\alpha =α= .2. Which provides more accurate forecasts using MSE as the measure of forecast accuracy? c. What is the forecast for next month?arrow_forwardUsing the accompanying table, determine the most appropriate forecasting technique for the accompanying data about the Dow Jones Industrial Average yearly closing value and implement the model. Year Close 1983 1258.64 1984 1211.57 1985 1546.67 1986 1895.95 1987 1938.83 1988 2168.57 1989 2753.2 1990 2633.66 1991 3168.83 1992 3301.11 1993 3754.09 1994 3834.44 1995 5117.12 1996 6448.27 1997 7908.25 1998 9181.43 1999 11497.12 2000 10786.85 2001 10021.5 2002 8341.63 2003 10453.92 2004 10783.01 2005 10717.5 2006 12463.15 2007 13264.82 2008 8776.39 2009 10428.05 2010 11557.5 2011 12217.6 2012 13104.1 Use the model forecast the closing value for 2015.Use α=0.7,β=0.3,and γ=0.4,as needed. F2015?arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
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