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.5, Problem 14.31ACI
Monthly gold prices. The fluctuation of gold prices is a reflection of the strength or weakness of the U.S. dollar. The table below shows monthly gold prices from January 2009 to December 2015.
a. Use exponential smoothing with w = .5 to calculate monthly smoothed values from 2009 to 2014. Then forecast the monthly gold prices for 2015.
b. Calculate 12 one-step-ahead forecasts for 2015 by updating the exponentially smoothed values with each month’s actual value and then forecasting the next month’s value.
c. Repeat parts a-b using Holt’s method with w = .5 and v = .5. Jan: 1,742.9; Dec.: 1,780.3
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Using the trend adjusted
projected method and
given the following
S15-0.991 T15x
115=5.33+(0.01387)t
The forecast demand for
period 15?
You are using exponential smoothing to forecast demand. For September, suppose you
forecasted 165 units and actually sold 178 units. If you use an alpha value of 0.2. what will be
the exponential smoothing forecast for October?
4. Suppose we have a summary of forecasting techniques calculation results for Gundam Auto Sales
Inc. (in the prior item) as follows:
Mean
Next
Standard
Period
Error
Forecasting Method Used
Forecast
(MSE)
1.3-period UnWMA
10.42
3.24
2.4-period UnWMA
10.38
3.51
3.3-period WMA
10.83
3.03
4. Simple Exponential Smoothing
5. Trend Projection
8.24
5.04
11.43
1.16
a. Which among the techniques is the most reliable?
b. What does the result of the most reliable technique say?
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
- Name two coincident indicators used in forecastingarrow_forwardA manager uses a trend equation plus quarterly relatives to predict demand. Quarter relatives are SR1 = 0.9, SR2 = 0.95, SR3 = 1.05, and SR4 = 1.1. The trend equation is: Ft = 11 + 3t. Over the past nine quarters, demand has been as follows: %3D Period, t: 1 4 7 8 9. Demand: 15 17 20 23 25 29 34 36 39 Click here for the Excel Data File Compute the MAD and tracking signal for each period. (Negative values should be indicated by a minus sign. Round your intermediate calculations and final answers to 3 decimal places.) Period, t Demand MAD Tracking signal 1 15 2 17 3 20 4 23 25 6. 29 7 34 36 39 LOarrow_forwardUse exponential smoothing with a smoothing constant of 0.3 to forecast the demand for fertilizer in year 12. Assume that last period's forecast for year 1 is 5,000 bags to begin the procedure. Bags are shown in 1,000's in table below. Year Demand (Bags) 6 3 4. 4. 5 10 6 8. 7 7 8 9 12 10 14 11 15 O A. 14.00 ОВ. 14.87 OC. 11.79 O D. 13.67 Click to select your answer. tUs I MacBook Air 80 F3 888 * ES F4 44 F7 F2 F6 F8 >) FIO F11 @ #3 24 4 & 2 6. 7 8 9. 0. W R Y U P. F G H %3D K C V N alt command command option * coarrow_forward
- calculate barrow_forwardFor this exercise, you will need to download quarterly Personal Consumption Expenditures: Chain-type Price Index (PCECTPI) from FRED. The variable PCECTPI is the price index for personal consumption expenditures from the U.S. National Income and Product Accounts. In this exercise, you will construct forecasting models for the rate of inflation based on PCECTPI. For the analysis, you will use the sample period 1963:Q1-2019:Q4, but data before 1963 may be used, as necessary, as initial values for lags in regressions. a. Compute the inflation rate, Infl, = 400 x [In(PCECTPI) - In(PCECTPI-1)]. What are the units of Infl? (Is Infl measured in dollars, percentage points, percentage per quarter, percentage per year, or something else? Explain.) b. Compute the first four autocorrelations of AInfl. Estimate an AR(2) model for AInfl. Present you results. c. Forecast AInfl2020:Q1, the change in inflation from 2020:Q1 to 2019:Q4. d. Forecast Infl2020:02, the change in inflation from 2020:Q2 to…arrow_forwardYear Quarter Revenue Q1 4.80 Q2 4.56 2015 Q3 4.88 Q4 4.91 Q1 5.37 Q2 4.99 2016 Q3 5.24 Q4 5.71 Q1 5.73 Q2 5.29 2017 Q3 5.66 Q4 5.70 Q1 6.07 Q2 6.03 2018 Q3 6.31 Q4 6.30 Q1 6.60 Q2 6.31 2019 Q3 6.82 Q4 6.75 Q1 7.10 Q2 6.00 2020 Q3 4.20 Q4 6.20arrow_forward
- Savings-Mart (a chain of discount department stores) sells patio and lawn furniture. Sales are seasonal, with higher sales during the spring and summer quarters and lower sales during the fall and winter quarters. The company developed the following quarterly sales forecasting model: Y t=8.25+0.125t2.75D1t+3.50D3t where Y t=predictedsales(million)inquartert 8.25=quarterlysales(million)whent=0 t=timeperiod(quarter)wherethefourthquarterof2002=0,firstquarterof2003=1,secondquarterof2003=2,... D1t={1forfirst-quarterobservations0otherwiseD2t={1forsecond-quarterobservations0otherwiseD3t={1forthird-quarterobservations0otherwise Forecast Savings-Marts sales of patio and lawn furniture for each quarter of 2010.arrow_forwardMr. Geppetto uses exponential smoothing to predict revenue in his wood carving business. He uses a weight of = .4 for the naïve forecast and (1-) = .6 for the past forecast. What revenue did he predict for March using the data below? MONTH REVENUE FORECAST Nov 100 100 Dec 90 100 Jan 115 ---- Feb 110 ---- MARCH ? ?arrow_forwardSuppose that the world's current oil reserves is R = 2060 billion barrels. If, on average, the total reserves is decreasing by 15 billion barrels of oil each year, answer the following: A.) Give a linear equation for the total remaining oil reserves, R, in terms of t, the number of years since now. (Be sure to use the correct variable and Preview before you submit.) R= B.) 8 years from now, the total oil reserves will be billions of barrels. C.) If no other oil is deposited into the reserves, the world's oil reserves will be completely depleted (all used up) approximately years from now. (Round your answer to two decimal places.)arrow_forward
- A local moving company has collected data on the number of moves they have been asked to perform over the past two years. Moving is highly seasonal, so the owner/operator, who is both burly and highly educated, decides to apply the multiplicative seasonal method to forecast the number of customers for the coming year. The equation for the trend line of yearly sales is Ft = 16 + 60t. Please forecast demand for each quarter in Year 3. (Round the forecasts to whole numbers and show all calculations). Complete the table below and forecast the sales of Year 3 by quarter. Year 1 Year 2 Year 3 Quarter Demand Seasonal Index Quarter Demand Seasonal Index Average Seasonal Index Forecast 1 20 1 27 2 40 2 45 3 45 3 55 4 31 4 41 Total Averagearrow_forwardThe unemployment rate in a certain country was dropping at a constant rate of 0.2% (= 0.002, in decimals) between 2009 and 2019. In 2012, the unemployment rate was 3.5%.Let t be the number of years since 2009 and let U(t) be the unemployment rate at year t.(a) Find a formula for the function U. (Hint: use decimals in place of percentages.)U(t) =(b) Assuming the model is valid for a couple of more years after 2019, calculate the expected unemployment rate in year 2021. Enter your answer as a percentage.arrow_forwardHere are the errors associated with a particular forecast over the past five months, in chronological order: 5, 10, -10, 0, 10. Which of the following statements is (are) true? I. The mean absolute deviation (MAD) over these five months is 3. II. The forecast was too low during the third month. II. The forecast was perfectly accurate during one of the months. T only. Il and II I, Il and III Ill only. I and IIarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Managerial Economics: Applications, Strategies an...EconomicsISBN:9781305506381Author:James R. McGuigan, R. Charles Moyer, Frederick H.deB. HarrisPublisher:Cengage Learning
Managerial Economics: Applications, Strategies an...
Economics
ISBN:9781305506381
Author:James R. McGuigan, R. Charles Moyer, Frederick H.deB. Harris
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