Statistics for Business & Economics, Revised (MindTap Course List)
12th Edition
ISBN: 9781285846323
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Publisher: South-Western College Pub
expand_more
expand_more
format_list_bulleted
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
Find out the next month after april income by using the forecasting method of the moving average method
Using the accompanying table, determine the most appropriate forecasting technique for the accompanying data about the Dow Jones Industrial Average yearly closing value and implement the model.
Year
Close
1983
1258.64
1984
1211.57
1985
1546.67
1986
1895.95
1987
1938.83
1988
2168.57
1989
2753.2
1990
2633.66
1991
3168.83
1992
3301.11
1993
3754.09
1994
3834.44
1995
5117.12
1996
6448.27
1997
7908.25
1998
9181.43
1999
11497.12
2000
10786.85
2001
10021.5
2002
8341.63
2003
10453.92
2004
10783.01
2005
10717.5
2006
12463.15
2007
13264.82
2008
8776.39
2009
10428.05
2010
11557.5
2011
12217.6
2012
13104.1
Use the model forecast the closing value for 2015.Use α=0.7,β=0.3,and γ=0.4,as needed. F2015?
Use the following Sales Data to
a) Develop a 4-month moving average forecast, a forecast for January, and compute the MAD.
b)Develop 3-month moving average forecast, a forecast for January, and calculate a MAD.
c) Which model should be used in the future? Explain why this is your answer.
Month
Actual Shed Sales
January
10
February
12
March
13
April
16
May
19
June
23
July
26
August
30
September
28
October
18
November
16
December
14
Chapter 17 Solutions
Statistics for Business & Economics, Revised (MindTap Course List)
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
- Amex PLC has gathered following information on the sales of face mask from April 2020 toSeptember 2020.Month Sales ($)April 17,000May 18,000June 19,500July 22,000August 21,000September 23,000You are required to;a. Using linear trend equation forecast the sales of face masks for October 2020.arrow_forwardConsider the table. Sales on Toaster Ovens 2004 2005 2006 2007 2008 Super Deluxe $86,100 $140,500 $65,800 $56,100 $59,000 Deluxe 103,200 136,100 129,900 133,800 75,400 Standard 147,300 123,600 125,500 132,600 58,000 What percent of the total sales in 2004 were the deluxe model? (Round to the nearest tenth percent.)arrow_forwardIn a particularly small region in the Philippines, the consumer price index C depends onarrow_forward
- If year one equals P800,000, year two equals P840,000, and year three equals P896,000, the percentage to be assigned for year three in a trend analysis, assuming that year 1 is the base year, is a. 105%. b. 89%. c. 100%. d. 112%.arrow_forwardThe report “Daily Cigarette Use: Indicators on Children and Youth" (Child Trends Data Bank, childtrends.org/wp-content/uploads/2012/11/03 _Smoking_new.pdf, retrieved April 17, 2017) included the accompanying data on the percentage of students who report smoking cigarettes daily, for students in grades 8, 10, and 12. Construct a time series plot for students in grade 12, and comment on any trend over time. Construct a time series plot that shows trends over time for each of the three grade levels. Graph each of the three-time series on the same set of axes, using different colors to distinguish the different grade levels. Either label the time series in the plot or include a legend to indicate which time series corresponds to which grade level. Write a paragraph based on the plot from Part (b). Discuss the similarities and differences for the three grade levelsarrow_forwardWhich of the following time series forecasting methods would not be used to forecast seasonal data?arrow_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_forwardThe Beaver Creek Pottery Company sells bowls and mugs, hand-made by Native American artisans, at a craft store and through a Web site. Making these items requires a special type of clay and a large amount of individual person-hours, so for planning purposes, the company would like to forecast future demand, specifically through its Web site, which has increasingly become the primary source of sales. Following is the company’s Web site demand (in items sold) for the past 36 months: Develop a linear trend forecast model, an exponentially smoothed model (a = 0.20), and a 5-month moving average forecast model and indicate which one you think should be used to forecast Web site demand.arrow_forwardUsing the data in Table 6–11, calculate a 3-month moving average forecast for month 12.arrow_forward
- The Bank of Canada is interested in studying the relationship between mortgage rates and median home prices. The data is provided below Year interest rate (%) Median home price 1988 10.30 $183,800 1989 10.30 $183,200 1990 10.10 $174,900 1991 9.30 $173,500 1992 8.40 $172,900 1993 7.30 $173,200 1994 8.40 $173,200 1995 7.90 $169,700 1996 7.60 $174,500 1997 7.60 $177,900 1998 6.90 $188,100 1999 7.40 $203,200 2000 8.10 $230,200 2001…arrow_forward13. Does the following have a positive, negative, or neutral trend?arrow_forward2. A study was conducted to determine the relationship between a person’s monthly income in Omani Rials and the number of meals that person eats away from home per month. The data are shown below.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- MATLAB: An Introduction with ApplicationsStatisticsISBN:9781119256830Author:Amos GilatPublisher:John Wiley & Sons IncProbability and Statistics for Engineering and th...StatisticsISBN:9781305251809Author:Jay L. DevorePublisher:Cengage LearningStatistics for The Behavioral Sciences (MindTap C...StatisticsISBN:9781305504912Author:Frederick J Gravetter, Larry B. WallnauPublisher:Cengage Learning
- Elementary Statistics: Picturing the World (7th E...StatisticsISBN:9780134683416Author:Ron Larson, Betsy FarberPublisher:PEARSONThe Basic Practice of StatisticsStatisticsISBN:9781319042578Author:David S. Moore, William I. Notz, Michael A. FlignerPublisher:W. H. FreemanIntroduction to the Practice of StatisticsStatisticsISBN:9781319013387Author:David S. Moore, George P. McCabe, Bruce A. CraigPublisher:W. H. Freeman
MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc
Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning
Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning
Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON
The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman
Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman
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