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
Textbook Question
Chapter 17.6, Problem 36E
Refer to exercise 35.
- a. Deseasonalize the time series using the adjusted seasonal indexes computed in part (c) of exercise 35.
- b. Compute the linear trend regression equation for the deseasonalized data.
- c. Compute the deseasonalized quarterly trend forecast for Year 4.
- d. Use the seasonal indexes to adjust the deseasonalized trend forecasts computed in part (c).
35. Consider the following time series data.
- a. 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.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
A coffee shop owner wants to estimate demand for the next four quarters for hot chocolate.
Sales data consist of trend and seasonality. Quarter relatives are 1.06 for the first quarter, 1.03
for the second quarter, 0.61 for the third quarter, and 1.30 for the fourth quarter. Using the
appropriate values of quarter relatives and the equation Ft = 187 +9.2t for the trend
component, estimate demand for periods 9-12. (Round all calculations to two decimal points.
Demand Period 9
Demand Period 10
Demand Period 11.
Demand Period 12
Monthly sales have been found to follow a linear trend of y = 10 + 8x, where y is the number of items sold and x is the number of the month. Monthly deviations from the trend have been calculated and follow an additive model. In month 12, the seasonal variation is estimated to be -6.
What is the forecasted number of items to be sold in month 12?
The following table gives the average monthly exchange rate between the U.S. dollar and the euro for 2009. It shows that 1 euro was equivalent to 1.289 U.S. dollars in January 2009. Develop a trend line that could be used to predict the exchange rate for 2010. Use this model to predict the exchange rate for January 2010 and February 2010. MONTH ______________________ EXCHANGE RATE January ....................................... 1.289 February ...................................... 1.324 March ......................................... 1.321 April .......................................... 1.317 May ........................................... 1.280 June ........................................... 1.254 July ........................................... 1.230 August ....................................... 1.240 September ................................... 1.287 October ..................................... 1.298 November .................................. 1.283 December…
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
- Table 6 shows the year and the number ofpeople unemployed in a particular city for several years. Determine whether the trend appears linear. If so, and assuming the trend continues, in what year will the number of unemployed reach 5 people?arrow_forwardThe US. import of wine (in hectoliters) for several years is given in Table 5. Determine whether the trend appearslinear. Ifso, and assuming the trend continues, in what year will imports exceed 12,000 hectoliters?arrow_forwardEXERCISES The following table gives the life expectancy at birth of females born in the United States in various years from 1970 to 2010. Source: National Center for Health Statistics. Year of Birth Life Expectancy years 1970 74.7 1975 76.6 1980 77.4 1985 78.2 1990 78.8 1995 78.9 2000 79.3 2005 79.9 2010 81.0 Find the life expectancy predicted by your regression equation for each year in the table, and subtract it from the actual value in the second column. This gives you a table of residuals. Plot your residuals as points on a graph.arrow_forward
- What does the y -intercept on the graph of a logistic equation correspond to for a population modeled by that equation?arrow_forwardFind the equation of the regression line for the following data set. x 1 2 3 y 0 3 4arrow_forwardThe following table shows the past two years of quarterly sales information. Assume that there are both trend and seasonal factors and that the seasonal cycle is one year. QUARTER SALES 1 220 2 232 3 201 4 193 5 163 6 194 7 155 8 136 Use regression and seasonal indexes to forecast quarterly sales for the next year. Note: Do not round intermediate calculations. Round your answers to the nearest whole number.arrow_forward
- The table shows the sales revenue from the past 8 quarters. What is the 4-period moving average forecast of the next quarter? Year 1 Year 2 Year 3 Q1 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Q1 11 10 9 12 10 7 7 11 ?arrow_forwardA bank wanted to find out whether the number of loan applications received are influenced by the current loan interest rate. The manager selected 11 monthly periods for which different interest rates applied and recorded the number of loan applications received. (b) Show the data graphically in a scatter plot. What relationship is observed? SHOW SOLUTION PLEASE!arrow_forwardUsing the photo attached, One Stop Car Repairs ollects data on the actual demand for its services and uses this data to make forecasts. The actual number of transmissions that were repaired for the last ten periods IS ATTACHED IN THE PHOTO answer the following. 1. Using the trend projection manual method, forecast demand for transmission repairs for periods 11 and 12arrow_forward
- Consider the following data on salaries and experience. Persons 2,4,6,8,and 9 have MBA degrees. All others only have undergraduate degrees. Calculate the regression of Salary on Experience within a model that controls for whether a person has an MBA or not. Print the data set that allows you to do this regression. Sketch the graph the estimated regression that clearly indicates the impact of a MBA degree on Salary. What is the market value of the MBA degree? Person Salary Experience 1 $130,468 10 Years 2 62,250 1 3 50,000 2.3 4 140,000 9 5 110,000 8 6 80,050 2.8 7 95,772 7 8 110,000 6 9 87,752 4.2 10 79,290 5arrow_forwardAssume that the current date is February 1, 2021. The linear regression model was applied to a monthly time series data based on the last 24 months' sales. (From January 2019 through December 2020). The following partial computer output summarizes the results. Coefficient Estimate t Intercept 4.3 2.07 Slope 1.6 2.98 Determine the predicted sales for February.arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
Calculus For The Life SciencesCalculusISBN:9780321964038Author:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.Publisher:Pearson Addison Wesley,
Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw Hill
Algebra and Trigonometry (MindTap Course List)AlgebraISBN:9781305071742Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage Learning
Functions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage Learning
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Calculus For The Life Sciences
Calculus
ISBN:9780321964038
Author:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:Pearson Addison Wesley,
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
Algebra and Trigonometry (MindTap Course List)
Algebra
ISBN:9781305071742
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
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