Computing monthly demand for a product


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.

 

Request for Solution File

Ask an Expert for Answer!!
Basic Statistics: Computing monthly demand for a product
Reference No:- TGS02006842

Expected delivery within 24 Hours