Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
6th Edition
ISBN: 9781337115186
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Publisher: Cengage Learning
bartleby

Videos

Textbook Question
Chapter 17.3, Problem 13E

The values of Alabama building contracts (in $ millions) for a 12-month period follow.

Chapter 17.3, Problem 13E, The values of Alabama building contracts (in $ millions) for a 12-month period follow.

Construct a

  1. a. Construct a time series plot. What type of pattern exists in the data?
  2. b. Compare the three-month moving average approach with the exponential smoothing forecast using α = .2. Which provides more accurate forecasts based on MSE?
  3. c. What is the forecast for the next month?
Blurred answer
Students have asked these similar questions
Which of the following time series forecasting methods would not be used to forecast seasonal data?
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?
After its move in 1990 to La Junta, Colorado, and its new initiatives, the DeBourgh Manufacturing Company began an upward climb of record sales. Suppose the figures shown here are the DeBourgh monthly sales figures from January 2001 through December 2009 (in $1,000s). a) Produce a time series plot. Are there any trends evident in the data? Does DeBourgh have a seasonal component to its sales? b) Deseasonalize the data using Multiplicative model with a 0.5 weighted moving average. Produce a time series plot of the deseasonalized data and add a trendline. c) Forecast the sales from January to December of the year 2010. d) Include a discussion of the general direction of sales and any seasonal tendencies that might be occurrinG Month 2001 2002 2003 2004 2005 2006 2007 2008 2009 January 139.7 165.1 177.8 228.6 266.7 431.8 381 431.8 495.3 February 114.3 177.8 203.2 254 317.5 457.2 406.4 444.5 533.4 March 101.6 177.8 228.6 266.7 368.3 457.2 431.8 495.3 635 April 152.4 203.2…

Chapter 17 Solutions

Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)

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
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
    Recommended textbooks for you
  • MATLAB: An Introduction with Applications
    Statistics
    ISBN:9781119256830
    Author:Amos Gilat
    Publisher:John Wiley & Sons Inc
    Probability and Statistics for Engineering and th...
    Statistics
    ISBN:9781305251809
    Author:Jay L. Devore
    Publisher:Cengage Learning
    Statistics for The Behavioral Sciences (MindTap C...
    Statistics
    ISBN:9781305504912
    Author:Frederick J Gravetter, Larry B. Wallnau
    Publisher:Cengage Learning
  • Elementary Statistics: Picturing the World (7th E...
    Statistics
    ISBN:9780134683416
    Author:Ron Larson, Betsy Farber
    Publisher:PEARSON
    The Basic Practice of Statistics
    Statistics
    ISBN:9781319042578
    Author:David S. Moore, William I. Notz, Michael A. Fligner
    Publisher:W. H. Freeman
    Introduction to the Practice of Statistics
    Statistics
    ISBN:9781319013387
    Author:David S. Moore, George P. McCabe, Bruce A. Craig
    Publisher:W. H. Freeman
  • MATLAB: An Introduction with Applications
    Statistics
    ISBN:9781119256830
    Author:Amos Gilat
    Publisher:John Wiley & Sons Inc
    Probability and Statistics for Engineering and th...
    Statistics
    ISBN:9781305251809
    Author:Jay L. Devore
    Publisher:Cengage Learning
    Statistics for The Behavioral Sciences (MindTap C...
    Statistics
    ISBN:9781305504912
    Author:Frederick J Gravetter, Larry B. Wallnau
    Publisher:Cengage Learning
    Elementary Statistics: Picturing the World (7th E...
    Statistics
    ISBN:9780134683416
    Author:Ron Larson, Betsy Farber
    Publisher:PEARSON
    The Basic Practice of Statistics
    Statistics
    ISBN:9781319042578
    Author:David S. Moore, William I. Notz, Michael A. Fligner
    Publisher:W. H. Freeman
    Introduction to the Practice of Statistics
    Statistics
    ISBN:9781319013387
    Author:David S. Moore, George P. McCabe, Bruce A. Craig
    Publisher:W. H. Freeman
    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