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

Question
Book Icon
Chapter 17.4, Problem 18E

a.

To determine

Construct a time series plot.

Explain the type of pattern.

b.

To determine

Find the quadratic trend equation for the updated time series.

c.

To determine

Find the forecast value for time period 8 using the quadratic trend equation obtained in Part (b).

d.

To determine

Compute the forecast for t=8 using the linear trend equation developed in Exercise 17.

Comment on the difference between the linear trend forecast and the quadratic trend forecast and also find what is needed to be done as new time series data become available.

Blurred answer
Students have asked these similar questions
consider the following time series data.t 1 2 3 4 5 6 7yt10 9 7 8 6 4 4a. construct a time series plot. What type of pattern exists in the data?b. develop the linear trend equation for this time series.c. What is the forecast for t = 8?
hudson Marine has been an authorized dealer for c&d marine radios for the past sevenyears. the following table reports the number of radios sold each year.Year 1 2 3 4 5 6 7Number Sold 35 50 75 90 105 110 130a. construct a time series plot. does a linear trend appear to be present?b. Using Minitab or excel, develop a linear trend equation for this time series.c. Use the linear trend equation developed in part (b) to develop a forecast for annualsales in year 8.
The following table shows a company's annual revenue (in billions of dollars) for 2009 to 2014. Year Period (t) Revenue 2009 1 23.8 2010 2 29.2 2011 3 37.8 2012 4 50.1 2013 5 59.9 2014 6 66.8 -Develop a linear trend equation for this time series to forecast revenue (in billions of dollars). (Round your numerical values to three decimal places.) -What is the average revenue increase per year (in billions of dollars) that this company has been realizing? (Round your answer to three decimal places.) -Compute an estimate of this company's revenue (in billions of dollars) for 2015. (Round your answer to two decimal places.)

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
Background pattern image
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
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
College Algebra
Algebra
ISBN:9781938168383
Author:Jay Abramson
Publisher:OpenStax
Text book image
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:9781133382119
Author:Swokowski
Publisher:Cengage
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