Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Compute MAD and MSE for each forecast. The forecasts and actual sales are as fol

ID: 464610 • Letter: C

Question

Compute MAD and MSE for each forecast.

The forecasts and actual sales are as follows:

Month

SALES (ACTUAL)

FORECAST I

FORECAST II

1

780

770

778

2

789

785

788

3

794

790

792

4

780

784

798

5

778

770

774

6

772

768

770

7

765

761

759

8

775

771

775

9

786

784

788

10

790

788

788

              11                                            795                                           800                                          795

Month

SALES (ACTUAL)

FORECAST I

FORECAST II

1

780

770

778

2

789

785

788

3

794

790

792

4

780

784

798

5

778

770

774

6

772

768

770

7

765

761

759

8

775

771

775

9

786

784

788

10

790

788

788

Explanation / Answer

MAD for Forecast I is : 12.6

Month SALES (ACTUAL) FORECAST I 3MA Error |Error| Error Sqaue FORECAST II 3MA Error |Error| Error Sqaue 1 780 770 778 2 789 785 788 3 794 790 792 4 780 784 781.666667 2 2 4 798 786 12 12 144 5 778 770 786.333333 -16 16 256 774 792.6667 -19 19 361 6 772 768 781.333333 -13 13 169 770 788 -18 18 324 7 765 761 774 -13 13 169 759 780.6667 -22 22 484 8 775 771 766.333333 5 5 25 775 767.6667 7 7 49 9 786 784 766.666667 17 17 289 788 768 20 20 400 10 790 788 772 16 16 256 788 774 14 14 196 11 795 800 781 19 19 361 795 783.6667 11 11 121 12 790.666667 101 1529 790.3333 123 2079 12.6 191.1 15.4 259.9 MAD MSE MAD MSE
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote