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
Concept explainers
Videos
Question
Chapter 17, Problem 50SE
a.
To determine
Find the seasonal indexes for the four quarters using time series decomposition.
b.
To determine
Identify the largest seasonal effect, and check whether the result appears reasonable or not.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
It has been suggested that sales for the company may be connected to disposable income. Using the information below regarding historical disposable income, predict the sales for 2020 using regression analysis if a reliable prediction for disposable income for 2020 is $21,200.
Year
Disposable Income
2013
$18,000
2014
$18,618
2015
$19,099
2016
$24,453
2017
$24,906
2018
$20,388
2019
$21,425
Year
Sales
2013
$225,000
2014
$193,000
2015
$248,000
2016
$300,000
2017
$340,000
2018
$295,000
2019
$310,000
Which of the following time-series forecasting methods would not be used to forecast a time series that exhibits a linear trend with no seasonal or cyclical patterns?
a. Dummy variable regression
b. Linear trend regression
c. Multiplicative Winter's method
d. Holt Winter's double exponential smoothing
e. Both A and D
Movieflix, an online movie streaming service that offers a wide variety of award-winning TV shows, movies, animes, and documentaries, would like to determine the mathematical trend of memberships in order to project future needs.Year 2013 2014 2015 2016 2017 2018 2019 2020 2021Membership (000s)17 16 16 21 20 20 23 25 24
(i) Use the following time series data, to develop a regression equation relating memberships to time.
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
- Olympic Pole Vault The graph in Figure 7 indicates that in recent years the winning Olympic men’s pole vault height has fallen below the value predicted by the regression line in Example 2. This might have occurred because when the pole vault was a new event there was much room for improvement in vaulters’ performances, whereas now even the best training can produce only incremental advances. Let’s see whether concentrating on more recent results gives a better predictor of future records. (a) Use the data in Table 2 (page 176) to complete the table of winning pole vault heights shown in the margin. (Note that we are using x=0 to correspond to the year 1972, where this restricted data set begins.) (b) Find the regression line for the data in part ‚(a). (c) Plot the data and the regression line on the same axes. Does the regression line seem to provide a good model for the data? (d) What does the regression line predict as the winning pole vault height for the 2012 Olympics? Compare this predicted value to the actual 2012 winning height of 5.97 m, as described on page 177. Has this new regression line provided a better prediction than the line in Example 2?arrow_forwardWhat does the y -intercept on the graph of a logistic equation correspond to for a population modeled by that equation?arrow_forwardThe president of small manufacturing firm is concerned about the continual increase in manufacturing costs over the past several years. The following figures provide a time series of the cost per unit for the firm’s leading product over the past eight years. Year Cost/Unit ($) Year Cost/Unit ($) 1 20.00 5 26.60 2 24.50 6 30.00 3 28.20 7 31.00 4 27.50 8 36.00 Construct a time series plot. What type of pattern exists in the data? Use simple linear regression analysis to find the parameters for the line that minimizes MSE for this time series. What is the average cost increase that the firm has been realizing per year? Compute an estimate of the cost/unit for next year.arrow_forward
- Editor of Astrology Magazine wants to obtain sales forecast value for 2021. Use the given data below and help the editor. Year Quarter Sales 2019 1. 53 2. 51 3. 48 4. 55 2020 1. 53 2. 51 3. 54 4. 52 Use time series regression model and determine sales forecast value for the second quarter of 2021arrow_forwardCompute the forecasted values for Yt for July and August in 2020 by using the modelsstated in (c) and (d)arrow_forwardThe following scatterplot shows a company’s monthly sales, in thousands of dollars, versus monthly advertising dollars spent, in thousands of dollars. Which of the following points is most likely a high-leverage point with respect to a regression of monthly sales versus advertising dollars?arrow_forward
- If a sample of 25 pairs of data yields a correlation coefficient, r, of 0.390 and the scatterplot displays a linear trend, can you use the regression equation to make predictions, assuming your x-values are within the domain of the data set? Choose your answer from the multiple choice answers below A.) Yes, because rcrit = 0.396 and the regression coefficient, r, is less than this value. B.) Yes, because rcrit = 0.381 and the regression coefficient, r, is greater than this value. C.) No, because rcrit = 0.381 and the regression coefficient, r, is greater than this value. D.) No, because rcrit = 0.396 and the regression coefficient, r, is less than this value.arrow_forwardConsider the following time series: Quarter Year 1 Year 2 Year 3 1 66 63 57 2 48 40 50 3 59 61 54 4 73 76 67 (a) Choose a time series plot. (i) (ii) (iii) (iv) What type of pattern exists in the data? Is there an indication of a seasonal pattern? (b) Use a multiple linear regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data: Qtr1 = 1 if quarter 1, 0 otherwise; Qtr2 = 1 if quarter 2, 0 otherwise; Qtr3 = 1 if quarter 3, 0 otherwise. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank (Example: -300). ŷ = ?? + ?? Qtr1 +?? Qtr2 + ?? Qtr3 (c) Compute the quarterly forecasts for next year. Year Quarter Ft 4 1 4 2 4 3 4 4arrow_forwardConsider the following time series data: Quarter Year 1 Year 2 Year 3 1 4 6 7 2 2 3 6 3 3 5 6 4 5 7 8 A. Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data: Q1 if quarter 1, 0 otherwise; Q2 if quarter 2, 0 otherwise; Q3 if quarter 3, 0 otherwise. B. Use a multiple regression model to develop an equation to account for trend and seasonal effects in the data. Use the dummy variables you developed in part (A) to capture seasonal effects and create a variable "Trend" such that T=1 for quarter 1 in year 1, T=2 for quarter 2 in year1,.... T=12 for quarter 4 in year 3.arrow_forward
- Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 4 6 7 2 2 3 6 3 3 5 6 4 5 7 8 Choose the correct time series plot. (i) (ii) (iii) (iv) - Plot (iii) What type of pattern exists in the data?- Horizontal Pattern with Seasonality Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. Qtr1 = 1 if Quarter 1, 0 otherwise; Qtr2 = 1 if Quarter 2, 0 otherwise; Qtr3 = 1 if Quarter 3, 0 otherwise. If required, round your answers to three decimal places. For subtractive or negative numbers use a minus sign even if there is a + sign before the blank. (Example: -300)Value = fill in the blank 3 + fill in the blank 4 Qtr1 + fill in the blank 5 Qtr2 + fill in the blank 6 Qtr3 + fill in the blank 7 t Compute the quarterly forecasts for next year. If…arrow_forwardBelow you are given the first five values of a quarterly time series. The multiplicative model is appropriate and a four-quarter moving average will be used. Year Quarter Time Series Value Yt 1 1 36 2 24 3 16 2 4 20 1 44 An estimate of the combined trend-cycle component (T2Ct) for Quarter 3 of Year 1 (used for estimating the de-trended values), when a four-quarter moving average is used, is a. 24. b. 26. c. 28. d. 25.arrow_forwardCinema HD an online movie streaming service that offers a wide variety of award-winning TV shows, movies, animes, and documentaries, would like to determine the mathematical trend of memberships in order to project future needs. Year 2013 2014 2015 2016 2017 2018 2019 2020 2021 Membership 17 16 16 21 20 20 23 25 24 Use the following time series data, to develop a regression equation relating memberships to time. Forecast 2023 membership Assuming the COVID-19 pandemic comes to an end in 2021, in your opinion, how will this affect membership? Why? How will this affect your prediction? What are the issues associated with qualitative forecasting, and how are these overcome? Provide an example of qualitative forecasting and explain the shortcomings.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
College AlgebraAlgebraISBN:9781305115545Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage Learning
College Algebra
Algebra
ISBN:9781305115545
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning
Correlation Vs Regression: Difference Between them with definition & Comparison Chart; Author: Key Differences;https://www.youtube.com/watch?v=Ou2QGSJVd0U;License: Standard YouTube License, CC-BY
Correlation and Regression: Concepts with Illustrative examples; Author: LEARN & APPLY : Lean and Six Sigma;https://www.youtube.com/watch?v=xTpHD5WLuoA;License: Standard YouTube License, CC-BY