STATISTICS F/BUS.+ECON.-18WK. MYSTATLAB
13th Edition
ISBN: 9780135901526
Author: MCCLAVE
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 14.5, Problem 14.24LM
Refer to Exercise 14.4 (p. 14-9). The table with the prices for product A for the four quarters of last year is reproduced at right. Holt’s smoothing method with w = .2 and v = .6 was applied to the data.
a Find the missing trend value for Quarter 3.
b. Find the missing smoothed value for Quarter 4.
c. Give the Holt’s forecast for the price in Quarter 5.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Compute the forecasted values for Yt for July and August in 2020 by using the modelsstated in (c) and (d)
The following time series shows the sales of supermarket chain over the last six months.
Month
Sales ($ 000)
August 2021
250
Sep 2021
280
Oct 2021
295
Nov 2021
320
Dec 2021
380
Jan 2022
360
Develop a linear trend equation that can be used to forecast sales in Feb 2022.
Forecast the sales in Feb 2021 using a three-period weighted moving average designed with the following weights: Nov 2021 weight 0.6, Dec 2021 weight 0.3 and Jan 2022 weight 0.1. Which method (A or B) is the best? Explain why.
4) the accompanying dataset provides data on monthly unemployment rates for a certain region over four years. Compare 3- and 12- month moving average forecast using the MAD criterion. Which of the two models yields better results? (See picture)
Find the MAD for the 3 month moving average forcast.
MAD = _____
Chapter 14 Solutions
STATISTICS F/BUS.+ECON.-18WK. MYSTATLAB
Ch. 14.1 - Explain in words how to construct a simple index.Ch. 14.1 - Explain in words how to calculate the following...Ch. 14.1 - Explain in words the difference between Laspeyres...Ch. 14.1 - The table below gives the prices for three...Ch. 14.1 - Refer to Exercise 14.4. The next table gives the...Ch. 14.1 - Annual median family income. The table below lists...Ch. 14.1 - Annual U.S. craft beer production. While overall...Ch. 14.1 - Quarterly single-family housing starts. The...Ch. 14.1 - Spot price of natural gas. The table shown in the...Ch. 14.1 - Employment in farm and nonfarm categories....
Ch. 14.1 - GOP personal consumption expenditures. The gross...Ch. 14.1 - GDP personal consumption expenditures (contd)....Ch. 14.1 - Weekly earnings for workers. The table in the next...Ch. 14.1 - Production and price of metals. The level or price...Ch. 14.2 - Describe the effect of selecting an exponential...Ch. 14.2 - A monthly time series is shown in the table to the...Ch. 14.2 - Annual U.S. craft beer production. Refer to the...Ch. 14.2 - Foreign fish production. Overfishing and pollution...Ch. 14.2 - Yearly price of gold. The price of gold is used by...Ch. 14.2 - Personal consumption in transportation. There has...Ch. 14.2 - OPEC crude oil imports. The data in the table...Ch. 14.2 - SP 500 Stock Index. Standard Poors 500 Composite...Ch. 14.5 - How does the choice of the smoothing constant w...Ch. 14.5 - Refer to Exercise 14.4 (p. 14-9). The table with...Ch. 14.5 - Annual U.S. craft beer production. Refer to...Ch. 14.5 - Quarterly single-family housing starts. Refer to...Ch. 14.5 - Consumer Price Index. The CPI measures the...Ch. 14.5 - OPEC crude oil imports. Refer to the annual OPEC...Ch. 14.5 - SP 500 Stock Index. Refer to the quarterly...Ch. 14.5 - SP 500 Stock Index (contd). Refer to Exercise...Ch. 14.5 - Monthly gold prices. The fluctuation of gold...Ch. 14.6 - Annual U.S. craft beer production. Refer to the...Ch. 14.6 - Annual U.S. craft beer production (contd). Refer...Ch. 14.6 - SP 500 Stock Index. Refer to your exponential...Ch. 14.6 - SP 500 Stock Index (contd). Refer to your Holt...Ch. 14.6 - Monthly gold prices. Refer to the monthly gold...Ch. 14.6 - US school enrollments. The next table reports...Ch. 14.8 - The annual price of a finished product (in cents...Ch. 14.8 - Retail sales in Quarters 14 over a 10-year period...Ch. 14.8 - What advantage do regression forecasts have over...Ch. 14.8 - Mortgage interest rates. The level at which...Ch. 14.8 - Price of natural gas. Refer to Exercise 14.9 (p....Ch. 14.8 - A gasoline tax on carbon emissions. In an effort...Ch. 14.8 - Predicting presidential elections. Researchers at...Ch. 14.8 - Life insurance policies in force. The table below...Ch. 14.8 - Graphing calculator sales. The next table presents...Ch. 14.8 - Prob. 14.47ACICh. 14.9 - Define autocorrelation. Explain why it is...Ch. 14.9 - For each case, indicate the decision regarding the...Ch. 14.9 - What do the following Durbin-Watson statistics...Ch. 14.9 - Company donations to charity. Refer to the Journal...Ch. 14.9 - Forecasting monthly car and truck sales. Forecasts...Ch. 14.9 - Predicting presidential elections. Refer to the...Ch. 14.9 - Mortgage interest rates. Refer to the data on...Ch. 14.9 - Price of natural gas. Refer to the annual data on...Ch. 14.9 - Life insurance policies in force. Refer to the...Ch. 14.9 - Modeling the deposit share of a retail bank....Ch. 14 - Insured Social Security workers. Workers insured...Ch. 14 - Insured Social Security workers (contd). Refer to...Ch. 14 - Retail prices of food items. In 1990, the average...Ch. 14 - Demand for emergency room services. With the...Ch. 14 - Mortgage interest rates. Refer to the annual...Ch. 14 - Price of Abbott Labs stock. The yearly closing...Ch. 14 - Price o f Abbott Labs stock (contd). Refer to...Ch. 14 - Prob. 14.65ACICh. 14 - Prob. 14.66ACICh. 14 - Quarterly GOP values (contd). Refer to Exercise...Ch. 14 - Prob. 14.68ACICh. 14 - Prob. 14.69ACICh. 14 - Prob. 14.70ACICh. 14 - IBM stock prices. Refer to Example 14.1 (p. 14-5)...Ch. 14 - Prob. 14.72ACI
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
- Olympic Pole Vault The graph in Figure 7 indicates that in recent years the winning Olympic men’s pole vault height has fallen below the value predicted by the regression line in Example 2. This might have occurred because when the pole vault was a new event there was much room for improvement in vaulters’ performances, whereas now even the best training can produce only incremental advances. Let’s see whether concentrating on more recent results gives a better predictor of future records. (a) Use the data in Table 2 (page 176) to complete the table of winning pole vault heights shown in the margin. (Note that we are using x=0 to correspond to the year 1972, where this restricted data set begins.) (b) Find the regression line for the data in part ‚(a). (c) Plot the data and the regression line on the same axes. Does the regression line seem to provide a good model for the data? (d) What does the regression line predict as the winning pole vault height for the 2012 Olympics? Compare this predicted value to the actual 2012 winning height of 5.97 m, as described on page 177. Has this new regression line provided a better prediction than the line in Example 2?arrow_forwardAll of the following models would be appropriate for data comprised of randomness and trend except: a. Holt’s exponential smoothing b. Holt-winter’s exponential smoothing c. Average change model d. Linear trend regression (time series decomposition) e. All of the above would be appropriatearrow_forwardIf a sample of 25 pairs of data yields a correlation coefficient, r, of 0.390 and the scatterplot displays a linear trend, can you use the regression equation to make predictions, assuming your x-values are within the domain of the data set? Choose your answer from the multiple choice answers below A.) Yes, because rcrit = 0.396 and the regression coefficient, r, is less than this value. B.) Yes, because rcrit = 0.381 and the regression coefficient, r, is greater than this value. C.) No, because rcrit = 0.381 and the regression coefficient, r, is greater than this value. D.) No, because rcrit = 0.396 and the regression coefficient, r, is less than this value.arrow_forward
- Suppose a study wants to predict the market price of a certain species of turtle (Y) based on the following independent variables indicated in the table. Based from the table, what is the equation of the multiple linear regression? (Round off up to two decimal places. Market Price = 0.07 - 0.40*weight + 1.51*length + 1.41*width + 0.80*age Market Price = - 0.40*weight + 1.51*length + 1.41*width + 0.80*age Market Price = 0.07 + 0.40*weight + 1.51*length + 1.41*width + 0.80*age Market Price = 0.07 - 0.40 + weight + 1.51 + length + 1.41 + width + 0.80 + agearrow_forwardA pharmacist has been monitoring sales of a certain over-the-counter pain reliever. Daily sales duringthe last 15 days wereDay: 1 2 3 4 5 6 7 8 9Number sold: 36 38 42 44 48 49 50 49 52Day: 10 11 12 13 14 15Number sold: 48 52 55 54 56 57a. Which method would you suggest using to predict future sales—a linear trend equation or trendadjustedexponential smoothing? Why?b. If you learn that on some days the store ran out of the specific pain reliever, would that knowledgecause you any concern? Explain.c. Assume that the data refer to demand rather than sales. Using trend-adjusted smoothing with aninitial forecast of 50 for week 8, an initial trend estimate of 2, and .3, develop forecastsfor days 9 through 16. What is the MSE for the eight forecasts for which there are actual data?arrow_forwardConsider the following linear trend models estimated from 10 years of quarterly data with and without seasonal dummy variables d1, d2, and d3. Here, d1 = 1 for quarter 1, 0 otherwise; other dummy variables are defined similarly. Model 1: ŷ = 48.00 + 0.44t Model 2: ŷ = 48.00 + 0.46t − 0.38d1 − 0.42d2 − 0.12d3 Use each model to make a forecast for y for the first and the fourth quarters of the 11th year. Note: Round your answers to 2 decimal places. Which is the preferred model for forecasting if, relative to Model 1, Model 2 has higher R2 but lower adjusted R2?arrow_forward
- Based on the following data - (a) units produced from September to December are as follows: 18,900, 17,500, 21,200, 23,400; (b) total cost are as follows: P1,240,800, P1,198,000, P1,374,200, P1,563,800. What is the cost function using least-squares regression analysis?arrow_forwardA pharmacist has been monitoring sales of a certain over-the-counter pain reliever. Daily sales during the last 15 days were Day: 1 2 3 4 5 6 7 8 9 Number sold: 34 37 40 39 45 43 47 49 48 Day: 10 11 12 13 14 15 Number sold: 52 53 47 53 47 49 a. Assume the data refer to demand rather than sales. Using trend-adjusted exponential smoothing with an initial forecast of 42 for Day 8, an initial trend estimate of 2, and α = β = .3, develop demand forecasts for Days 9 through 16. Then compute the resultant MSE using the error values from Days 8 through 15. (Round your intermediate period-by-period forecast and error values to 3 decimal places. Round your final MSE answer to 3 decimal places.) MSEarrow_forwardThe customer demand for a particular smart phone during Year 0 to Year 5 is given as 1,056,000, 1,032,000, 1,093,000, 1,024,000, 1,066,000, and 1,072,000. Using the Holt forecasting model with trend, what is the forecasted demand in year 10, where w = 0.4 and v = 0.5?a) 1,071,874b) 1,075,573c) 1,077,488d) 1,083,816arrow_forward
- "Fit the sales data using the Holt-Winters Additive Seasonal model, and opti-mize the smoothing constants with the Solver.b.Use the Forecast Sheet button to create a forecast worksheet.c. Which model performs better based on the MSE" Oct-11 16,402 Jan-12 21,288 Apr-12 16,867 Jul-12 16,779 Oct-12 16,929 Jan-13 22,726 Apr-13 16,706 Jul-13 17,117 Oct-13 17,258 Jan-14 21,515 Apr-14 17,050 Jul-14 17,406 Oct-14 17,732 Jan-15 21,751 Apr-15 17,119 Jul-15 17,427 Oct-15 17,613 Jan-16 21,626 Apr-16 16,196 Jul-16 16,169 Oct-16 16,441 Jan-17 20,690 Apr-17 16,017 Jul-17 16,429 Oct-17 16,667 Jan-18 22,766 Apr-18 16,781 Jul-18 17,776 Oct-18 17,821 Jan-19 22,977 Apr-19 17,627arrow_forwardBelow you are given the first five values of a quarterly time series. The multiplicative model is appropriate and a four-quarter moving average will be used. Year Quarter Time Series Value Yt 1 1 36 2 24 3 16 2 4 20 1 44 An estimate of the combined trend-cycle component (T2Ct) for Quarter 3 of Year 1 (used for estimating the de-trended values), when a four-quarter moving average is used, is a. 24. b. 26. c. 28. d. 25.arrow_forwardCalculate Karl Pearson's coeffcient of skewness from the following data:Weekly Sales (Ksh) 10-12 12-14 14-16 16-18 18-20 20-22 22-24 24-26Number of Companies 12 18 35 42 50 30 8 4arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- College AlgebraAlgebraISBN:9781305115545Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage Learning
College Algebra
Algebra
ISBN:9781305115545
Author:James Stewart, Lothar Redlin, Saleem Watson
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