(a) Make a line chart for an m-period moving average to the exchange rate data shown below with m = 2, 3, 4, and 5 periods. For each method, state the last MA value. (Round your answers to 4 decimal places.)m-period Next period forecast2:3:4:5:DateRate1-Nov1.29504-Nov1.29065-Nov1.28706-Nov1.28727-Nov1.28298-Nov1.279012-Nov1.285513-Nov1.284014-Nov1.287915-Nov1.290118-Nov1.296519-Nov1.292620-Nov1.291821-Nov1.291522-Nov1.282925-Nov1.288526-Nov1.285027-Nov1.288129-Nov1.29392-Dec1.29363-Dec1.30024-Dec1.30955-Dec1.31656-Dec1.31279-Dec1.315710-Dec1.317811-Dec1.317612-Dec1.313313-Dec1.334916-Dec1.333017-Dec1.311618-Dec1.307819-Dec1.303420-Dec1.303623-Dec1.291724-Dec1.295526-Dec1.300727-Dec1.309030-Dec1.314031-Dec1.32692-Jan1.31283-Jan1.30916-Jan1.31637-Jan1.31278-Jan1.31109-Jan1.306910-Jan1.306013-Jan1.298314-Jan1.301815-Jan1.301616-Jan1.300217-Jan1.306621-Jan1.303822-Jan1.308623-Jan1.301824-Jan1.309227-Jan1.300028-Jan1.306729-Jan1.307530-Jan1.2988

Moving averages are used to forecast the value of next period using the data of past periods.…

Answered: (a) Make a line chart for an m-period…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Related questions

Question

(a) Make a line chart for an m-period moving average to the exchange rate data shown below with m = 2, 3, 4, and 5 periods. For each method, state the last MA value. (Round your answers to 4 decimal places.)

m-period Next period forecast

Date	Rate
1-Nov	1.2950
4-Nov	1.2906
5-Nov	1.2870
6-Nov	1.2872
7-Nov	1.2829
8-Nov	1.2790
12-Nov	1.2855
13-Nov	1.2840
14-Nov	1.2879
15-Nov	1.2901
18-Nov	1.2965
19-Nov	1.2926
20-Nov	1.2918
21-Nov	1.2915
22-Nov	1.2829
25-Nov	1.2885
26-Nov	1.2850
27-Nov	1.2881
29-Nov	1.2939
2-Dec	1.2936
3-Dec	1.3002
4-Dec	1.3095
5-Dec	1.3165
6-Dec	1.3127
9-Dec	1.3157
10-Dec	1.3178
11-Dec	1.3176
12-Dec	1.3133
13-Dec	1.3349
16-Dec	1.3330
17-Dec	1.3116
18-Dec	1.3078
19-Dec	1.3034
20-Dec	1.3036
23-Dec	1.2917
24-Dec	1.2955
26-Dec	1.3007
27-Dec	1.3090
30-Dec	1.3140
31-Dec	1.3269
2-Jan	1.3128
3-Jan	1.3091
6-Jan	1.3163
7-Jan	1.3127
8-Jan	1.3110
9-Jan	1.3069
10-Jan	1.3060
13-Jan	1.2983
14-Jan	1.3018
15-Jan	1.3016
16-Jan	1.3002
17-Jan	1.3066
21-Jan	1.3038
22-Jan	1.3086
23-Jan	1.3018
24-Jan	1.3092
27-Jan	1.3000
28-Jan	1.3067
29-Jan	1.3075
30-Jan	1.2988