MyLab Statistics for Business Stats with Pearson eText -- Standalone Access Card -- for Statistics for Business and Economics
13th Edition
ISBN: 9780134748610
Author: James T. McClave, P. George Benson, Terry Sincich
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 14.6, Problem 14.36ACI
Monthly gold prices. Refer to the monthly gold prices. Exercise 14.31 (p. 14-24). Two models were used to forecast the monthly 2015 gold prices: an exponential smoothing model with w = .5 and a Holt model with w = .5 and v = .5.
a Use MAD, MAPE, and RMSE criteria to evaluate the two models’ accuracy for forecasting the monthly 2015 values using the 2009-2014 data.
b. Use the MAD, MAPE, and RMSE criteria to evaluate the two models’ accuracy when making the 12 one-step-ahead forecasts, updating the models with each month’s actual value before forecasting the next month’s value.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
All 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 appropriate
Compute the forecasted values for Yt for July and August in 2020 by using the modelsstated in (c) and (d)
"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,627
Chapter 14 Solutions
MyLab Statistics for Business Stats with Pearson eText -- Standalone Access Card -- for Statistics for Business and Economics
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_forwardThe values of Alabama building contracts (in $ millions) for a 12 -month period follow. 240 350 240 260 280 320 220 310 240 310 240 240 A. Compare the three-month moving average approach with the exponential smoothing forecast using a=0.2 (to 2 decimals). MSE (3-Month) _______ MSE ( a=0.2) __________ Using only the errors for months 4 to 12, the MSE for exponential smoothing is: MSE ( a=0.2) __________ C. Using the approach that provides more accurate forecasts based on MSE, what is the forecast for the next month (to the nearest whole number)? $ _______millionarrow_forwardAltman Z Score 2018 2019 2020 BHP 0.80 0.71 0.63 FMG 1.12 1.26 1.38 RIO 1.36 1.34 1.34 Comment on the findings of each company and is it useful in predicting financial failurearrow_forward
- Solve for the BIAS, MAD, MAPE and MSE of the following data: Period Actual Sales 1 21 2 25 3 28 4 31 5 35 6 25 7 29 8 30 9 24 10 26 11 27 12 24 13 27 Solve for d) exponential smoothing alpha of 0.2 and the first forecast is the same with the actual salesarrow_forwardThe accompanying data file contains 40 observations on the response variable y along with the predictor variables x1 and x2. Use the holdout method to compare the predictability of the linear model with the exponential model using the first 30 observations for training and the remaining 10 observations for validation. y x1 x2 533.86 20 30 104.84 15 20 64.89 20 23 159.61 16 21 43.06 13 16 4.27 13 13 736.56 15 30 64.89 20 23 10.64 20 22 76.90 18 20 4.89 11 13 80.90 11 16 224.17 12 19 45.75 16 25 8.13 17 17 319.97 13 30 48.61 19 25 564.67 12 27 111.87 11 25 152.39 13 24 13.34 18 14 28.80 15 22 37.56 13 15 105.62 17 26 44.05 18 21 451.65 17 28 10.34 18 21 32.70 12 13 19.21 14 12 14.02 15 16 2.45 16 12 2.48 20 15 50.34 17 21 29.31 17 20 33.75 16 12 196.28 17 29 943.12 13 30 7.25 10 12 89.73 15 25 32.91 12 18 1. Use the training set to estimate Models 1 and 2. Note: Negative values should be indicated by a…arrow_forwardConsider the following time series data. Month 1 2 3 4 5 6 7 8 9value 23 12 20 22 15 23 24 17 22 a. Develop the three-week moving average forecasts for this time series. Compute MSE and a forecast for week 10.b. Use α = .2 to compute the exponential smoothing forecasts for the time series. Compute MSE and a forecast for week 10.c. Compare the three-week moving average approach with the exponential smoothing approach using α = .2. Which appears to provide more accurate forecasts based on MSE?arrow_forward
- 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 = _____arrow_forwardWhich of the following time-series forecasting methods would not be used to forecast a time series that exhibits a linear trend with no seasonal or cyclical patterns? a. Dummy variable regression b. Linear trend regression c. Multiplicative Winter's method d. Holt Winter's double exponential smoothing e. Both A and Darrow_forwarda) If the prevalence rate is 50%, the sensitivity is 85%, and the specificity is 90%, what will the PPV value be? b) What are possible slider values that will produce a PPV value of 1? c) What are possible slider valuse that will produce an NPV value of 1? d) If sensitivity and specificity remain constant while prevalence decreases, what effect does that have on the PPV? e) If prevalence and specificity remain constant while sensitivity increases, what effect does that have on the NPV?arrow_forward
- The sales records of a major auto manufacturer over the past years from 2005 to 2019 are shown below. Number of Cars Sold Year (In thousands of Units) 2005 195 2006 200 2007 250 2008 270 2009 320 2010 380 2011 440 2012 460 2013 500 2014 500 2015 550 2016 570 2017 600 2018 650 2019 700 Develop moving average with k=4 and compute its MSE Develop exponential model with α = 0.4 and compute its MSE Develop a linear trend model and compute its MSE Based on the MSE computed fore ach model , which model fits well to the data Based on the answer of question (4) forecast the number of cars sold for year 2020.arrow_forwardPink Table, a snack shop has recorded sales for its best-selling cold drink, shown as follows: Day 1 2 3 4 5 6 7 8 9 10 Jasmine Slush (12 oz) 125 136 127 123 142 148 139 140 154 158 a. Predict the sales for Jasmine Slush using the following forecasting methods: naïve (use simple naive method, forecast this period=actual value of last period); 3-day moving average method; weighted average method using the following weights: 45%,30%,25%; exponential smoothing with smoothing constant alpha equal to 10%, assume forecast for day 1 for each of the 3 products is the sales for day1; linear trend line. b. Using the results in a), compute the error ( MSE, MAD, and MAPE) for each of the methods used. c. Which forecasting technique will you recommend fo predict the sales of Jasmine Slush Explain and support your answer quantitatively.arrow_forwardExercise 1.14 (Static) THE BANK CUSTOMER WAITING TIME CASE A bank manager has developed a new system to reduce the time customers spend waiting to be served by tellers during peak business hours. Typical waiting times during peak business hours under the current system are roughly 9 to 10 minutes. The bank manager hopes that the new system will lower typical waiting times to less than 6 minutes and wishes to evaluate the new system. When the new system is operating consistently over time, the bank manager decides to select a sample of 100 customers that need teller service during peak business hours. Specifically, for each of 100 peak business hours, the first customer that starts waiting for teller service at or after a randomly selected time during the hour will be chosen. Consider the peak business hours from 2:00 p.m. to 2:59 p.m., from 3:00 p.m. to 3:59 p.m., from 4:00 p.m. to 4:59 p.m., and from 5:00 p.m. to 5:59 p.m. on a particular day. Also, assume that a computer software…arrow_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