Consider the example of Figure 7.7, in which the smoothing constant was taken to be α =
Question:
FIGURE 7.7: Worksheet for Exponential Smoothing Calculations
a. Identify the a-value that achieves the smallest value of MSE.
b. Identify the a-value that achieves the smallest value of MAD?
Transcribed Image Text:
H. к 1 Exponential Smoothing Example Initial value S(1) - X(1) Alpha 0.2 4 Period 4-week Moving Average Fafecast Observed st) Error Deviation Percent A(t) Forecast Difference Deviation Percent 6. 73.00 73 79.60 73.00 106 78.60 76 78.88 86.00 78.88 89 80.90 10 94.25 \86.00 94.25 9e A(t) = [X(t)+X(t-1)+X(t-2)+X[t-3)]14 106 85.92 80.90 25.10 -27,08 -4.St) - aalt) + (1-e)S(t-11 25.10 24% -20.00 20.00 19% 11 113 91.34 85.92 27.08 24% 96.00 -18.75 18.75 17% 12 92.27 91.94 96 101.00 13 26.27 26.27 40% 35.00 66 87.02 92.27 95.25 101.00 35.00 53% 14 104 90.41 87.02 -16.98 16.98 16% 94.75 95.25 -8.75 8.75 8% 15 86.93 90.41 10 73 17.41 17.41 24% 84.75 94.75 21.75 21.75 30% 16 84.94 11 77 86.93 9.93 9.93 13% 80.00 84.75 7.75 7.75 10% 17 12 119 91.76 84.94 -34.06 34.06 29% 93.25 80.00 -39.00 39.00 33% 18 90.20 93.25 13 84 91.76 7.76 7.76 9% 88.25 9.25 9.25 11% 19 14 71 86.36 90.20 19.20 19.20 27% 87.75 88.25 17.25 17.25 24% 87.75 20 15 88 86.69 86.36 -1.64 1.64 90.50 -0.25 0.25 21 22 16 97 88.75 86.69 -10.31 10.31 11% 85.00 90.50 -6.50 6.50 19.75 16.00 17 69 84.80 88.75 19.75 29% 81.25 85.00 16.00 23% 23 91.24 32.20 18 117 84.80 -32.20 28% 92.75 81.25 -35.75 35.75 31% 24 80 88.99 19 91.24 11.24 11.24 14% 90.75 92.75 12.75 12.75 16% 25 85.79 15.99 175.ל 17.75 20 75 88.99 15.99 22% 84.75 90.75 24% 26 27 MAPE MSE MAD MAPE MSE MAD 28 17.47 19.7% 19.1% For periods 5-20 391.99 409.02 16.66 29 7.7
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 66% (6 reviews)
a The exponential smoothing model is used in forecasting Use following formula to calculate the forecasted value in exponential smoothing model Where ...View the full answer
Answered By
ANDREW KIPRUTO
Academic Writing Expert
I have over 7 years of research and application experience. I am trained and licensed to provide expertise in IT information, computer sciences related topics and other units like chemistry, Business, law, biology, biochemistry, and genetics. I'm a network and IT admin with +8 years of experience in all kind of environments.
I can help you in the following areas:
Networking
- Ethernet, Wireless Airmax and 802.11, fiber networks on GPON/GEPON and WDM
- Protocols and IP Services: VLANs, LACP, ACLs, VPNs, OSPF, BGP, RADIUS, PPPoE, DNS, Proxies, SNMP
- Vendors: MikroTik, Ubiquiti, Cisco, Juniper, HP, Dell, DrayTek, SMC, Zyxel, Furukawa Electric, and many more
- Monitoring Systems: PRTG, Zabbix, Whatsup Gold, TheDude, RRDtoo
Always available for new projects! Contact me for any inquiries
4.30+
1+ Reviews
10+ Question Solved
Related Book For
Management Science The Art of Modeling with Spreadsheets
ISBN: 978-1118582695
4th edition
Authors: Stephen G. Powell, Kenneth R. Baker
Question Posted:
Students also viewed these Numerical Analysis questions
-
Consider the example of a nonconvex programming problem presented in Sec. 13.10 and depicted in Fig. 13.18.
-
Consider the example of the town of Lincoln, which was analyzed using a multiplicative model in Figure 7.14. Repeat the forecasts using the additive model, with the same smoothing constants. FIGURE...
-
Consider the example of the new product at Curtis Distributors, which was analyzed using Holt's method in Figure 7.12. Repeat the forecasts using one smaller value of a than the value of 0.2 used in...
-
1) Identify the population and sample from the following statements: a) A survey conducted at NSU has found that out of 371 students, 52 are left-handed b) In a rescue shelter, the height and weight...
-
Draw three resonance forms for the cyclohexadienylradical. Cyclohexadienyl radical
-
One of the biggest news items in the UK retail sector recently is the 1.4 billion acquisition in September 2016 of Home Retail Group, the parent company of Argos, by Sainsburys, one of the leading...
-
Consider the flowsheet for the manufacture of vinyl chloride in Figure 2.6. (a) If the pyrolysis furnace and distillation towers are operated at low pressure \((1.5 \mathrm{~atm})\), what are the...
-
Discuss the appropriateness of making the accrual entries based on the perspectives of Jackie and Glen. What do you believe to be the intent of Glen in this matter? Explain.
-
Consider a rectangular wing mounted in a low - speed subsonic wind tunnel. The wing model completely spans the test section so that the flow sees essentially an infinite wing. If the wing has an NACA...
-
Martineau Inc., a major retailer of high-end office furniture, operates several stores and is a publicly traded company. The company is currently preparing its statement of cash flows. The...
-
Contributions to the disaster relief fund for a national charity average around $1 million a month and do not exhibit trend or seasonal effects. Data on the most recent 12 months is given in the...
-
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...
-
Hendrick Motorsports sponsors cars and drivers in the National Association for Stock Car Auto Racing (NASCAR)'s Sprint Cup Series. Performance data for three recent years are as follows: Number of...
-
The CNO has asked to meet with you to discuss your stakeholder analysis. Prepare a stakeholder map, power/interest grid, and stakeholder analysis in advance of the meeting. Also include a one-page...
-
Assume the situation from question 13 , except now assume that banks hold a ratio of \(0.5 \%\) of excess reserves to deposits and the public keeps \(20 \%\) of its liquid assets in the form of cash....
-
You are the chief nurse executive at an organization that provides clinic services to Medicare patients; seven of the clinics are located in underserved areas. While visiting one of the clinics, you...
-
An investment company has \(\$ 1.05\) million of assets, \(\$ 50,000\) of liabilities, and 10,000 shares outstanding. a. What is its NAV? b. Suppose the fund pays off its liabilities while at the...
-
You are an NP who sees mostly posthead trauma patients and who refers many of these patients to physical and occupational services. On one routine follow-up visit, your patient claims that he has not...
-
Why might the cartel model still make sense even when OPEC produces less than half of the worlds oil?
-
What is the difference between the straight-line method of depreciation and the written down value method? Which method is more appropriate for reporting earnings?
-
Employ the following methods to find the maximum of the function from Prob.13.8: (a) Golden-section search (x1 = 2, xu = 1, s = 1%). (b) Quadratic interpolation (x0 = 2, x1 = 1, x2 = 1, iterations =...
-
Consider the following function : (x) = 2x + 3/x Perform 10 iterations of quadratic interpolation to locate the minimum. Comment on the convergence of your results. (x 0 = 0.1, x 1 = 0.5, x 2 = 5)
-
Consider the following function : (x) = 3 + 6x + 5x 2 + 3x 3 4x 4 Locate the minimum by finding the root of the derivative of this function. Use bisection with initial guesses of x l = -2 and x u = 1.
-
Question: d. ?During December, Ingrid Legal Services provided legal services, and the client prepaid $7,000. ?Ingrid Legal Services recorded this amount as Unearned Revenue. The job will take several...
-
Question: A company had the following purchases and sales during the month of November:\table[[Date,Activities,Units Acquired at Cost,Units Sold at Retail],[November 1,Beginning inventory,5 units @...
-
Question: Tania, Inc. issued a note payable with principal and interest due at the end of the term of the note. Details about the note payable are as follows:Issuance date: October 1, fear...
Study smarter with the SolutionInn App