Nov 27 2021 01:01 PM
I have a range of data. I want to create a forecast and have a seperate forecast for each day of the week. Monday, Tuesday e.c.t.
Nov 27 2021 02:30 PM
If you have Excel in Office 2016 or later or in Microsoft 365, you can use the FORECAST.ETS function.
If you specify 7 for the Seasonality argument, the function will take weekly variability into account.
If there is a clear weekly pattern, you can even omit this argument.