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
expand_more
expand_more
format_list_bulleted
Question
Chapter 17.4, Problem 18E
a.
To determine
Construct a time series plot.
Explain the type of pattern.
b.
To determine
Find the
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
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.
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.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.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
- Storrs Cycles has just started selling the new Cyclonemountain bike, with monthly sales as shown in the table. First,co-owner Bob Day wants to forecast by exponential smoothingby initially setting February’s forecast equal to January’s saleswith a = .1. Co-owner Sherry Snyder wants to use a three-periodmoving average. a) Is there a strong linear trend in sales over time?b) Fill in the table with what Bob and Sherry each forecast forMay and the earlier months, as relevant.c) Assume that May’s actual sales figure turns out to be 405.Complete the table’s columns and then calculate the meanabsolute deviation for both Bob’s and Sherry’s methods.d) Based on these calculations, which method seems moreaccurate?arrow_forwardThe following ratio-to-moving averages for the seasonally adjusted series were found by the decomposition method applied on a time series representing quarterly sales for January 2018 to December 2020 period: a. Calculate the Seasonal Index for every quarter. b. If the trend is described by the trend line T^ = 1,000 + 30 t, what is the forecast for the fourth quarter of 2021?arrow_forwardThe following linear trend expression was estimated using a time series with 17 time periods. Tt =129.5 + 4.8 t The trend projection for time period 18 is select one: a. 134.3 b. 211.1 c. 215.9 d. 68.4arrow_forward
- Compute the forecasted values for Yt for July and August in 2020 by using the modelsstated in (c) and (d)arrow_forwardConsider the following time series data Month 1 2 3 4 5 6 7 8 9 10 11 12 Value 90 89 86 91 90 91 88 86 91 93 90 88 a) Construct a time series plot in Excel. Label the axes and graph. c) Develop a smoothing model forecast with α = 0.35. Compute MSE and forecast for month 13 d) Which model is the better predictor? Why?arrow_forwardA researcher hypothesizes that in a certain country the net annual growth of private sector purchases of government bonds, B, is positively related to the nominal rate of interest on the bonds, NI, and negatively related to the rate of inflation Π: Bt = a0 + a1NIt + a2Π t + ut Note that it may be hypothesized that B depends on the real rate of interest on bonds, R, where R = NI – Π. Using a sample of 56 annual observations, s/he estimates the following equations: (1) Bt = 0.43 + 0.90NIt - 0.97Πt R21 = 0.962, SSR1 = 2.20, QRESET(F1,52) = 16.6 (3.58) (8.80) (-1.05) (2) Bt = 0.44 + 0.94Rt R22 = 0.960, SSR2 = 2.22, QRESET(F1,53) = 0.9 (9.70) (16.7) (3) Bt = 0.44 + 1.14NIt SSR3 = 9.20, QRESET(F1,53) = 59.9 (8.84) (36.1) (4) NIt = 0.08 + 0.94Πt R24 = 0.997, SSR4 = 0.18, QRESET(F1,53) = 1.4…arrow_forward
- The best fit line for a time series, {yt : t = 1,2,...,518} is found to be f (t) = 3.4025t + 199.3715. Based on the best fit line, what is the forecast value, when t = 518?arrow_forwardUse the basic equation for the capital asset pricing model (CAPM) to Find the risk-free rate for a firm with a required return of 15% and a beta of 1.25 when the market return is 14%arrow_forwardLook at the four plots in Figure 14.2—the US unemployment rate, thedollar-pound exchange rate, the logarithm of the index of industrial production, and the percentage change in stock prices. Which of these seriesappears to be non-stationary? Which of them appears to resemble a randomwalk?arrow_forward
- The number of users of a certain website (in millions) from 2004 through 2011 follows. Year Period Users (Millions) 2004 1 1 2005 2 7 2006 3 13 2007 4 57 2008 5 145 2009 6 360 2010 7 608 2011 8 846 (b) Using Minitab or Excel, develop a quadratic trend equation that can be used to forecast users (in millions). (Round your numerical values to one decimal place.)arrow_forwardThe median home value in Michigan and New York (adjusted for inflation) are shown below. Year Michigan New York 1950 45400 61500 2000 115600 148700 If we assume that the house values are changing linearly,a) In which state have home values increased at a higher rate? New York, Mich., or equal rates: b) If these trends were to continue, what would be the median home value in Michigan in 2010?$ :c) If we assume the linear trend existed before 1950 and continues after 2000, the two states' median house values will be (or were) equal in what year? (The answer might be absurd)The year :arrow_forwardA statistical program is recommended. The number of users of a certain website (in millions) from 2004 through 2011 follows. Year Period Users (Millions) 2004 1 1 2005 2 6 2006 3 11 2007 4 57 2008 5 145 2009 6 361 2010 7 609 2011 8 845 Using Minitab or Excel, develop a quadratic trend equation that can be used to forecast users (in millions). (Round your numerical values to one decimal place.)arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Algebra & Trigonometry with Analytic GeometryAlgebraISBN:9781133382119Author:SwokowskiPublisher:Cengage
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