Bundle: Modern Business Statistics with Microsoft Office Excel, Loose-Leaf Version, 6th + MindTap Business Statistics, 2 terms (12 months) Printed Access Card
6th Edition
ISBN: 9781337589383
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 17.3, Problem 6E
Consider the following time series data.
Construct 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 MSE and a forecast for week 8.
- b. Use α = .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 α = .2. Which appears to provide more accurate forecasts based on MSE?
- d. Use a smoothing constant of α = .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.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
1. Show that, for any non-negative random variable X,
EX+E+≥2,
X
E max X.
21.
a small pond contains eight catfish and six bluegill. If seven fish are caught at random, what is the probability that exactly five catfish have been caught?
23 The line graph in the following figure shows
Revenue ($ millions)
one company's revenues over time. Explain
why this graph is misleading and what you
can do to fix the problem.
700
60-
50-
40
30
Line Graph of Revenue
20-
101
1950
1970
1975 1980 1985
Year
1990
2000
Chapter 17 Solutions
Bundle: Modern Business Statistics with Microsoft Office Excel, Loose-Leaf Version, 6th + MindTap Business Statistics, 2 terms (12 months) Printed Access Card
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 - The following data shows the average interest rate...Ch. 17.4 - Quarterly revenue ($ millions) for Twitter for the...Ch. 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 - Annual retail store revenue for Apple from 2007 to...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
- d of the 20 respectively. Interpret the shape, center and spread of the following box plot. 14 13 12 11 10 6 T 89 7 9 5. 治arrow_forwardF Make a box plot from the five-number summary: 100, 105, 120, 135, 140. harrow_forward14 Is the standard deviation affected by skewed data? If so, how? foldarrow_forward
- Frequency 15 Suppose that your friend believes his gambling partner plays with a loaded die (not fair). He shows you a graph of the outcomes of the games played with this die (see the following figure). Based on this graph, do you agree with this person? Why or why not? 65 Single Die Outcomes: Graph 1 60 55 50 45 40 1 2 3 4 Outcome 55 6arrow_forwardlie y H 16 The first month's telephone bills for new customers of a certain phone company are shown in the following figure. The histogram showing the bills is misleading, however. Explain why, and suggest a solution. Frequency 140 120 100 80 60 40 20 0 0 20 40 60 80 Telephone Bill ($) 100 120arrow_forward25 ptical rule applies because t Does the empirical rule apply to the data set shown in the following figure? Explain. 2 6 5 Frequency 3 сл 2 1 0 2 4 6 8 00arrow_forward
- 24 Line graphs typically connect the dots that represent the data values over time. If the time increments between the dots are large, explain why the line graph can be somewhat misleading.arrow_forward17 Make a box plot from the five-number summary: 3, 4, 7, 16, 17. 992) waarrow_forward12 10 - 8 6 4 29 0 Interpret the shape, center and spread of the following box plot. brill smo slob.nl bagharrow_forward
- Suppose that a driver's test has a mean score of 7 (out of 10 points) and standard deviation 0.5. a. Explain why you can reasonably assume that the data set of the test scores is mound-shaped. b. For the drivers taking this particular test, where should 68 percent of them score? c. Where should 95 percent of them score? d. Where should 99.7 percent of them score? Sarrow_forward13 Can the mean of a data set be higher than most of the values in the set? If so, how? Can the median of a set be higher than most of the values? If so, how? srit to estaarrow_forwardA random variable X takes values 0 and 1 with probabilities q and p, respectively, with q+p=1. find the moment generating function of X and show that all the moments about the origin equal p. (Note- Please include as much detailed solution/steps in the solution to understand, Thank you!)arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Trigonometry (MindTap Course List)TrigonometryISBN:9781305652224Author:Charles P. McKeague, Mark D. TurnerPublisher:Cengage Learning
Trigonometry (MindTap Course List)TrigonometryISBN:9781337278461Author:Ron LarsonPublisher:Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
Trigonometry (MindTap Course List)
Trigonometry
ISBN:9781305652224
Author:Charles P. McKeague, Mark D. Turner
Publisher:Cengage Learning
Trigonometry (MindTap Course List)
Trigonometry
ISBN:9781337278461
Author:Ron Larson
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