Assignment:
Given below are the monthly demand for a product.
|
Month
|
Demand
|
Month
|
Demand
|
Month
|
Demand
|
|
1
|
487
|
13
|
528
|
25
|
517
|
|
2
|
602
|
14
|
622
|
26
|
595
|
|
3
|
551
|
15
|
608
|
27
|
619
|
|
4
|
587
|
16
|
592
|
28
|
602
|
|
5
|
509
|
17
|
536
|
29
|
545
|
|
6
|
457
|
18
|
504
|
30
|
486
|
|
7
|
349
|
19
|
461
|
31
|
431
|
|
8
|
386
|
20
|
391
|
32
|
416
|
|
9
|
490
|
21
|
437
|
33
|
444
|
|
10
|
507
|
22
|
503
|
34
|
492
|
|
11
|
516
|
23
|
562
|
35
|
538
|
|
12
|
573
|
24
|
570
|
36
|
575
|
a. Compute the 3-month moving average of this demand. Does this series still show seasonal variation?
b. Compute the 6- and 12-month moving averages of this demand.
c. Plot the original data and the three moving averages. (use an Excel spreadsheet!)
Provide complete and step by step solution for the question and show calculations and use formulas.