STAT TECH IN BUSINESS & ECON AC
18th Edition
ISBN: 9781264731657
Author: Lind
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Question
Chapter 18, Problem 10E
a.
To determine
To draw: The graph of the provided time series data and draw the observations.
b.
To determine
To calculate: All possible forecasts using a smoothing coefficient
c.
To determine
To calculate: The MAD
d.
To determine
To calculate: The forecast demand for period
e.
To determine
To calculate: The error associated with eleventh-period forecast.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
17 see picture to solve
Using Excel, run descriptive analysis for the first 12 months, the next 12 months, etc., on the dataset.
Determine the 12 period moving average forecasts and the simple exponential smoothing forecasts (α = 0.05) based on the data. The mathematical formulas for these forecasting techniques are as follows. N period Moving Average Forecast (for next period) = (Sum of Actuals for N number of previous periods) / N. Note: For this assignment, assume N=12. Simple Exponential Smoothing Forecast (for next period) = Previous Period Forecast + (α * (Previous Period Actual - Previous Period Forecast)). Note: For this assignment, assume α = 0.05. For the Period 1, assume that the Forecast is the same as the Actual.value. Mean Absolute %Error = Average of: ((|Actual - Forecast|) / Actual )) for all periods where Actuals and Forecasts exist.
Create a line chart for each forecast and ensure that each line chart also contains the historical dataset.
Compute the mean absolute percentage error for each…
Q20
Chapter 18 Solutions
STAT TECH IN BUSINESS & ECON AC
Ch. 18 - Prob. 1ECh. 18 - Prob. 2ECh. 18 - Prob. 3ECh. 18 - Prob. 4ECh. 18 - Prob. 1SRCh. 18 - Prob. 5ECh. 18 - Prob. 6ECh. 18 - Prob. 7ECh. 18 - Prob. 8ECh. 18 - Prob. 2SR
Ch. 18 - Prob. 9ECh. 18 - Prob. 10ECh. 18 - Prob. 11ECh. 18 - Prob. 12ECh. 18 - Prob. 3SRCh. 18 - Prob. 13ECh. 18 - Prob. 14ECh. 18 - Prob. 15ECh. 18 - Prob. 16ECh. 18 - Prob. 17ECh. 18 - Prob. 18ECh. 18 - Prob. 4SRCh. 18 - Prob. 19ECh. 18 - Prob. 20ECh. 18 - Prob. 21ECh. 18 - Prob. 22ECh. 18 - Prob. 23CECh. 18 - Prob. 24CECh. 18 - Prob. 25CECh. 18 - Prob. 26CECh. 18 - Prob. 27CECh. 18 - Prob. 28CECh. 18 - Prob. 29CECh. 18 - Prob. 30CECh. 18 - Prob. 31CECh. 18 - Prob. 32CECh. 18 - Prob. 33CECh. 18 - Prob. 34CECh. 18 - Prob. 35CECh. 18 - Prob. 1PCh. 18 - Prob. 2PCh. 18 - Prob. 3PCh. 18 - Prob. 1.1PTCh. 18 - Prob. 1.2PTCh. 18 - Prob. 1.3PTCh. 18 - Prob. 1.4PTCh. 18 - Prob. 1.5PTCh. 18 - Prob. 1.6PTCh. 18 - Prob. 1.7PTCh. 18 - Prob. 1.8PTCh. 18 - Prob. 1.9PTCh. 18 - Prob. 1.10PTCh. 18 - Prob. 2.1PTCh. 18 - Prob. 2.2PTCh. 18 - Prob. 2.3PT
Knowledge Booster
Similar questions
- The US. import of wine (in hectoliters) for several years is given in Table 5. Determine whether the trend appearslinear. Ifso, and assuming the trend continues, in what year will imports exceed 12,000 hectoliters?arrow_forwardThe U.S. Census tracks the percentage of persons 25 years or older who are college graduates. That data forseveral years is given in Table 4[14]. Determine whether the trend appears linear. If so, and assuming the trendcontinues. in what year will the percentage exceed 35%?arrow_forwardTable 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_forward
- 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_forwardLife Expectancy The following table shows the average life expectancy, in years, of a child born in the given year42 Life expectancy 2005 77.6 2007 78.1 2009 78.5 2011 78.7 2013 78.8 a. Find the equation of the regression line, and explain the meaning of its slope. b. Plot the data points and the regression line. c. Explain in practical terms the meaning of the slope of the regression line. d. Based on the trend of the regression line, what do you predict as the life expectancy of a child born in 2019? e. Based on the trend of the regression line, what do you predict as the life expectancy of a child born in 1580?2300arrow_forward
- Find the mean hourly cost when the cell phone described above is used for 240 minutes.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_forwardUse the table of values you made in part 4 of the example to find the limiting value of the average rate of change in velocity.arrow_forward
- 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)? $ _______millionarrow_forward20 see picarrow_forwardAn economist wants to compare the economic growth rate (%) within 50 kilometers and 100 kilometers to cities in a country. He collected 6 cities of the country, and calculated the growth rates with 50km and 100km as shown in the following table. Choose an appropriate test to validate that regions within 100km have higher economic growth rate than the regions within 50km to cities. You can make certain assumptions, but need to write to indicate your assumption. Show calculations by hand.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Glencoe Algebra 1, Student Edition, 9780079039897...AlgebraISBN:9780079039897Author:CarterPublisher:McGraw HillCollege AlgebraAlgebraISBN:9781305115545Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage Learning
- Functions and Change: A Modeling Approach to Coll...AlgebraISBN:9781337111348Author:Bruce Crauder, Benny Evans, Alan NoellPublisher:Cengage LearningAlgebra and Trigonometry (MindTap Course List)AlgebraISBN:9781305071742Author:James Stewart, Lothar Redlin, Saleem WatsonPublisher:Cengage LearningBig Ideas Math A Bridge To Success Algebra 1: Stu...AlgebraISBN:9781680331141Author:HOUGHTON MIFFLIN HARCOURTPublisher:Houghton Mifflin Harcourt
Glencoe Algebra 1, Student Edition, 9780079039897...
Algebra
ISBN:9780079039897
Author:Carter
Publisher:McGraw Hill
College Algebra
Algebra
ISBN:9781305115545
Author:James Stewart, Lothar Redlin, Saleem Watson
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 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