Question: This is a group assignment to be done based on the groups for your course project. Make a forecast for Monday (11/8/21) through Friday (11/12/21)

This is a group assignment to be done based on

This is a group assignment to be done based on the groups for your course project.
Make a forecast for Monday (11/8/21) through Friday (11/12/21) based on the available 251 observations using the following techniques:
1) Use a four-day smoothing average
2) Use a four-day weighted average
3) Use an exponential smoothing function
4) Use an additive-seasonality-based function assuming these days are "seasons" (Monday, Tuesday, Wednesday, Thursday)
Compare all forecasting methods and choose which one you think is the best one for your data.
Show your working and explain what steps you followed and justify your decisions.
A B C D E F H I J K L M N O P R S 1 2 This is a group assignment to be done based on the groups for your course project. 3 4 Make a forecast for Monday (11/8/21) through Friday (11/12/21) based on the available 251 observations using the following techniques: 5 6 7 1) Use a four-day smoothing average 2) Use a four-day weighted average 3) Use an exponential smoothing function 4) Use an additive-seasonality-based function assuming these days are "seasons" (Monday, Tuesday, Wednesday, Thursday) 8 9 10 11 12 Compare all forecasting methods and choose which one you think is the best one for your data. Show your working and explain what steps you followed and justify your decisions. Do not discuss with students from other groups You may consult the book and/or slides to do this 13 14 15 16 17 18 Day Date Data 1 Monday 09/11/2020 121.99 2 Tuesday 10/11/2020 117.59 3 Wednesday 11/11/2020 119.63 4 Thursday 12/11/2020 120.53 5 Friday 13/11/2020 119.67 6 Monday 16/11/2020 120.99 7 Tuesday 17/11/2020 120.67 8 Wednesday 18/11/2020 119.82 9 Thursday 19/11/2020 119.06 10 Friday 20/11/2020 118.77 11 Monday 23/11/2020 117.62 12 Tuesday 24/11/2020 115.85 13 Wednesday 25/11/2020 116.75 14 Friday 27/11/2020 117.49 15 Monday 30/11/2020 120.97 16 Tuesday 01/12/2020 123.47 17 Wednesday 02/12/2020 123.37 18 Thursday 03/12/2020 123.78 19 Friday 04/12/2020 122.86 20 Monday 07/12/2020 124.57 21 Tuesday 08/12/2020 124.98 22 Wednesday 09/12/2020 125.95 23 Thursday 10/12/2020 123.87 24 Friday 11/12/2020 122.76 25 Monday 14/12/2020 123.35 26 Tuesday 15/12/2020 127.9 27 Wednesday 16/12/2020 128.37 28 Thursday 17/12/2020 129.58 19 20 21 22 23 24 25 26 27 28 29 A B C D E F H I J K L M N O P R S 1 2 This is a group assignment to be done based on the groups for your course project. 3 4 Make a forecast for Monday (11/8/21) through Friday (11/12/21) based on the available 251 observations using the following techniques: 5 6 7 1) Use a four-day smoothing average 2) Use a four-day weighted average 3) Use an exponential smoothing function 4) Use an additive-seasonality-based function assuming these days are "seasons" (Monday, Tuesday, Wednesday, Thursday) 8 9 10 11 12 Compare all forecasting methods and choose which one you think is the best one for your data. Show your working and explain what steps you followed and justify your decisions. Do not discuss with students from other groups You may consult the book and/or slides to do this 13 14 15 16 17 18 Day Date Data 1 Monday 09/11/2020 121.99 2 Tuesday 10/11/2020 117.59 3 Wednesday 11/11/2020 119.63 4 Thursday 12/11/2020 120.53 5 Friday 13/11/2020 119.67 6 Monday 16/11/2020 120.99 7 Tuesday 17/11/2020 120.67 8 Wednesday 18/11/2020 119.82 9 Thursday 19/11/2020 119.06 10 Friday 20/11/2020 118.77 11 Monday 23/11/2020 117.62 12 Tuesday 24/11/2020 115.85 13 Wednesday 25/11/2020 116.75 14 Friday 27/11/2020 117.49 15 Monday 30/11/2020 120.97 16 Tuesday 01/12/2020 123.47 17 Wednesday 02/12/2020 123.37 18 Thursday 03/12/2020 123.78 19 Friday 04/12/2020 122.86 20 Monday 07/12/2020 124.57 21 Tuesday 08/12/2020 124.98 22 Wednesday 09/12/2020 125.95 23 Thursday 10/12/2020 123.87 24 Friday 11/12/2020 122.76 25 Monday 14/12/2020 123.35 26 Tuesday 15/12/2020 127.9 27 Wednesday 16/12/2020 128.37 28 Thursday 17/12/2020 129.58 19 20 21 22 23 24 25 26 27 28 29

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!