Consider the stylized example of Figure 7.3, in which there is a jump in the mean value.
Question:
FIGURE 7.3 Moving- Average Calculations in a Stylized Example
a. Take a = 0.2. Calculate the forecasts generated by exponential smoothing, and compute the values of MSE, MAD, and MAPE for periods 10-15.
b. Repeat the calculations in part (a) but with a = 0.6.
c. If we suspect that there might be a jump in the underlying process, which of the two values of a examined in parts (a) and (b) would be preferred?
Transcribed Image Text:
AI BIC Moving Average Example к 1 3 Period 4-week Moving Average Observed A(t) Forecast Error Deviation Percent 6-week Moving Average A(t) Forecast DifferenceDeviation Percent 100 100 100 100 100.00 0% 100 100.00 100.00 0.00 0.00 10 100.00 0% 100 100.00 0.00 0.00 100.00 11 100.00 0% 100.00 0% 100 100.00 0.00 0.00 100.00 0.00 0.00 12 0% 0% 100 100.00 100.00 0.00 0.00 100.00 100.00 0.00 0.00 100 13 100.00 100.00 0.00 0.00 100.00 100.00 0.00 0.00 0% 44% 44% 14 10 180 120.00 100.00 80.00 80.00 113.33 100.00 80.00 80.00 15 33% 126.67 66.67 37% 11 180 140.00 120.00 60.00 60.00 113.33 66.67 16 180 22% 30% 12 160.00 140.00 40.00 40.00 140.00 126.67 53.33 53.33 20.00 17 13 180 180.00 160.00 20.00 11% 153.33 140.00 40.00 40.00 22% 18 0% 26.67 15% 14 180 180.00 180.00 0.00 0.00 166.67 153.33 26.67 0% 180.00 166.67 7% 19 15 180 180.00 180.00 0.00 0.00 13.33 13.33 0% 20 180 0.00 0% 16 180.00 180.00 0.00 180.00 180.00 0.00 0.00 21 17 180 180.00 180.00 0.00 0.00 0% 180.00 180.00 0.00 0.00 0% 22 0% 0% 18 180 180.00 180.00 0.00 0.00 180.00 180.00 0.00 0.00 0.00 0% 23 19 180 180.00 180.00 0.00 0.00 0% 180.00 180.00 0.00 24 0% 0% 20 180 180.00 180.00 0.00 0.00 180.00 180.00 0.00 0.00 25 26 MAPE MSE MAPE MSE MAD MAD 27 18.5% 25.9% For periods 10-15 2000.00 33.33 2696.30 46.67 Lon. 7.3 7.2
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 71% (14 reviews)
The exponential smoothing model is used in forecasting This method is better than the moving average model a Use following formula to calculate forecasted value in exponential smoothing model Where Sm...View the full answer
Answered By
Gauri Hendre
I worked as EI educator for Eduphy India YT channel. I gave online tutorials to the students who were living in the villages and wanted to study much more and were preparing for NEET, TET. I gave tutions for topics in Biotechnology. I am currently working as a tutor on course hero for the biochemistry, microbiology, biology, cell biology, genetics subjects. I worked as a project intern in BAIF where did analysis on diseases mainly genetic disorders in the bovine. I worked as a trainee in serum institute of India and Vasantdada sugar institute. I am working as a writer on Quora partner program from 2019. I writing on the topics on social health issues including current COVID-19 pandemic, different concepts in science discipline. I learned foreign languages such as german and french upto A1 level. I attended different conferences in the science discipline and did trainings in cognitive skills and personality development skills from Lila Poonawalla foundation. I have been the member of Lila poonawalla foundation since 2017. Even I acquired the skills like Excel spreadsheet, MS Office, MS Powerpoint and Data entry.
5.00+
4+ Reviews
10+ Question Solved
Related Book For
Management Science The Art Of Modeling With Spreadsheets
ISBN: 1301
4th Edition
Authors: Stephen G. Powell, Kenneth R. Baker
Question Posted:
Students also viewed these Numerical Analysis questions
-
Consider the stylized example in Figure 7.13. Repeat the forecasts using the additive model with trend, using the same smoothing constants. FIGURE 7.13 Stylized Model with Trend and Cyclic...
-
Consider the example of Figure 7.7, in which the smoothing constant was taken to be α = 0:2. Repeat the calculations for smoothing constants between 0.1 and 0.9, in steps of 0.1. FIGURE...
-
Consider rolling a green die and a white die. The roll (1, 5) is different from (5, 1). a. How many different outcomes are possible for this two-die experiment? b. How many different outcomes are...
-
A limited partnership: Multiple Choice has an unlimited life. can opt to be taxed as a corporation. terminates at the death of any one limited partner. has at least one partner who has unlimited...
-
How might you replace a halogen substituent by a deuterium atom if you wanted to prepare a deuteratedcompound? Br , CHH-H CHCH2CH
-
Compare the alternatives shown below on the basis of a future worth analysis, using an interest rate of 8% peryear. First cost, S Annual operating cost, $ per year4,000-2,500 Salvage value, $ Life,...
-
Write a detailed note on hospital costing.
-
What is the relationship among market segmentation, target marketing, and positioning? What will happen to a companys target marketing and positioning efforts if markets are incorrectly or not...
-
XYZ Inc. is considering a capital budgeting project that has an expected return of 32% and a standard deviation of 10%. What is the project's coefficient of variation?
-
Assume each of the following conditions concerning the data given: 1. All materials are added at the beginning of the process. 2. All materials are added at the end of the process. 3. Half of the...
-
The operations manager at a manufacturing facility is about to begin an energy-efficiency initiative. As this program begins, it will be helpful to have benchmark data on energy use, in order to...
-
Brad's Burritos provides a simple set of lunch offerings in a college town. The shop has recently decided to implement a forecasting system and is testing the use of exponential smoothing methods....
-
Pat James, the purchasing agent for a local plant of the Oakden Electronics Division, was considering the possible purchase of a component from a new supplier. The components purchase price, $0.90,...
-
Photon Technologies, Inc., a manufacturer of batteries for mobile phones, signed a contract with a large electronics manufacturer to produce three models of lithium-ion battery packs for a new line...
-
Mastery Problem: Capital Investment Analysis HomeGrown Company HomeGrown Company is a chain of grocery stores that are similar to indoor farmer's markets, providing fresh, local produce, meats, and...
-
McDonald's and CSR There more than 32,000 restaurants around the world (www.aboutmcdonalds.com/etc/medialib/csr/docs. that carry the McDonald's label and logo. As such, they...
-
Smartwatch Based on a survey by Consumer Technology Association, smartwatches are used in 18% of U.S. households. Find the probability that a randomly selected U.S. household has no smartwatches.
-
Suppose you wanted to purchase a commercial real estate property thats valued at $ 1 , 0 0 0 , 0 0 0 . You could secure financing from a traditional bank, which provides you with $ 7 5 0 , 0 0 0 ....
-
Joe provides the following information for the year ended 31 December 20*8: stock 1 January 20*8 238; stock 31 December 20*8 432; purchases 34,930; sales 54,760. Required Prepare a trading account...
-
Explain the circumstances that could result in a long-term bank loan being shown in a statement of financial position as a current liability.
-
A new product will sell for $8. The company expects to sell around 900,000 units. (Use a normal distribution with a mean of 900,000 and a standard deviation of 300,000.) Fixed costs are normally...
-
TCS Corporation has recently decided to manufacture a product in its own facilities rather than outsource to Asian manufacturers. Its new plant will last about ten years. TCS is considering two...
-
The Van Horne Company manufactures air conditioners that are sold to five large retail customers around the country. Van Horne is evaluating its manufacturing and logistics strategy to ensure that it...
-
In 2019, Sunland Company had a break-even point of $388,000 based on a selling price of $5 per unit and fixed costs of $155,200. In 2020, the selling price and the variable costs per unit did not...
-
11. String Conversion Given a binary string consisting of characters '0's and '1', the following operation can be performed it: Choose two adjacent characters, and replace both the characters with...
-
Consider the table shown below to answer the question posed in part a. Parts b and c are independent of the given table. Callaway Golf (ELY) Alaska Air Group (ALK) Yum! Brands (YUM) Caterpillar...
Study smarter with the SolutionInn App