Forecast the closing stock price on October, 25 for the following company (or whatever the next trading day is after your last day of actual data). That is to say, if your last day of actual data is October 19, then you will forecast for October 20). Use the Weighted Moving Average method. You will also need to calculate the Mean Squared Error (MSE).

You choose how many previous days of trading to use in creating your averages.

You will decide the number of trading days to average.

Also, you will decide how much weight to assign to each event. You can assign weights to as many trading days as you want. That is to say, you can have an 8-day weighted average, or a 20-day weighted average, etc.

Please use excel and post screen shots of how these looks in your excel spreadsheet.

Currency in USD Download Date Open High Low Close Adj Close Volume Oct 25, 2021 239.23 239.24 236.56 238.00 238.00 2,023,482 Oct 22, 2021 240.71 242.24 238.00 238.44 238.44 3,282,900 Oct 21, 2021 240.17 241.91 239.31 241.40 241.40 2,702,400 Oct 20, 2021 240.40 242.65 239.29 239.72 239.72 3,040,200 Oct 19, 2021 243.22 243.93 241.53 242.77 242.77 2,071,600 Oct 18, 2021 242.42 243.45 241.13 242.26 242.26 2,484,900 Oct 15, 2021 245.24 246.38 241.99 242.25 242.25 2,564,700 Oct 14, 2021 242.88 245.42 242.04 244.55 244.55 2,512,000 Oct 13, 2021 243.27 243.87 239.90 242.65 242.65 3,214,300 Oct 12, 2021 247.73 248. 244.18 244.52 244.52 2,346, Oct 11, 2021 248.10 249.14 246.45 246.58 246.58 1,504.000 Oct 08, 2021 249.25 249.63 247.11 247.70 247.70 1,687,500 Oct 07, 2021 248.00 249.95 247.68 248.32 248.32 2,423,900 Oct 06, 2021 244.56 247.16 243.02 247.10 247.10 2,107,900 Oct 05, 2021 243.97 246.88 243.01 245.22 245.22 2,463,100 Oct 04, 2021 242.06 244.81 241.86 243.08 243.08 2,236,500 Oct 01, 2021 243.07 244.69 240.25 242.93 242.93 2,076,000 Currency in USD Download Date Open High Low Close Adj Close Volume Oct 25, 2021 239.23 239.24 236.56 238.00 238.00 2,023,482 Oct 22, 2021 240.71 242.24 238.00 238.44 238.44 3,282,900 Oct 21, 2021 240.17 241.91 239.31 241.40 241.40 2,702,400 Oct 20, 2021 240.40 242.65 239.29 239.72 239.72 3,040,200 Oct 19, 2021 243.22 243.93 241.53 242.77 242.77 2,071,600 Oct 18, 2021 242.42 243.45 241.13 242.26 242.26 2,484,900 Oct 15, 2021 245.24 246.38 241.99 242.25 242.25 2,564,700 Oct 14, 2021 242.88 245.42 242.04 244.55 244.55 2,512,000 Oct 13, 2021 243.27 243.87 239.90 242.65 242.65 3,214,300 Oct 12, 2021 247.73 248. 244.18 244.52 244.52 2,346, Oct 11, 2021 248.10 249.14 246.45 246.58 246.58 1,504.000 Oct 08, 2021 249.25 249.63 247.11 247.70 247.70 1,687,500 Oct 07, 2021 248.00 249.95 247.68 248.32 248.32 2,423,900 Oct 06, 2021 244.56 247.16 243.02 247.10 247.10 2,107,900 Oct 05, 2021 243.97 246.88 243.01 245.22 245.22 2,463,100 Oct 04, 2021 242.06 244.81 241.86 243.08 243.08 2,236,500 Oct 01, 2021 243.07 244.69 240.25 242.93 242.93 2,076,000