Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I am only postimg the first excel. I can do the other if you show me how. I can do this one as well if

I am only postimg the first excel. I can do the other if you show me how. I can do this one as well if you post the equations I need to put in excel
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Required: Use the data posted on the "Assignments" section of the course Blackboard site with the title of "data1 for assignment 5" to compute ME, MPE, MAE, MAPE, and MSE. Then, repeat the calculation using the date with the title of "data2 for assignment5". Explain which forecast works better. Why? Paste LCopy Format Painter BIU- Clipboard 5 Font F13 fx E 66.6 B 1 Year Month 2 1992 JAN 3 1992 FEB 1992 MAR 5 1992 APR 6 1992 MAY 7 1992 JUN 1992 JUL 9 1992 AUG 10 1992 SEP 11 1992 OCT 12 1992 NON 13 1992 DEC 14 1983 JAN 15 1993 FEB 16 1993 MAR 17 1933 APR 18 1983 MAY 19 1993 JUN 20 1983 JUL 21 1983 AUG 22 1333 SEP 23 1993 OCT 24 1980 NOV 25 1983 DEC 26 1394 JAN 27 1394 FEB 28 1394 MAR 29 1394 APR 30 1994 MAY 31 1994 JUN 32 33 1334 AUG 34 1394 SEP 35 1934 OCT 36 1994 NOV 37 1994 DEC 38 1995 JAN 39 1995 FEB 1995 MAR 1995 APR D Actual Forecast 35.9 29.9 40.6 40.9 43.3 428 54.3 478 591 58.2 629 68.3 705 66.3 692 64 617 541 521 34.1 36.8 292 35.3 283 35.9 30.6 40.6 433 476 543 57.5 591 645 629 68.5 68.3 673 68.3 58.8 48.7 541 356 34.1 35.4 29.2 35.5 28.3 319 30.6 43.9 476 47.6 508 575 70.0 845 712 63.5 70.9 65.0 S06 487 36.6 35.6 35.4 345 35.5 319 421 451 47.6 509 80.8 624 700 20.5 712 740 70.9 604 650 506 450 35.6 353 36.1 237 345 377 383 67.3 45 1995 JUL 1995 AUG 1395 OCT 1395 NOV 1335 DEC 1336 JAN 1936 FEB 1936 MAR 1936 APR 379 54 55 sas 503 Shsst F13 fx E B 55 1996 JUN 66.9 56 1996 JUL 715 57 1996 AUG 69.5 58 1996 SEP 60.8 59 1996 OCT 53.1 60 1996 NOV 40.6 61 1996 DEC 36.5 62 1997 JAN 313 63 1997 FEB 32.8 64 1997 MAR 45.5 65 1997 APR 42.8 66 1997 MAY 57.4 67 1997 JUN 66.5 68 997 JUL 714 69 1997 AUG 68.7 70 1997 SEP 64.0 71 1997 OCT 527 72 1997 NOV 37.9 73 1997 DEC 33.9 74 1998 JAN 36.5 75 1938 FEB 36.4 76 1998 MAR 387 77 1998 APR 46.5 78 1998 MAY 58.8 79 1998 JUN 621 BO 1998 JUL 728 81 1998 AUG 70.7 82 1998 SEP 67.1 83 1990 OCT 50.4 1938 NOV 44.0 85 1398 DEC 322 86 1999 JAN 36.4 87 1999 FEB 421 88 1999 MAR 460 89 1939 APR 44.5 90 1999 MAY 55.6 91 1999 JUN 64.8 92 1999 JUL 73.5 93 1999 AUG 69.3 94 1939 SEP 58.5 1999 OCT 519 96 1999 NOV 48.0 1333 DEC 369 98 2000 JAN 36.4 99 2000 FEB 410 100 2000 MAR 429 101 2000 APR 512 102 2000 MAY 610 103 2000 JUN 674 104 2000 JUL 74.7 105 2000 AUG 730 106 2000 SEP 621 107 2000 OCT 108 2000 NOV 314 109 2000 DEC 312 Sheet1 D 624 70.5 740 604 50.5 45.0 36.3 297 37.7 379 50.4 58.9 66.9 715 69.5 608 531 40.6 36.5 313 32.8 45.5 428 57.4 66.5 714 68.7 640 527 379 33.9 38.5 36.4 38.7 46.5 58.8 621 728 70.7 SO4 440 322 36.4 421 460 556 64.8 73.5 693 513 480 Paste LEcopy Format Painter BIU Clipboard 5 Font F13 3 fx 314 312 33.0 323 408 50.7 58.4 68.9 75.0 718 650 53.8 43.9 35.0 33.1 36.0 37.5 52.9 58.2 D 480 36.9 36.4 410 42.9 512 610 67.4 74.7 73.0 63.1 49.6 314 312 33.0 32.3 40.8 50.7 584 68.9 705 75.0 B 108 2000 NOV 109 2000 DEC 110 2001 JAN 111 2001 FEB 112 2001 MAR 113 2001 APR 2001 MAY 115 2001 JUN 116 2001 JUL 117 2001 AUG 118 2001 SEP 119 2001 OCT 120 2001 NOV 121 2001 DEC 122 2002 JAN 123 2002 FEB 124 2002 MAR 125 2002 APR 126 2002 MAY 127 2002 JUN 128 2002 JUL 129 2002 AUG 130 2002 SEP 131 2002 OCT 132 2002 NOV 133 2002 DEC 2003 JAN 135 2003 FEB 136 2003 MAR 137 2003 APR 2003 MAY 139 2003 JUN 140 2003 JUL 141 2003 AUG 142 2003 SEP 14) 2003 OCT 2003 NOV 145 2003 DEC 2004 JAN 2004 FEB 148 2004 MAR 2004 APA 150 2004 MAY 151 2004 JUN 152 2004 JUL 153 2004 AUG 154 2004 SEP 155 2004 OCT 156 2004 NOV 157 2004 DEC 158 159 2005 FEB 160 2005 MAR 161 2005 APR 162 78.8 213 540 45.9 40.3 36.6 402 316 43.7 50.6 57.4 628 759 729 718 65.0 53.8 43.9 35.0 33.1 36.0 37.5 $2.9 562 70.5 574 390 36.4 354 33.6 482 432 599 62.7 632 86.4 76.8 713 64.0 45.9 40.3 36.6 40 2 316 437 50.6 57.4 62.0 759 72.9 SOS 574 33.0 513 397 365 355 379 420 33.6 482 492 539 576 Sheet1 Type here to search Clipboard Font F13 f E E 57.6 65.4 75.1 69.7 B 162 2005 MAY 163 2005 JUN 164 2005 JUL 165 2005 AUG 166 2005 SEP 167 2005 OCT 168 2005 NOV 169 2005 DEC 170 2006 JAN 171 2006 FEB 172 2006 MAR 173 2006 APR 174 2006 MAY 175 2006 JUN 176 2006 JUL 177 2006 AUG 178 2006 SEP 179 2006 OCT 180 2006 NOV 181 2006 DEC 182 2007 JAN 183 2007 FEB 184 2007 MAR 185 2007 APR 186 2007 MAY 187 2007 JUN 188 2007 JUL 189 2007 AUG 190 2007 SEP 191 2007 OCT 192 2007 NOV 193 2007 DEC 194 2008 JAN 195 2008 FEB 196 2008 MAR 197 2008 APR 198 2008 MAY 199 2008 JUN 200 2008 JUL 201 2008 AUG 202 2008 SEP 203 204 205 206 207 208 66.5 52.6 45.0 33.3 40.7 33.7 39.4 53.9 61.0 71.6 74.4 71.6 58.4 51.0 43.4 35.3 27.2 34.6 47.6 47.9 58.0 67.7 74.8 73.7 64.5 55.2 44.9 30.2 31.6 36.1 40.8 47.8 57.1 66.1 75.0 69.6 60.9 D 59.9 62.7 69.2 66.4 62.9 51.9 39.7 36.5 35.5 37.9 42.0 48.4 57.6 65.4 75.1 69.7 66.5 52.6 45.0 33.3 40.7 33.7 39.4 53.9 61.0 71.6 74.4 71.6 58.4 51.0 35.3 27.2 34.6 47.6 47.9 58.0 67.7 74.8 73.7 64.5

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions