EBK STATISTICS FOR BUSINESS & ECONOMICS
12th Edition
ISBN: 9780100460461
Author: Anderson
Publisher: YUZU
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 17, Problem 55SE
Refer to the Hudson Marine data in exercise 53.
- 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 54 to adjust the forecasts developed in part (b) to account for the effect of season.
53. Refer to the Hudson Marine problem in exercise 52. Suppose the quarterly sales values for the seven years of historical data are as follows.
| Year | Quarter 1 | Quarter 2 | Quarter 3 | Quarter 4 | Total Yearly Sales |
| 1 | 6 | 15 | 10 | 4 | 35 |
| 2 | 10 | 18 | 15 | 7 | 50 |
| 3 | 14 | 26 | 23 | 12 | 75 |
| 4 | 19 | 28 | 25 | 18 | 90 |
| 5 | 22 | 34 | 28 | 21 | 105 |
| 6 | 24 | 36 | 30 | 20 | 110 |
| 7 | 28 | 40 | 35 | 27 | 130 |
- a. Use the following dummy variables to develop an estimated regression equation to account for any season 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?
2.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?
depic
Plot the sales revenue figures and appropriate trend line on a graph and identify from this the choice of model for working out the seasonal component.
Using the appropriate seasonal model, complete the calculations that are required to produce the required forecasts for quarters 1, 2, 3 and 4 of 2021.
On the basis of your analysis explain the recommendation that you would make to ALAW Ltd regarding its future plans.
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
- 6. 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_forwardIn 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…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_forward
- 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.)arrow_forwardFind the MSE in part (b) please.arrow_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
- Q1. Find four years weighted moving average? Forecast for 2019 with weights 1,4,2, , Also ...... find MAPE? (10 Year Cost 2013 18 2014 21 2015 18 2016 16 2017 20 2018 24 2019arrow_forwardPlease 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_forward3) U.S. Health care expenditures. Because the over-65 population is growing more rapidly in the next few decades health care spending is expected to increase significantly in the next few decades. The following table gives the projected US health care expenditure (in trillions) from 2008 to 2013 Year 2008 2009 2010 2011 2012 2012 Expenditure 2.34 2.47 2.57 2.70 2.85 3.02 a) Draw a scatter diagram for this data. Use “Years since 2008” on the x-axis. Make sure the scatter diagram includes all required elements (axes labels, title, and appropriate scale) b) Use the points for 2009 and 2011 to find an equation of a line modeling this situation c) Use linear regression to find an equation of a line modeling this situation d) Use the equation in b to predict expenditures in 2016 and do this again for the equation in part c. What is the absolute and percentage difference between the two equations (use the equation in c as the base equation in the % calculation) e) Now use…arrow_forward
- Please answer part B and Carrow_forwardSuppose that you are a researcher and wish to construct a linear mathematical (statistical) model that relates the number of years and the corresponding exports (million U.S,$) of a country. The constructed model may use to forecasts the future values. You have obtained the relevant data for a decade during 1990 to 1999 and you have listed the data in Table 5. Table 5. Shows the list of the amount that have earned on exports 6| 7| 8 Year No. 1| 2 | 3 | 4 10 Exports 4954 6131 | 6904| 6813 6803 8137| 8707 8320 8628 7779 (a) Construct a suitable graph that explains the relationship between the number of years and the corresponding exports. By inspection of the graph comment on the relationships between the number of vears and the corresponding exports. (b) Construct a mathematical (Statistical) model by using least square method between number of years and the corresponding sales. Also interpret the slope of the linear model to support your comment. (c) Forecast the value of sales by…arrow_forward( explain all point of question with proper answer).arrow_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
Trigonometry (MindTap Course List)TrigonometryISBN:9781305652224Author:Charles P. McKeague, Mark D. TurnerPublisher:Cengage Learning
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Trigonometry (MindTap Course List)
Trigonometry
ISBN:9781305652224
Author:Charles P. McKeague, Mark D. Turner
Publisher:Cengage Learning
Big Ideas Math A Bridge To Success Algebra 1: Stu...
Algebra
ISBN:9781680331141
Author:HOUGHTON MIFFLIN HARCOURT
Publisher:Houghton Mifflin Harcourt
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