#1
|
|||
|
|||
Forecast Sheet
I am doing a time series forecast via the Forecast Sheet and I have a question regarding seasonality. Under "Detect Automatically", which is the default, how is seasonality automatically determined? If my time series is at a consistent interval of 2 weeks, is Excel reading it as 14 days or the number of bi-weekly subsets exist before the next time series? |
#2
|
|||
|
|||
Here is what Microsoft says about the topic in this article about Forecast Sheet.
Quote:
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to copy excel sheet withe HEADER and Paste into new sheet? | cloudforgiven | Excel Programming | 6 | 01-05-2017 07:30 PM |
Help please - billing and cost forecast model | dee38 | Excel | 0 | 10-26-2016 09:43 AM |
Open an existing sheet by clicking on a cell in a master sheet | darbybrown | Excel | 3 | 09-12-2016 05:12 PM |
how to forecast repeating monthly expenses entry | Richard1970 | Excel | 3 | 04-22-2016 06:53 PM |
Populate sheet 3 with data from sheet 1 and sheet 2 | speck | Excel Programming | 0 | 01-14-2015 07:54 AM |