EBK STATISTICS FOR BUSINESS & ECONOMICS
12th Edition
ISBN: 8220100460463
Author: Anderson
Publisher: CENGAGE L
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 17, Problem 51SE
Refer to the Costello Music Company time series in exercise 49.
- a. Deseasonalize the data and use the deseasonalized time series to identify the trend.
- b. Use the results of part (a) to develop a quarterly forecast for next year based on trend.
- c. Use the seasonal indexes developed in exercise 50 to adjust the forecasts developed in part (b) to account for the effect of season.
50. Refer to the Costello Music Company problem in exercise 49.
- a. Using time series decomposition, compute the seasonal indexes for the four quarters.
- b. When does Costello Music experience the largest seasonal effect? Does this result appear reasonable? Explain.
49. Consider the Costello Music Company problem in exercise 48. The quarterly sales data follow.
| Year | Quarter I | Quarter 2 | Quarter 3 | Quarter 4 | Total Yearly Sales |
| 1 | 4 | 2 | 1 | 5 | 12 |
| 2 | 6 | 4 | 4 | 14 | 28 |
| 3 | 10 | 3 | 5 | 16 | 34 |
| 4 | 12 | 9 | 7 | 22 | 50 |
| 5 | 18 | 10 | 13 | 35 | 76 |
- a. Use the following dummy variables to develop an estimated regression equation to account for any seasonal and linear trend effects in the data: Qtr1 = 1 if Quarter 1, 0 otherwise; Qtr2 = 1 if Quarter 2, 0 otherwise; and Qtr3 = 1 if Quarter 3, 0 otherwise.
- b. Compute the quarterly forecasts for next year.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
What do the Forecast for each year add up to?
John Kittle, an independent insurance agent, uses a five-year moving average to forecast the number of claims made in a single year for one of the large insurance companies he sells for. He has just discovered that a clerk in his employ incorrectly entered the number of claims made four years ago as 1,400 when it should have been 1,200.a. What adjustment should Mr. Kittle make in next year’s forecast to take into account the corrected value of the number of claims four years ago?b. Suppose that Mr. Kittle used simple exponential smoothing with a = .2instead of moving averages to determine his forecast. What adjustment is now required in next year’s forecast? (Note that you do not need to know the value of the forecast for next year in order to solve this problem.)
In Colorado, sales of medical marijuana began in November 2012; however, the Department of Revenue did not report tax collection data until February of 2014. The accompanying data file includes monthly revenue from medical and retail marijuana tax and fee collections as posted in the Colorado state accounting system. Use the linear trend model (no seasonality) to forecast the tax revenue for November and December of 2018.
Date
Revenue
February/14
3,519,756
March/14
4,092,575
April/14
4,980,992
May/14
5,273,355
June/14
5,715,707
July/14
6,522,085
August/14
7,407,450
September/14
7,741,167
October/14
7,232,870
November/14
7,642,800
December/14
7,465,568
January/15
8,558,141
February/15
8,802,295
March/15
9,099,395
April/15
9,979,643
May/15
10,617,311
June/15
11,326,452
July/15
10,856,584
August/15
12,811,437
September/15
13,181,758
October/15
11,656,736
November/15
11,290,012
December/15
12,231,410
January/16
13,247,434
February/16…
Chapter 17 Solutions
EBK STATISTICS FOR BUSINESS & ECONOMICS
Ch. 17.2 - Consider the following time series data. Week 1 2...Ch. 17.2 - Refer to the time series data in exercise 1. Using...Ch. 17.2 - Exercises 1 and 2 used different forecasting...Ch. 17.2 - Consider the following time series data. Month 1 2...Ch. 17.3 - Consider the following time series data. Week 1 2...Ch. 17.3 - Consider the following time series data. Month 1 2...Ch. 17.3 - Refer to the gasoline sales time series data in...Ch. 17.3 - Refer again to the gasoline sales time series data...Ch. 17.3 - With the gasoline time series data from Table...Ch. 17.3 - 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 - The U.S. Census Bureau tracks the median price for...Ch. 17.4 - Consider the following time series data. a....Ch. 17.4 - Prob. 18ECh. 17.4 - Consider the following time series. a. Construct a...Ch. 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 - FRED (Federal Reserve Economic Data), a database...Ch. 17.4 - Automobile unit sales at B. J. Scott Motors, Inc.,...Ch. 17.4 - Giovanni Food Products produces and sells frozen...Ch. 17.4 - Prob. 27ECh. 17.5 - Consider the following time series. a. Construct a...Ch. 17.5 - Consider the following time series data. a....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 - Three years of monthly lawn-maintenance expenses...Ch. 17.6 - Consider the following time series data. a....Ch. 17.6 - Refer to exercise 35. a. 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 - Prob. 44SECh. 17 - Prob. 45SECh. 17 - The Mayfair Department Store in Davenport, Iowa,...Ch. 17 - Canton Supplies, Inc., is a service firm that...Ch. 17 - The Costello Music Company has been in business...Ch. 17 - Consider the Costello Music Company problem in...Ch. 17 - Refer to the Costello Music Company problem in...Ch. 17 - Refer to the Costello Music Company time series in...Ch. 17 - Hudson Marine has been an authorized dealer for CD...Ch. 17 - Refer to the Hudson Marine problem in exercise 52....Ch. 17 - Refer to the Hudson Marine problem in exercise 53....Ch. 17 - Refer to the Hudson Marine data in exercise 53. a....Ch. 17 - Forecasting Food and Beverage Sales The Vintage...Ch. 17 - Forecasting Lost Sales The Carlson Department...
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
- Find the mean hourly cost when the cell phone described above is used for 240 minutes.arrow_forward1. Perform a Trend and Seasonal analysis with the following data. Include the trend formulaand the multiplicative indices for the seasons. Using the model forecast sales for the nextyear (all 4 seasons of year 4).Year Season Sales1 sp 1401 su 501 w 1301 f 5202 sp 2002 su 1102 w 1902 f 5503 sp 2603 su 2203 w 2103 f 570arrow_forwardUse the most accurate method to forecast the revenues of licenses, permits, and fees in Years 9, 10, and 11. Use the Year 8 actual figure instead of the forecast figure (Year 8 was $23,210,218). Also, consider three incremental changes in forecasting.arrow_forward
- Please help with the corrected answers in details: The following time series shows the sales of a particular product over the past 12 months. Month Sales 1 105 2 135 3 120 4 105 5 90 6 120 7 145 8 140 9 100 10 80 11 100 12 110 What type of pattern exists in the data? The data appear to follow a trend pattern. The data appear to follow a horizontal pattern. The data appear to follow a cyclical pattern.The data appear to follow a seasonal pattern. (b) Use ? = 0.2 to compute the exponential smoothing values for the time series. (Round your answers to two decimal places.) Month t Time Series Value Yt Forecast Ft 1 105 2 135 3 120 4 105 5 90 6 120 7 145 8 140 9 100 10 80 11 100 12 110 (c) Use a smoothing constant of ? = 0.4 to compute the exponential smoothing forecasts. (Round your answers to two decimal places.) Month t Time Series Value Yt Forecast Ft 1 105 2 135…arrow_forwardMazars is an integral player in auditing, accounting, tax and advisory services in South Africa. A seasonal analysis was done on their sales for the period between 2009 and 2014 and the Median Seasonal Index's and the Adjusted Seasonal index's was calculated for each quarter as reflected below. Median seasonal Index Adjusted seasonal index Quarter 1 79.5660 79.0886 Quarter 2 85.3333 84.8213 Quarter 3 135.9855 135.1696 Quarter 4 101.5385 100.9293 Total 400.00 Each adjusted seasonal index measures the magnitude of seasonal influence on the actual values of the time series for a given period within the year. Interpret the seasonal analysis results for Quarter 1arrow_forward6. The annual population of Afghanistan is available in the global economy data set. a. Plot the data and comment on its features. Can you observe the effect of the Soviet- Afghan war? b. Fit a linear trend model and compare this to a piecewise linear trend model with knots at 1980 and 1989. c. Generate forecasts from these two models for the five years after the end of the data, and comment on the results.arrow_forward
- Consider the following time series: Quarter Year 1 Year 2 Year 3 1 69 66 60 2 44 36 46 60 62 55 4 79 82 73 3.arrow_forwardFind the seasonal variations by the method of 'ratio to trend' for the followin data of sales of a company : II III IV I Year/Qtrs. 2011 80 72 68 60 68 104 100 88 2012 80 116 108 96 2013 108 152 136 124 2014 160 184 172 164 2015arrow_forward2.5 2.0 15 1.0 0.5 Incarcerated Americans 1920-2014 Prison Jail 0 1920 1930 1940 1950 1960 1970 1980 1990 2000 2010 Year Juvenile Detention 6. Describe the trend depicted in this ch 7. What impact do you think this trend has had on the public defender system? depicarrow_forward
- 1. Give below is the data on production of a company (in lakhs). Year: 1983 1984 1985 1986 1987 1988 1989 Production: 15 14 18 20 17 24 27 Fit the linear trend. Compute the trend values for each year. Estimate the production for yeаr 1991.arrow_forwardIV.arrow_forward4. Compare the high and the low common stock prices since 2007 in a graph of your choice for "XXX" Corporation. Write a brief interpretation of the main features of the data portrayed in the graph. The high and the low common stock prices for the "XXX" Corporation since 1983 are: Year High Low 2007 40.85 30.90 2008 40.85 30.00 2009 40.85 29.25 2010 48.00 34.00 2011 64.75 32.00 Year High Low 2013 72.00 45.75 2014 81.65 63.25 2015 80.15 63.50 2016 75.35 60.25 2017 98.35 67.75 2018 99.00 70.00 2012 51.75 39.65arrow_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
College Algebra (MindTap Course List)AlgebraISBN:9781305652231Author:R. David Gustafson, Jeff HughesPublisher:Cengage Learning
Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
Functions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher: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
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
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