Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
6th Edition
ISBN: 9781337115186
Author: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Videos
Question
Chapter 17.4, Problem 19E
a.
To determine
Construct the time series plot.
Explain the type of pattern.
b.
To determine
Calculate linear trend equation for data.
c.
To determine
Calculate the forecast value for 8.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook 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.
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.
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%
Chapter 17 Solutions
Modern Business Statistics with Microsoft Office Excel (with XLSTAT Education Edition Printed Access Card) (MindTap Course List)
Ch. 17.2 - 1. Consider the following time series...Ch. 17.2 - 2. Refer to the time series data in exercise 1....Ch. 17.2 - Prob. 3ECh. 17.2 - 4. Consider the following time series...Ch. 17.3 - Consider the following time series...Ch. 17.3 - Consider the following time series...Ch. 17.3 - Refer to the gasoline sales time series data in...Ch. 17.3 - Prob. 8ECh. 17.3 - 9. With the gasoline time series data from Table...Ch. 17.3 - 10. 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 - Prob. 16ECh. 17.4 - Consider the following time series...Ch. 17.4 - Prob. 18ECh. 17.4 - Prob. 19ECh. 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 - The following data shows the average interest rate...Ch. 17.4 - Quarterly revenue ($ millions) for Twitter for the...Ch. 17.4 - Giovanni Food Products produces and sells frozen...Ch. 17.4 - The number of users of Facebook from 2004 through...Ch. 17.5 - Consider the following time series.
Construct a...Ch. 17.5 - Consider the following time series...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 - Prob. 34ECh. 17.6 - Consider the following time series...Ch. 17.6 - Refer to exercise 35.
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 - 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 - Prob. 50SECh. 17 - Refer to the Costello Music Company time series in...Ch. 17 - Prob. 52SECh. 17 - Refer to the Hudson Marine problem in exercise 52....Ch. 17 - Refer to the Hudson Marine problem in exercise...Ch. 17 - Refer to the Hudson Marine data in exercise...Ch. 17 - Forecasting Food and Beverage Sales
The Vintage...Ch. 17 - The Carlson Department Store suffered heavy damage...
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
- Use this data for the exercises that follow: In 2013, there were roughly 317 million citizens in the United States, and about 40 million were elderly (aged 65 and over).[34] 60. It is predicted that by 2030, one in five U.S. citizens will be elderly. How much greater will the chances of meeting an elderly person be at that time? What policy changes do you foresee if these statistics hold true?arrow_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. 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_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. 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_forwardhudson Marine has been an authorized dealer for c&d marine radios for the past sevenyears. the following table reports the number of radios sold each year.Year 1 2 3 4 5 6 7Number Sold 35 50 75 90 105 110 130a. construct a time series plot. does a linear trend appear to be present?b. Using Minitab or excel, develop a linear trend equation for this time series.c. Use the linear trend equation developed in part (b) to develop a forecast for annualsales in year 8.arrow_forward
- Consider 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_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_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_forward
- Consider 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_forwardDon't hand writing solution.arrow_forwardConsider the following time series data: Quarter 1 2 3 4 Year1 6 Cyclical pattern 2 3 5 O Trend pattern without seasonality Year2 O Horizontal pattern O Trend with seasonal pattern 6 3 Construct a time series plot, what type of pattern exists in the data? 5 7 Year3 7 6 6 8arrow_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
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