STATISTICS F/BUSINESS+ECONOMICS-TEXT
13th Edition
ISBN: 9781305881884
Author: Anderson
Publisher: CENGAGE L
expand_more
expand_more
format_list_bulleted
Question
Chapter 17.4, Problem 27E
a.
To determine
Construct the time series plot.
Explain the type of pattern.
b.
To determine
Calculate the
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
the values of alabama building contracts (in $ millions) for a 12-month period follow.240 350 230 260 280 320 220 310 240 310 240 230a. construct a time series plot. What type of pattern exists in the data?
In retail, a store manager uses time series models to understand shopping trends.
Review the scatter plot of the store’s sales from 2010 through 2021 to answer the questions. See attached as image.
Here is the data for Fiscal Year and Sales:
Fiscal Year
Sales
2010
$260,123.00
2011
$256,853.00
2012
$274,366.00
2013
$290,525.00
2014
$322,318.00
2015
$380,921.00
2016
$541,925.00
2017
$909,050.00
2018
$1,817,521.00
2019
$3,206,564.00
2020
$4,921,005.00
2021
$5,686,338.00
Time series decomposition seeks to separate the time series (Y) into 4 components: trend (T), cycle (C), seasonal (S), and irregular (I). What is the difference between these components?
The model can be additive or multiplicative. When do you use each?
Review the scatter plot of the exponential trend of the time series data. Do you observe a trend? If so, what type of trend do you observe?
What predictions might you make about the store’s annual sales over the next few years?
After its move in 1990 to La Junta, Colorado, and its new initiatives, the DeBourgh Manufacturing Company began an upward climb of record sales. Suppose the figures shown here are the DeBourgh monthly sales figures from January 2001 through December 2009 (in $1,000s).
a) Produce a time series plot. Are there any trends evident in the data? Does DeBourgh have a seasonal component to its sales?
b) Deseasonalize the data using Multiplicative model with a 0.5 weighted moving average. Produce a time series plot of the deseasonalized data and add a trendline.
c) Forecast the sales from January to December of the year 2010.
d) Include a discussion of the general direction of sales and any seasonal tendencies that might be occurrinG
Month
2001
2002
2003
2004
2005
2006
2007
2008
2009
January
139.7
165.1
177.8
228.6
266.7
431.8
381
431.8
495.3
February
114.3
177.8
203.2
254
317.5
457.2
406.4
444.5
533.4
March
101.6
177.8
228.6
266.7
368.3
457.2
431.8
495.3
635
April
152.4
203.2…
Chapter 17 Solutions
STATISTICS F/BUSINESS+ECONOMICS-TEXT
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 - The Seneca Childrens Fund (SCF) is a local charity...Ch. 17.4 - The following table shows Googles annual revenue...Ch. 17.4 - FRED (Federal Reserve Economic Data), a database...Ch. 17.4 - Quarterly revenue ( millions) for Twitter for the...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 - The data contained in the DATAfile named CrudeCost...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 - 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
- Companies are devoting time and energy to promote recycling. A major recycling company found some old documents that present the recorded amount of cell phone collected over a span of eight years. Year Cellular Telephones Collected (in millions) 2009 2.2 2010 2.6 2011 2.9 2012 3.4 2013 3.1 2014 4.2 2015 4.9 2016 5.3 Part a) Develop a time series plot with Year on the X axis and Cellular Telephones Collected on the Y axis. Part b) Does there appear to be a relationship between time and cellular telephones collected?arrow_forwardThe folloiwing table shows data for U.S. movie theater admissions (per week). Display the data as a time-series graph and write a short paragraph explaining any noticeable trends or patterns. Year Admissions Year Admissions 1945 79.0 1985 20.30 1955 39.9 1995 23.3 1965 19.8 2005 26.5 1975 19.9 2015 25.4arrow_forwardUse quantitativeforecast methods for the data shown below Period Observation 1 24 2 34 3 36 4 37 5 41 6 44 7 45 Plot the original time series and comment on appropriateness of a linear trend.arrow_forward
- Consider 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_forwardThe elevation of a lake surface (feet above sea level) varies according to the annual flow of a river that feeds it. A geological survey provided the following data from equally spaced intervals of time over a 15 year period. Time Period Elevation 1 4817 2 4819 3 4824 4 4822 5 4826 6 4831 7 4836 8 4837 9 4839 10 4837 11 4832 12 4827 13 4823 14 4818 15 4817 Make a time-series graph displaying the data.arrow_forwardthe table shows the percent of households with internet access for selected years from 2009 and projected through 2015. Year Percent of households 2009 67 2010 70 2011 72.5 2012 75 2013 76.5 2014 77.2 2015 78 Use the model to predict the percent of households with internet access in 2022.arrow_forward
- Consider 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. b) Develop a five month moving average forecast. Compute MSE and a forecast for month 13. 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_forwardThe following data set provides the total number of shipments of core major household appliances in the U.S. from 2000 to 2016 (in millions): Year Shipments (millions) 2000 38.4 2001 38.2 2002 40.8 2003 42.5 2004 46.1 2005 47.0 2006 46.7 2007 44.1 2008 39.8 2009 36.5 2010 38.2 2011 36.0 2012 35.8 2013 39.2 2014 41.5 2015 42.9 2016 44.7 a. Plot the time series. b. Fit a three-year moving average to the data and plot the results. c. Fit a five-year moving average to the data and plot the results. d. Compute a linear trend forecasting equation and plot the trend line. e. Compute a quadratic trend forecasting equation and plot the results.arrow_forwardConsider the following time series data Month 1 2 3 4 5 6 7 8 9 10 11 12 Value 80 82 84 83 83 84 85 84 82 83 84 83 a) Construct a time series plot in Excel. Label the axes and graph. b) Develop a three month moving average forecast. Compute MSE and a forecast for month 13. c) Develop an exponential smoothing forecast with a = 0.35. Compute MSE and a forecast for month 13.arrow_forward
- Consider the following time series. Quarter Year 1 Year 2 Year 3 1 70 67 61 2 50 42 52 3 59 61 54 4 79 82 73 (a) Construct a time series plot. What type of pattern exists in the data? Is there an indication of a seasonal pattern? The time series plot shows a horizontal pattern, but there is also a seasonal pattern in the data.The time series plot shows a horizontal pattern with no seasonal pattern present. The time series plot shows a trend pattern, but there is also a seasonal pattern in the data.The time series plot shows a trend pattern with no seasonal pattern present. (b) Use a multiple linear regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. x1 = 1 if quarter 1, 0 otherwise; x2 = 1 if quarter 2, 0 otherwise; x3 = 1 if quarter 3, 0 otherwise. ŷ = (c) Compute the quarterly forecasts for the next year. quarter 1 forecast quarter 2 forecast quarter 3 forecast quarter 4 forecastarrow_forwardThe Seneca Children’s Fund (SCC) is a local charity that runs a summer camp for disadvantagedchildren. The fund’s board of directors has been working very hard over recentyears to decrease the amount of overhead expenses, a major factor in how charities arerated by independent agencies. The following data show the percentage of the money SCChas raised that was spent on administrative and fund-raising expenses over the last sevenyears. a. Construct a time series plot. What type of pattern exists in the data?b. Use simple linear regression analysis to find the parameters for the line that minimizesMSE for this time series.c. Forecast the percentage of administrative expenses for year 8.d. If SCC can maintain its current trend in reducing administrative expenses, how longwill it take SCC to achieve a level of 5 percent or less?arrow_forwardThe table below contains the average price paid for a new home in a certain area from 2000 to 2010. a. Construct a time-series plot of new home prices. b. What pattern, if any, is present in the data? Year Average_Price_($_thousands)2000 351.12001 330.52002 310.52003 296.72004 229.72005 182.32006 154.52007 156.32008 154.72009 154.52010 154.5arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
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