I would like to forecast the values for each X variable for each Group. There is 5 years worth of data for Groups A-D, Group E has 2 years worth of data. Regardless, I would like to forecast values for August 31, 2018. Can you do this in Powerquery or Powerpivot?
I have been using the Forecast Sheet function in Excel 2016 for a quick time series forecast, however in the example below, I have multiple groups and multiple X variables.
Any advice appreciated. Thank you.
<tbody>
</tbody>
I have been using the Forecast Sheet function in Excel 2016 for a quick time series forecast, however in the example below, I have multiple groups and multiple X variables.
Any advice appreciated. Thank you.
Group | Cycle | X1 | X2 | X3 | X4 | X5 |
A | 2013-08-31 | 31.00 | 40.50 | 32.20 | 3.30 | 21.90 |
A | 2014-08-31 | 25.00 | 40.90 | 32.40 | 7.30 | 18.50 |
A | 2015-08-31 | 18.00 | 52.40 | 50.00 | 17.30 | 26.10 |
A | 2016-08-31 | 20.00 | 44.90 | 42.30 | 18.00 | 22.30 |
A | 2017-08-31 | 20.00 | 33.90 | 30.60 | 6.00 | 20.60 |
B | 2013-08-31 | 7.00 | 2.00 | 2.00 | 0.00 | 2.00 |
B | 2014-08-31 | 2.00 | 6.00 | 7.00 | 2.00 | 3.00 |
B | 2015-08-31 | 3.00 | 5.00 | 6.00 | 0.00 | 6.00 |
B | 2016-08-31 | 5.00 | 5.00 | 5.00 | 1.00 | 4.00 |
B | 2017-08-31 | 3.00 | 0.00 | 0.00 | 0.00 | 0.00 |
C | 2013-08-31 | 10.00 | 29.00 | 20.00 | 7.00 | 9.00 |
C | 2014-08-31 | 10.00 | 27.00 | 13.00 | 3.00 | 10.00 |
C | 2015-08-31 | 10.00 | 20.00 | 14.00 | 4.00 | 10.00 |
C | 2016-08-31 | 10.00 | 25.00 | 20.00 | 10.00 | 10.00 |
C | 2017-08-31 | 10.00 | 20.00 | 13.00 | 4.00 | 9.00 |
D | 2013-08-31 | 28.00 | 123.00 | 47.00 | 19.00 | 28.00 |
D | 2014-08-31 | 28.00 | 109.00 | 55.00 | 29.00 | 20.00 |
D | 2015-08-31 | 30.00 | 116.00 | 51.00 | 22.00 | 29.00 |
D | 2016-08-31 | 30.00 | 111.00 | 42.00 | 20.00 | 22.00 |
D | 2017-08-31 | 27.00 | 116.00 | 42.00 | 26.00 | 14.00 |
E | 2016-08-31 | 16.00 | 29.20 | 22.60 | 3.00 | 15.60 |
E | 2017-08-31 | 20.00 | 45.70 | 31.60 | 7.30 | 18.30 |
<tbody>
</tbody>