0% found this document useful (0 votes)
39 views5 pages

2006 2007 2008 2009 2010 X Y January February March April May June July August September October November December

The document contains monthly data from 2006 to 2010 for an unspecified item. It also contains additional columns with labels X, Y, and totals. The 3-point moving average line shows a general upward trend from 2006 to 2010 with some fluctuations. The accuracy metrics at the bottom indicate the moving average was generally within 150 units of the actual values on average.

Uploaded by

Hina Nazlee
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
39 views5 pages

2006 2007 2008 2009 2010 X Y January February March April May June July August September October November December

The document contains monthly data from 2006 to 2010 for an unspecified item. It also contains additional columns with labels X, Y, and totals. The 3-point moving average line shows a general upward trend from 2006 to 2010 with some fluctuations. The accuracy metrics at the bottom indicate the moving average was generally within 150 units of the actual values on average.

Uploaded by

Hina Nazlee
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 5

2006 2007 2008 2009 2010 X Y

January 779 845 857 917 887 1 779


February 802 739 881 956 892 2 802
March 818 871 937 1001 997 3 818
April 888 927 1159 1142 1118 4 888
May 898 1133 1072 1276 1197 5 898
June 902 1124 1246 1356 1256 6 902
July 916 1056 1198 1288 1202 7 916
August 708 889 922 1082 1170 8 708
September 695 857 798 877 982 9 695
October 708 772 879 1009 1297 10 708
November 716 751 945 1100 1163 11 716
December 784 820 990 998 1053 12 784
13 845
14 739
15 871
16 927
17 1133
18 1124
19 1056
20 889
21 857
22 772
23 751
24 820
25 857
26 881
27 937
28 1159
29 1072
30 1246
31 1198
32 922
33 798
34 879
35 945
36 990
37 917
38 956
39 1001
40 1142
41 1276
42 1356
43 1288
44 1082
45 877
46 1009
47 1100
48 998
49 887
50 892
51 997
52 1118
53 1197
54 1256
55 1202
56 1170
57 982
58 1297
59 1163
60 1053
58498
3-Point Moving Avg Accurate Absolute MAD MAPD BIAS
Error Error
0 0.00
0 0.00
0 0.00
799.67 -88.33 88.33 22.08 4.00
836.00 -62.00 62.00 30.07 2.06
868.00 -34.00 34.00 30.72 1.11
896.00 -20.00 20.00 2.86 7.00
905.33 197.33 197.33 27.17 7.26
842.00 147.00 147.00 40.48 3.63
773.00 65.00 65.00 6.50 10.00
1600
703.67 -12.33 12.33 7.03 1.75
706.33 -77.67 77.67 12.92 6.01 1400
736.00 -109.00 109.00 8.38 13.00
1200
781.67 42.67 42.67 10.83 3.94
789.33 -81.67 81.67 15.56 5.25 1000
818.33 -108.67 108.67 6.79 16.00
845.67 -287.33 287.33 23.29 12.34 800
977.00 -147.00 147.00 30.17 4.87
600
1061.33 5.33 5.33 0.28 19.00
1104.33 215.33 215.33 11.03 19.52 400
1023.00 166.00 166.00 18.41 9.02
934.00 162.00 162.00 7.36 22.00 200

839.33 88.33 88.33 10.88 8.12 0


793.33 -26.67 26.67 11.54 2.31 1 4 7 10 13 16 19 22 25 28 31 34
781.00 -76.00 76.00 3.04 25.00
809.33 -71.67 71.67 5.68 12.62
852.67 -84.33 84.33 8.59 9.81
891.67 -267.33 267.33 9.55 28.00
992.33 -79.67 79.67 11.97 6.66
1056.00 -190.00 190.00 17.90 10.61
1159.00 -39.00 39.00 1.26 31.00
1172.00 250.00 250.00 9.03 27.68
1122.00 324.00 324.00 18.58 17.44
972.67 93.67 93.67 2.75 34.00
866.33 -78.67 78.67 4.92 15.98
874.00 -116.00 116.00 8.01 14.48
938.00 21.00 21.00 0.57 37.00
950.67 -5.33 5.33 0.69 7.70
954.33 -46.67 46.67 1.87 24.93
958.00 -184.00 184.00 4.60 40.00
1033.00 -243.00 243.00 10.41 23.33
1139.67 -216.33 216.33 15.32 14.12
1258.00 -30.00 30.00 0.70 43.00
1306.67 224.67 224.67 5.79 38.82
1242.00 365.00 365.00 13.77 26.51
1082.33 73.33 73.33 1.59 46.00
989.33 -110.67 110.67 3.91 28.27
995.33 -2.67 2.67 3.89 0.69
1035.67 148.67 148.67 3.03 49.00
995.00 103.00 103.00 5.03 20.46
925.67 -71.33 71.33 6.33 11.26
925.33 -192.67 192.67 3.71 52.00
1002.33 -194.67 194.67 7.31 26.64
1104.00 -152.00 152.00 9.99 15.22
1190.33 -11.67 11.67 0.21 55.00
1218.33 48.33 48.33 1.07 45.11
1209.33 227.33 227.33 5.04 45.10
1118.00 -179.00 179.00 3.09 58.00
1149.67 -13.33 13.33 3.26 4.09
1147.33 94.33 94.33 4.78 19.74
-648.33 6773.00 1143.46
222.07 0

6773.00
error 0.11578
bias
13 16 19 22 25 28 31 34 37 40 43 46 49 52 55 58

You might also like