STATISTICS F/BUSINESS+ECONOMICS-TEXT
13th Edition
ISBN: 9781305881884
Author: Anderson
Publisher: CENGAGE L
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 17.4, Problem 17E
Consider the following time series data.
- a. Construct a time series plot. What type of pattern exists in the data?
- b. Develop the linear trend equation for this time series.
- c. What is the forecast for t = 6?
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
the costello Music company has been in business for five years. during that time, salesof pianos increased from 12 units in the first year to 76 units in the most recent year. Fredcostello, the firm’s owner, wants to develop a forecast of piano sales for the coming year.the historical data follow.Year 1 2 3 4 5Sales 12 28 34 50 76a. construct a time series plot. What type of pattern exists in the data?b. develop the linear trend equation for the time series. What is the average increase insales that the firm has been realizing per year?c. Forecast sales for years 6 and 7.
No Religious Affiliation Trends. The following table gives the percentage of first-year college students who answered “None” when asked about their religious affiliation in selected years. Display the data as a time-series graph and write a short paragraph explaining any noticeable trends or patterns.
Year
Percentage claiming no religious affiliation
1985
9.4%
1990
12.3%
1995
14.0%
2000
14.9%
2005
17.4%
2010
23.0%
2015
29.5%
Consider the following time series data.Quarter Year 1 Year 2 Year 31 4 6 72 2 3 63 3 5 64 5 7 8a. Construct a time series plot. What type of pattern exists in the data?b. Show the four-quarter and centered moving average values for this time series.c. Compute seasonal indexes and adjusted seasonal indexes for the four quarters.
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
- Consider the following time series data. Choose the correct time series plot. (i) (ii) (iii) (iv) Plot (ii) What type of pattern exists in the data?Horizontal Pattern Develop a three-week moving average for this time series. Compute MSE and a forecast for week 7. If required, round your answers to two decimal places. Week Time SeriesValue Forecast 1 18 2 13 3 16 4 11 fill in the blank 3 5 17 fill in the blank 4 6 14 fill in the blank 5 MSE: fill in the blank 6The forecast for week 7: fill in the blank 7 Use α = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for week 7. If required, round your answers to two decimal places. Week Time SeriesValue Forecast 1 18 2 13 fill in the blank 8 3 16 fill in the blank 9 4 11 fill in the blank 10 5 17 fill in the blank 11 6 14 fill in the blank 12 MSE: fill in the blank 13The forecast for week 7: fill in the blank 14arrow_forwardConsider the following time series data. Quarter Year 1 1 De- 2 3 4 3 1 4 6 Year 2 quarter 3 forecast quarter 4 forecast 5 2 6 8 Year 3 6 5 7 (a) Construct a time series plot. What type of pattern exists in the data? O The time series plot shows a horizontal pattern and no seasonal pattern in the data. The time series plot shows a linear trend and no seasonal pattern in the data. O The time series plot shows a linear trend and a seasonal pattern in the data. O The time series plot shows a horizontal pattern, but there is also a seasonal pattern in the data. 9 (b) Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. (Round your numerical values to three decimal places.) x₁ = 1 If quarter 1, 0 otherwise; x₂ = 1 If quarter 2, 0 otherwise; x₂ = 1 If quarter 3, 0 otherwise (c) Compute the quarterly forecasts for the next year based on the model you developed in part (b). (Round your answers to two decimal…arrow_forwardConsider the following time series data. Week 1 2 3 4 5 6 Value 18 13 16 11 17 14 Construct a time series plot. What type of pattern exist in the data? Develop a three-week moving average for this time series. Compute MSE and forecast for week 7. Use a = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and forecast for week 7.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_forwardConsider the following time series data. Quarter Year 1 Year 2 Year 3 1 8. 2 5 3 4 6 7 8 9. (a) Construct a time series plot. What type of pattern exists in the data? O The time series plot shows a linear trend and no seasonal pattern in the data. O The time series plot shows a horizontal pattern, but there is also a seasonal pattern in the data. O The time series plot shows horizontal pattern and no seasonal pattern in the data. The time series plot shows linear trend and a seasonal pattern in the data. (b) Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. (Round your numerical values to three decimal places.) x, = 1 if quarter 1, 0 otherwise; x, = 1 if quarter 2, 0 otherwise; x, = 1 if quarter 3, 0 otherwise ŷ = (c) Compute the quarterly forecasts for the next year based on the model you developed in part (b). (Round your answers to two decimal places.) quarter 1 forecast quarter 2 forecast quarter 3…arrow_forwardConsider the following time series data. Quarter Year 1 1 ŷt 2 3 4 5 1 2 6 Year 2 7 2 + Year 3 8 5 5 (a) Construct a time series plot. What type of pattern exists in the data? O The time series plot shows a linear trend and no seasonal pattern in the data. O The time series plot shows a linear trend and a seasonal pattern in the data. O The time series plot shows a horizontal pattern, but there is also seasonal pattern in the data. O The time series plot shows a horizontal pattern and no seasonal pattern in the data. (b) Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. (Round your numerical values to three decimal places.) X₁ = 1 if quarter 1, 0 otherwise; x₂ = 1 if quarter 2, 0 otherwise; X3 = 1 if quarter 3, 0 otherwise (c) Compute the quarterly forecasts for the next year based on the model you developed in part (b). (Round your answers to two decimal places.) quarter 1 forecast quarter 2 forecast…arrow_forward
- Consider the time series data in the table below (a-c all count as one problem) a. Construct a time series plot. What type of pattern exists in the data?b. Develop a three-week moving average for this time series. Compute MSEand a forecast for week 8. c. Use α = 0.2 to compute the exponential smoothing value for the time series.Compute MSE and a forecast for week 8.arrow_forwardConsider the following time series data. Week 1 2 3 4 S 9 Value 18 11 14 10 16 13 (a) Construct a time series plot. What type of pattern exists in the data? ◇ The data appear to follow a cyclical pattern. O The data appear to follow a trend pattern. The data appear to follow a seasonal pattern. ◇ The data appear to follow a horizontal pattern. (b) Develop the three-week moving average for this time series. (Round your answers to two decimal places.) Week Time Series Value Forecast 1 18 2 11 3 14 4 10 5 16 6 13 Compute MSE. (Round your answer to two decimal places.) MSE= What is the forecast for week 7?arrow_forwardA time series plot of a period of time (in weeks) versus sales is shown below. Which of the following data patterns best describes the scenario shown? a. Time series with a linear trend pattern b. Time series with a seasonal pattern c. Time series with no pattern d. Time series with a horizontal patternarrow_forward
- Consider the following time series data. Month 2 3 4 5 6 7 Value 24 13 20 12 19 23 15 Construct a time series plot. What type of pattern exists in the data? Develop the three-week moving average forecasts for this time series. Compute MSE and a forecast for week 8. b. Use a = .2 to compute the exponential smoothing forecasts for the time series. Com- pute MSE and a forecast for week 8. Compare the three-week moving average approach with the exponential smoothing ap- proach using a = .2. Which appears to provide more accurate forecasts based on MSE? d. Use a smoothing constant of a = .4 to compute the exponential smoothing forecasts. Does a smoothing constant of .2 or .4 appear to provide more accurate forecasts based on MSE? Explain.arrow_forwardDon't hand writing solution.arrow_forwardconsider the following time series data.Month 1 2 3 4 5 6 7Value 24 13 20 12 19 23 15construct a time series plot. What type of pattern exists in the data?a. develop the three-week moving average forecasts for this time series. compute MSeand a forecast for week 8.b. Use a = .2 to compute the exponential smoothing forecasts for the time series. compute MSe and a forecast for week 8.c. compare the three-week moving average approach with the exponential smoothing approach using a = .2. Which appears to provide more accurate forecasts based on MSe?d. Use a smoothing constant of a = .4 to compute the exponential smoothing forecasts.does a smoothing constant of .2 or .4 appear to provide more accurate forecasts basedon MSe? explainarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillBig Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin HarcourtTrigonometry (MindTap Course List)TrigonometryISBN:9781305652224Author:Charles P. McKeague, Mark D. TurnerPublisher:Cengage Learning
- Trigonometry (MindTap Course List)TrigonometryISBN:9781337278461Author:Ron LarsonPublisher: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
Trigonometry (MindTap Course List)
Trigonometry
ISBN:9781337278461
Author:Ron Larson
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