Forum Discussion
Does FORECAST.ETS.SEASONALITY work for anyone?
In Excel 2016 Windows or Mac: has anyone been able to get the FORECAST.ETS.SEASONALITY function to return anything other than zero? I've tried this function on several sets of data, some with very ob...
Hi Bob,
I'm not a specialist in this area, just checked the file which could be downloaded from this support page https://support.office.com/en-US/article/FORECAST-ETS-SEASONALITY-function-32a27a3b-d22f-42ce-8c5d-ef3649269f3c. On that sample data the function returns something different from zero.
After that i simply added few points to your dataset, and it shows now 12 instead of zero. It looks like timeline shall have at least 30 points.
Again, i have no idea what's the logic behind.