Question: When creating a decomposition model (12 months) do I calculate center moving average with 2, 6 or 12 (MA, moving average) data points ? CMA

When creating a decomposition model (12 months) do I calculate center moving average with 2, 6 or 12 (MA, moving average) data points ?

CMA CMAT CF SF SI Forecast 10 1 m 4 01 5 3 m 1 Date Month Mar-2008 Mar Apr-2008 Apr May-2008 May Jun-2008 Jun Jul-2008 Jul Aug-2008 Aug Sep-2008 Sep Oct-2008 Oct 0 Nov-2008 Nov 1 Dec-2008 Dec 2 Jan-2009 Jan 3 Feb-2009 Feb 4 Mar-2009 Mar 5 Apr-2009 Apr L6 May-2009 May 7 Jun-2009 Jun 8 Jul-2009 Jul 9 Aug-2009 Aug 0 Sep-2009 Sep 1 Oct-2009 Oct 2 Nov-2009 Nov 3 Dec-2009 Dec Number of Time Index Home Sales MA 3214 2 3731 3 3831 4 4042 5 4456 6 4003 7 3796 8 3800 9 2584 10 2958 11 2031 12 2422 13 14 3232' 15 3354' 16 17 4130 18 3634 19 20 21 22 3032' 3173 0.62 0.74 0.97 0.99 1.02 3925" 3405.7 =AVERAGE(E12:E23) 3402.3 3288.5 3360.7 3277.2 3320.9 3273.5 3311.2 3276.8 3284.0 3281.5 3253.3 3279.9 3234.8 3275.8 3207.1 3267.9 3275.8 3256.0 3231.8 3274.3 3205.1 0.73 0.74 1.01 1.04 1.15 1.24 1.14 1.16 1.01 0.97 0.85 0.89 1.20 1.26 1.11 1.09 1.06 1.05 0.95 3575 3467 3409 3282.0 CMA CMAT CF SF SI Forecast 10 1 m 4 01 5 3 m 1 Date Month Mar-2008 Mar Apr-2008 Apr May-2008 May Jun-2008 Jun Jul-2008 Jul Aug-2008 Aug Sep-2008 Sep Oct-2008 Oct 0 Nov-2008 Nov 1 Dec-2008 Dec 2 Jan-2009 Jan 3 Feb-2009 Feb 4 Mar-2009 Mar 5 Apr-2009 Apr L6 May-2009 May 7 Jun-2009 Jun 8 Jul-2009 Jul 9 Aug-2009 Aug 0 Sep-2009 Sep 1 Oct-2009 Oct 2 Nov-2009 Nov 3 Dec-2009 Dec Number of Time Index Home Sales MA 3214 2 3731 3 3831 4 4042 5 4456 6 4003 7 3796 8 3800 9 2584 10 2958 11 2031 12 2422 13 14 3232' 15 3354' 16 17 4130 18 3634 19 20 21 22 3032' 3173 0.62 0.74 0.97 0.99 1.02 3925" 3405.7 =AVERAGE(E12:E23) 3402.3 3288.5 3360.7 3277.2 3320.9 3273.5 3311.2 3276.8 3284.0 3281.5 3253.3 3279.9 3234.8 3275.8 3207.1 3267.9 3275.8 3256.0 3231.8 3274.3 3205.1 0.73 0.74 1.01 1.04 1.15 1.24 1.14 1.16 1.01 0.97 0.85 0.89 1.20 1.26 1.11 1.09 1.06 1.05 0.95 3575 3467 3409 3282.0

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

When creating a decomposition model (12 months) do I calculate center moving average with 2, 6 or 12 (MA, moving average) data points ?

Please show all formulas used in Excel. Must show work, thank you. How do you not see these pictures? There is no excuse to not be able to answer this. Please show formulas used, thank you. Total...

The \"oligopoly.dta\" attached give quarterly sales of the popular game Oligopoly at the J-Mart variety store. Please use the multiplicative decomposition method to forecast Oligopoly sales for year...

Pacific Systems Elcom Sure Tech E-Drive Park Current Ratio 1.2 1.3 1.3 1.1 Inventory Turnover 5.2 5.4 9 7 Long-Term Debt Ratio to Assets 0.25 0.15 0.17 0.4 Receivable Days 49 29 59 40 Payable Days...

please help me summarize this chapter summarize this chapter please g) whes din indring woont of ochgeful in s tem pai . 4 buy per 2 Puneing. Implementing and Evaluating Marketing Strategies e...

PLEASE DO NOT COPY-PASTE ANSWERS FROM A SIMILAR CHEGG QUESTION. EXPLAIN AND ANSWER CLEARLY! THANK YOU! The following table gives monthly data for four years in million tons of consumption of ice...

Hi Erylee88, I would like to utilize your service again. Same format different questions. Please find attached document for your review. Let me know. Thank you, Sam...

PART I"Basic Building Block" Excel Model Creation (Groups of up to 3individuals for Part I) Reference any all CCIM/G-M modules/chapters in course textbook or the library for any required supporting...

Supply Chain Management Introduction Outline What is supply chain management? Significance of supply chain management. Push vs. Pull processes utdallas.edu/~metin 1 A Generic Supply Chain Sources:...

Help me Create a forecast for average demand Using historic sales data create a monthly forecast using classical decomposition that is based on regression and seasonality. We are creating a monthly...

How does a business decide whether to trade with a foreign country? What are the key factors for participating in the information economy on a global basis?

Find the slope of the tangent line to the graph of r = 3 + 3 cos at the point on the graph where = 1/6 .

8. In the figure below, RS and UV are chords of the circle with centre O. Point I is the midpoint of RS and point / lies on UV such that LOJU=90. Given that OI = JO and UV = 11 cm, find the length of...

Ethylene glycol is flowing through a horizontal circular cross sectional area tube of length 0.8m at steady state. Pressure drop in this tube is measured with U- tube manometer. Manometer reading is...

10. last word Does leverage increase the total size of the gain or loss from an investment, or just the percentage rate of return on the part of the investment amount that was not borrowed? How would...

4. Why does the Federal Reserve require commercial banks to have reserves? Explain why reserves are an asset to commercial banks but a liability to the Federal Reserve Banks. What are excess...

5. The two conflicting goals facing commercial banks are: LO35.3 a. Profit and liquidity. b. Profit and loss. c. Deposits and withdrawals. d. Assets and liabilities.