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.5, Problem 14.25ACB
Annual U.S. craft beer production. Refer to Exercise 14.7 (p. 14-10) and the data on U.S. beer production (in millions of barrels) for the years 2004-2015.
a. Use the 2004-2013 values to forecast the 2014 and 2015 production, using simple exponential smoothing with w = .3. Repeat with w = .7.
b. Use Holt’s model with w = .7 and v = .3 to forecast production in 2014 and 2015. Repeat with w = .3 and v = .7.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
With the gasoline time series data from the given table, show the exponential smoothing forecasts using = 0.1.
Week
Sales (1000s of gallons)
1
17
2
21
3
19
4
23
5
18
6
16
7
20
8
18
9
22
10
20
11
15
12
22
Applying the MSE measure of forecast accuracy, would you prefer a smoothing constant of = 0.1 or = 0.2 for the gasoline sales time series? Do not round your interim computations and round your final answers to two decimal places.
= 0.1
= 0.2
MSE
fill in the blank 1
fill in the blank 2
Prefer: 01. or 0.2
2. Are the results the same if you apply MAE as the measure of accuracy? Do not round your interim computations and round your final answers to two decimal places.
= 0.1
= 0.2
MAE
fill in the blank 4
fill in the blank 5
Prefer: 0.1 or 0.2
3. What are the results if MAPE is used? Do not round your interim computations and round your final answers to two decimal places.
= 0.1
= 0.2
MAPE
fill in…
The 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)?
$ _______million
Storrs Cycles has just started selling the new Cyclonemountain bike, with monthly sales as shown in the table. First,co-owner Bob Day wants to forecast by exponential smoothingby initially setting February’s forecast equal to January’s saleswith a = .1. Co-owner Sherry Snyder wants to use a three-periodmoving average.
a) Is there a strong linear trend in sales over time?b) Fill in the table with what Bob and Sherry each forecast forMay and the earlier months, as relevant.c) Assume that May’s actual sales figure turns out to be 405.Complete the table’s columns and then calculate the meanabsolute deviation for both Bob’s and Sherry’s methods.d) Based on these calculations, which method seems moreaccurate?
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
- Table 6 shows the population, in thousands, of harbor seals in the Wadden Sea over the years 1997 to 2012. a. Let x represent time in years starting with x=0 for the year 1997. Let y represent the number of seals in thousands. Use logistic regression to fit a model to these data. b. Use the model to predict the seal population for the year 2020. c. To the nearest whole number, what is the limiting value of this model?arrow_forwardCable TV The following table shows the number C. in millions, of basic subscribers to cable TV in the indicated year These data are from the Statistical Abstract of the United States. Year 1975 1980 1985 1990 1995 2000 C 9.8 17.5 35.4 50.5 60.6 60.6 a. Use regression to find a logistic model for these data. b. By what annual percentage would you expect the number of cable subscribers to grow in the absence of limiting factors? c. The estimated number of subscribers in 2005 was 65.3million. What light does this shed on the model you found in part a?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_forward
- The following fictitious table shows kryptonite price, in dollar per gram, t years after 2006. t= Years since 2006 0 1 2 3 4 5 6 7 8 9 10 K= Price 56 51 50 55 58 52 45 43 44 48 51 Make a quartic model of these data. Round the regression parameters to two decimal places.arrow_forwardWorld Population The following table shows world population N, in billions, in the given year. Year 1950 1960 1970 1980 1990 2000 2010 N 2.56 3.04 3.71 4.45 5.29 6.09 6.85 a. Use regression to find a logistic model for world population. b. What r value do these data yield for humans on planet Earth? c. According to the logistic model using these data, what is the carrying capacity of planet Earth for humans? d. According to this model, when will world population reach 90 of carrying capacity? Round to the nearest year. Note: This represents a rather naive analysis of world population.arrow_forwardWith the gasoline time series data from table 17.1, show the exponential smoothing forecasts using a = .1.a. applying the MSe measure of forecast accuracy, would you prefer a smoothing constant of a = .1 or a = .2 for the gasoline sales time series?b. are the results the same if you apply Mae as the measure of accuracy?c. What are the results if Mape is used?arrow_forward
- Compute the forecasted values for Yt for July and August in 2020 by using the modelsstated in (c) and (d)arrow_forwardNumber of Certified Organic Farmsin the United States, 2001–2008 Year Farms 2001 5,441 2002 5,806 2003 6,546 2004 6,528 2005 6,944 2006 7,854 2007 9,430 2008 10,728 Fit three trends: linear yt= xt+quadratic yt= xt^2+ xt+ exponential yt= e x Use each of the three fitted trend equations to make numerical forecasts for the next three years. t Linear Quadratic Exponential 9 10 11arrow_forwardSuppose a new magazine initially sells 600 copies per month. Research indicates that a vigorous advertising campaign could increase sales by 40% each month if our market were unlimited. But research also indicates that magazine sales in our area are unlikely to exceed 2400 per month. Make a logistic model of projected magazine sales. a) N = 600 / 1+3e^-0.336t b) N = 2400 / 1+3e^-0.336t c) N = 40 / 1+3e^-0.336t d) N = 2400 / 1+40e^-0.336tarrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Linear Algebra: A Modern IntroductionAlgebraISBN:9781285463247Author:David PoolePublisher:Cengage LearningFunctions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage Learning
- Algebra & Trigonometry with Analytic GeometryAlgebraISBN:9781133382119Author:SwokowskiPublisher:CengageCollege AlgebraAlgebraISBN:9781305115545Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage Learning
Linear Algebra: A Modern Introduction
Algebra
ISBN:9781285463247
Author:David Poole
Publisher:Cengage Learning
Functions and Change: A Modeling Approach to Coll...
Algebra
ISBN:9781337111348
Author:Bruce Crauder, Benny Evans, Alan Noell
Publisher:Cengage Learning
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:9781133382119
Author:Swokowski
Publisher:Cengage
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