FREE Trial
Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Im working on a practice homework assignment. I dont understand this section. I tried doing a moving average in Excel but it wasn't correct. Question

Im working on a practice homework assignment. I dont understand this section. I tried doing a moving average in Excel but it wasn't correct.

Question 1:

Use the variable Green Beans to forecast the number of green beans for month 169 using a five-month moving average. What is the forecast for month 169? Round your answer to 1 decimal place.

Question 2:

Use the variable Green Beans to forecast the number of green beans for month 169 using an exponential smoothing constant, = 0.6. What is the forecast for month 169? Round your answer to 1 decimal place.

Question 3:

Use the variable Green Beans to forecast the number of green beans using a 5-month moving average and a model with an exponential smoothing constant, = 0.6 . Which model produces a more accurate forecast - the five month moving average (Forecast A) or the exponential smoothing constant, = 0.6 (Forecast B)? Use the MSE to support your answer.

A. Forecast A because the MSE is lower. B. Forecast A because the MSE is higher. C. Forecast B because the MSE is lower.

D. Forecast B because the MSE is higher.

Month GreenBeans Broccoli Carrots Corn Onions GrnPeas TotVegs
1 184336 61415 169022 471423 30289 193721 1675598
2 147677 62099 155202 405031 29870 151250 1463357
3 124821 71027 141133 341149 26479 118599 1311003
4 103125 78708 121945 280675 22433 102494 1226398
5 80031 91997 110867 212140 20237 82478 1094891
6 81518 100281 106260 164356 21218 126417 1081974
7 123193 120458 96669 124541 22609 311332 1310713
8 263758 121500 88959 292598 21228 386200 1755657
9 260146 111292 92348 557510 19365 364715 2030721
10 234632 96597 131302 582181 20327 325270 2070681
11 208237 89708 166230 527734 23773 286696 1986389
12 189759 92757 163749 474726 23437 252861 1857392
13 158418 88626 154464 403480 23843 208957 1645455
14 135750 91122 142100 353309 24282 175712 1489574
15 111393 89571 128094 301441 25406 145141 1333747
16 94549 97859 117083 237033 22059 132368 1249413
17 76863 112532 105650 187099 20107 120333 1188015
18 75177 133257 96060 143053 19304 228352 1269518
19 142850 136407 93494 120475 25823 429052 1565296
20 236556 139469 94671 315192 27407 457145 1954127
21 249682 121990 93574 574891 23271 431648 2238029
22 219228 107326 139982 616876 25598 385900 2299599
23 196034 86992 194817 564899 28714 353382 2204174
24 171884 79402 180809 510603 27434 314974 2021944
25 150779 80134 163938 450699 27166 277296 1828771
26 129530 89260 147623 383096 29640 242928 1678130
27 108632 87152 143909 316787 30944 208615 1516676
28 93087 74884 123996 260590 32586 185085 1392251
29 78399 80195 113702 210631 34530 164019 1281053
30 71150 105760 103190 162571 34235 227592 1300882
31 130649 123028 92705 136995 36241 307374 1436921
32 231016 144299 89619 324013 36391 396948 1886999
33 237804 135592 95700 565815 33142 355786 2133405
34 221846 125584 164525 606821 34850 317676 2265932
35 200997 118320 210759 545706 35756 284148 2161280
36 182613 105146 208728 490756 35715 249865 1977572
37 153198 91614 180950 416844 35389 212529 1751085
38 129225 95128 164038 353677 33032 185479 1560205
39 108630 93707 149165 297984 31697 155489 1412098
40 94416 95408 136827 251429 28118 141815 1330022
41 79158 111357 125852 195551 25536 131779 1220258
42 74180 137154 116757 140051 23939 233334 1260134
43 150302 152291 112584 167379 29586 376407 1571205
44 238716 159858 109293 375438 30209 706658 1982656
45 252750 161822 113327 669962 26665 386815 2341266
46 233453 151994 179629 664924 28782 342137 2403869
47 208994 133645 234124 629261 29806 302126 2327508
48 182898 114814 214380 566546 29570 251150 2098396
49 159966 102540 194693 502563 27509 211300 1888724
50 137845 107348 178007 436894 28116 168127 1684048
51 112011 97271 158211 357774 28155 128554 1479938
52 92054 96840 143685 296900 28025 107739 1353418
53 74526 111155 138581 233702 29954 97626 1278499
54 59839 120012 114510 184229 29062 162651 1258687
55 92882 120922 116285 128242 31692 264341 1337218
56 188295 118633 95262 284705 36339 313091 1673607
57 203871 97305 84809 524324 32507 282612 1880576
58 195770 81813 130033 567743 31789 248017 1933669
59 172487 67446 190497 497825 33002 201647 1836251
60 146418 56169 183128 435493 33388 166799 1671706
61 119449 53233 166347 374472 33313 133165 1475678
62 99720 65455 151741 314692 36867 114540 1318569
63 73778 78257 147028 245687 34585 80480 1161640
64 57434 80795 133061 188376 34721 74844 1068674
65 40918 103372 123300 136634 40848 62448 1002194
66 38204 116303 114264 93628 36854 133084 1022314
67 104744 128770 106894 60805 42315 284476 1245233
68 211443 151140 93432 210452 38311 325896 1578852
69 283175 135751 90276 483020 44068 327649 1979305
70 258051 127356 130373 568963 43846 300740 2155482
71 231991 120234 211158 511018 42072 265944 2081035
72 207702 106004 208500 462414 39648 232114 1956785
73 177110 116129 194195 401684 38725 197410 1778136
74 149802 123830 180216 338204 36748 165302 1588909
75 124896 138544 168110 295838 35695 119773 1450234
76 106506 164389 158097 244493 33230 107616 1397673
77 96501 181561 143283 191568 30769 98956 1321074
78 85694 196395 138266 139146 32014 218958 1404030
79 156221 210118 125585 111171 35950 413403 1696248
80 287056 204656 122481 307911 33886 437365 2073913
81 330800 192088 126815 676920 31988 417208 2545393
82 301270 162166 182680 699124 33325 362312 2586733
83 273872 136046 232814 633718 34941 315518 2466661
84 253184 113014 224533 579399 34421 282118 2303101
85 222082 107294 202694 518877 36167 234034 2109261
86 191636 136764 176385 465809 36459 201735 1950384
87 176013 136915 151591 426077 36549 168901 1810684
88 145535 134645 137665 375307 35940 146478 1669925
89 124352 131359 119606 308407 34533 133028 1504886
90 113486 137670 109649 233433 31049 220022 1483732
91 187132 136079 96429 210899 32275 406273 1727285
92 328410 132957 98618 444695 35116 451617 2175708
93 361060 119351 109655 820778 36925 400277 2592826
94 313380 102721 180715 824066 37545 355040 2648618
95 284483 94708 222716 749640 34251 315536 2502411
96 248737 88286 203637 636611 32137 272691 2243853
97 229513 98870 180664 595286 35681 238366 2080245
98 209327 114090 152978 530496 36179 201369 1884819
99 180431 127015 135581 478094 31748 160818 1716314
100 154790 138692 118738 424181 30713 141696 1597045
101 135005 141116 112724 355393 30004 148226 1507794
102 116360 150460 99743 285023 27829 229461 1498044
103 183040 144815 94793 250047 30314 411157 1704801
104 253331 140387 89398 500440 33420 436219 2065984
105 250742 136389 108672 792322 35545 430295 2408558
106 231844 140925 194675 800889 36590 400527 2529992
107 207878 142915 266063 727834 36141 354397 2488787
108 190465 143486 254040 657244 34230 305164 2300040
109 172659 145772 241850 598082 36006 282204 2164133
110 150960 155640 233008 526900 32925 236853 1964942
111 129729 167419 220388 437650 30951 181963 1736325
112 103921 186629 211242 371769 26896 157756 1633520
113 87548 194850 192585 306034 23722 139168 1499880
114 73907 194061 176830 239379 24787 177245 1405764
115 127207 183269 150697 188956 31854 337127 1547426
116 226162 171776 143622 319008 34885 384616 1837230
117 258410 168874 165680 559386 33618 336661 2102450
118 217852 150053 212873 660021 33758 303591 2217306
119 213348 142011 269674 570470 37814 286844 2182492
120 184418 134774 260993 493411 36101 261338 2015892
121 166632 133718 251052 424488 36981 204967 1835782
122 137737 133612 242414 359076 32682 158494 1648986
123 118908 133725 224824 283677 31787 123163 1475347
124 95360 147594 201787 220833 30180 102178 1351208
125 77110 157328 184449 165963 30087 98583 1300136
126 71457 152312 165748 119206 31296 218032 1392227
127 151051 161847 152636 123742 40808 388372 1644196
128 269075 153731 147465 384257 45066 397667 2056994
129 306632 135150 155788 725717 48703 380828 2450277
130 275252 120907 223746 765957 53304 338066 2510157
131 247042 120153 285179 707070 53606 304370 2464853
132 224681 109076 271144 645985 51244 260487 2288336
133 202515 112677 252893 539748 49451 213833 2060675
134 161518 110572 247507 481369 50696 192588 1915525
135 143916 103021 219721 403953 50354 149012 1747546
136 114495 114541 213758 331371 44833 127733 1586519
137 99028 115458 195108 262245 45317 119577 1471118
138 87436 110075 176054 199148 42810 219669 1422141
139 156197 127892 165649 188498 42642 389209 1698436
140 269042 119435 169871 436436 41472 394943 2128705
141 297034 114491 165004 722507 43882 363326 2430902
142 268790 116933 231641 795086 47184 341652 2546324
143 241566 126954 313487 722880 48112 304928 2508131
144 224297 136850 307645 648994 48761 281349 2390428
145 192814 132466 283349 584206 47384 245525 2147243
146 172568 164788 264065 491557 44776 208558 2005765
147 148658 141189 236568 386402 45081 163820 1722152
148 121526 133798 221813 329161 38699 147794 1575170
149 92856 138354 188167 259394 40141 133570 1461402
150 80224 150883 177248 215553 38342 163293 1422893
151 135849 146630 155417 188235 36063 279556 1525796
152 250870 146869 160470 332015 36830 324942 1901353
153 282133 138703 187579 716876 39007 305164 2371993
154 255912 128033 237272 828144 36743 277076 2497311
155 227381 112411 297498 735731 42786 243530 2388041
156 202607 120971 281791 645424 40521 208357 2185704
157 178636 104939 245683 565536 40313 174706 1946880
158 148003 99259 234040 488724 43512 144706 1749512
159 128520 102002 217999 415156 42048 111692 1553441
160 112655 122430 201629 333871 37328 95440 1461895
161 94363 112136 167777 264536 36141 73375 1312012
162 84908 108415 162170 203727 37813 137612 1317133
163 156250 118967 149864 164694 40762 300102 1529711
164 273944 119041 159784 436734 36335 321298 1988991
165 296589 114943 173249 723876 36084 339697 2390139
166 283497 106043 245751 798943 40116 306008 2509258
167 255806 111652 328015 746964 41320 249048 2496122
168 230661 112311 300870 677839 42218 219533 2303007

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Time Series Analysis With Applications In R

Time Series Analysis With Applications In R

Authors: Jonathan D Cryer, Kung Sik Chan

2nd Edition

038775959X, 9780387759593

More Books

Students also viewed these Mathematics questions

Question

★★★★★
(a) What is the potential difference Vad in the circuit of Fig? (b) What is the terminal voltage of the 4.00-V battery? (c) A battery with emf 10.30z V and internal resistance 0.50 0 is inserted in...

Answered: 1 week ago

Question

★★★★★
4. Why is the pooling of interest method eliminated while accounting for a business combination?

Answered: 1 week ago

Question

★★★★★
What Makes Machine Learning Projects Unique in HR

Answered: 1 week ago

Question

★★★★★
The trial balance of the Estate of Tom Beresford at April 17, 200X is as follows Debit (Credit) Principal cash ............$20,750 GM Stock ................$50,000 GMAC Bonds .............$100,000...

Answered: 1 week ago

Question

★★★★★
Lauren is attending her middle school graduation. She has $75,000 in the bank account and is hoping this will be enough to pay for her college. She calculates that she needs to have $110,000 by the...

Answered: 1 week ago

Question

★★★★★
1. Why do you think the regions are not responding to Wilkess initiative for change? What did Wilkes do wrong with respect to implementing the change? 2. Should Wilkes solicit more active support...

Answered: 1 week ago

Question

★★★★★
1. Social Circle Publications Inc. is considering two new magazine products. The estimated net cash flows from each product are as follows: Year Sound Cellar Pro Gamer 1 $ 65,000 $ 70,000 2 60,000...

Answered: 1 week ago

Question

★★★★★
The production records of Prince Company for the month of June shows the following: Total Manufacturing Cost Variance P 3,840 U Rate Variance 8,710 F Total material cost variance 2,975 U Total Labor...

Answered: 1 week ago

Question

★★★★★
Based on the facts, what is the primary ethical issue in this case? Who are the stakeholders? What changes could have been made to impact the outcome of this fraud? Research recent developments in...

Answered: 1 week ago

Question

★★★★★
MDM4U EXAM REVIEW 1. Consider the arrangement of the name TISHAN a. How many arrangements are there in total? b. How many begin with N? c. How many begin with a vowel? 2. Consider forming 7 digit...

Answered: 1 week ago

Question

★★★★★
A cake maker has determined that the cost of producing wedding cakes is $61.50 per wedding cake plus $16620 per month in fixed costs. The cake maker sells each wedding cake for $200. Step 4 of 4:...

Answered: 1 week ago

Question

★★★★★
Write a dialogue of what you would say to your sellers when presenting to them your marketing recommendations. 1- Give your recommendations based on maximum market (buyer) reach and appropriate...

Answered: 1 week ago

Question

★★★★★
circle the answers plz i don't want to get wrong answer pleas do step by step and circle the answers and label the Q do all the parts for each Q thank you Objective 1: Determine and Interpret...

Answered: 1 week ago

Question

★★★★★
6. How great is the time-lag between when an event occurs until we get information about it?

Answered: 1 week ago

Question

★★★★★
1. Build trust and share information with others.

Answered: 1 week ago

Question

★★★★★
11. What types of information collected are most frequently used in decision-making?

Answered: 1 week ago

Previous Question Next Question