Statistics for Business and Economics (13th Edition)
13th Edition
ISBN: 9780134506593
Author: James T. McClave, P. George Benson, Terry Sincich
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Videos
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 solution
Students have asked these similar questions
The November 24, 2001, issue of The Economist published economic data for 15
industrialized nations. Included were the percent changes in gross domestic product (GDP),
industrial production (IP), consumer prices (CP), and producer prices (PP) from Fall 2000
to Fall 2001, and the unemployment rate in Fall 2001 (UNEMP). An economist wants to
construct a model to predict GDP from the other variables. A fit of the model
GDP = , + P,IP + 0,UNEMP + f,CP + P,PP + €
yields the following output:
The regression equation is
GDP = 1.19 + 0.17 IP + 0.18 UNEMP + 0.18 CP – 0.18 PP
Predictor
Coef SE Coef
тР
Constant
1.18957 0.42180 2.82 0.018
IP
0.17326 0.041962 4.13 0.002
UNEMP
0.17918 0.045895 3.90 0.003
CP
0.17591 0.11365 1.55 0.153
PP
-0.18393 0.068808 -2.67 0.023
Predict the percent change in GDP for a country with IP = 0.5, UNEMP = 5.7, CP =
3.0, and PP = 4.1.
a.
b.
If two countries differ in unemployment rate by 1%, by how much would you predict
their percent changes in GDP to differ, other…
Using excel. For the Hawkins Company, the monthly percentages of all shipments received on time
over the past 12 months are 80, 82, 84, 83, 83, 84, 85, 84, 82, 83, 84, and 83.
a. Compare the three-month moving average approach with the exponential smoothing
approach for α=\alpha =α= .2. Which provides more accurate forecasts using MSE as the
measure of forecast accuracy?
b. What is the forecast for next month? Please show work
Top of Form
a)Plot the monthly sales data.
b)Forecast January sales using each of the following:
i)Naive method.
ii)A 3-month moving average.
iii)A 6-month weighted average using .1, .1, .1, .2, .2, and .3, with the heaviest weights applied to the most recent months.
iv)Exponential smoothing using an α = .3 and a September forecast of 18.
Chapter 14 Solutions
Statistics for Business and Economics (13th Edition)
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
- What does the y -intercept on the graph of a logistic equation correspond to for a population modeled by that equation?arrow_forwardOlympic 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_forwardFind the equation of the regression line for the following data set. x 1 2 3 y 0 3 4arrow_forward
- No need to answer everything! Just plot the actual visitors and the forecasts. Compare the accuracy of the forecasts in the 1985 to 1990 period with those subsequent to that period.arrow_forwarda)Given the data 63, 64, 66, 67, 67, 69, 71, 72 are the units of actual sales of TV in the last eight periods. Find the forecast for the ninth period using simple exponential smoothing.Use α = 0.3 and initial forecast using simple average of last eight months. b)The sales of a company (in million dollars) for each year are shown in the table below. Find the linear sales trend line.x (year) 2005 2006 2007 2008 2009y (sales) 12 19 29 37 45 plz i need these answers within 4 hrs i need to submit them do the questions manually without using excel or minitabarrow_forwardq7-arrow_forward
- State at least one type of conclusion that could be made from the data provided for the KPI. Suggest one other data source that would provide more information to make data-driven decisions. Explain what information that source would supply. (The blue one is mine) or pretty much what can be said of the clustered bar chartarrow_forwardshow the solution if necessaryarrow_forwardFind the pvalue for the intercept and state the correct representation of the related logistic regression model?arrow_forward
- Use the advertised prices for used cars of a particular model in the accompanying table to create a linear model for the relationship between a car's Age and its Price. Complete parts a through g. E Click the icon to view the data table. ...... e) You have a chance to buy one of two cars. They are about the same age and appear to be in equally good condition. Would you rather buy the one with a positive residual or the one with a negative residual? Explain. O A. The car with a positive residual is better because its actual price is above the predicted price for its age. Data table O B. The car with a positive residual is better because its actual price is below the predicted price for its age. OC. The car with a negative residual is better because its actual price is above the predicted price for its age. Age (yr) Price Advertised ($) OD. The car with a negative residual is better because its actual price is below the predicted price for its age. 1 17,619 14,999 16,018 13,988 15,009…arrow_forwardThe following is a spreadsheet for forecasting annual revenues for the Gorsuch Corp. (check picture sent) a. Complete the following sentence: "The linear model is (or is not) a valid model of the trend of the data because ..." b. Identify any errors in the model's specification. c. An incorrect entry has been made in one cell and then copied down. You should be able to spot the cell without making any calculations. Identify the cell and indicate the correct entry for it.arrow_forwardScenario: You conduct research to assess the extent to which regulatory reports are late (in days). As potential contributors to late reports you want to simultaneously investigate company site (MN, CA, NY, TX), reporting agency (Agencies 1, 2, and 3), and report format (Long form, Short form) . What research analysis would be most appropriate? Group of answer choices a. ANOVA b. Binary Logistic Regression c. Chi-square Contingency Table d. Non-parametric e. Regressionarrow_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
Linear Algebra: A Modern IntroductionAlgebraISBN:9781285463247Author:David PoolePublisher:Cengage Learning
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
Big Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
College Algebra
Algebra
ISBN:9781305115545
Author:James Stewart, Lothar Redlin, Saleem Watson
Publisher:Cengage Learning
Linear Algebra: A Modern Introduction
Algebra
ISBN:9781285463247
Author:David Poole
Publisher:Cengage Learning
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
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