Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 01-25-2017, 12:12 PM
Bowzo Bowzo is offline Forecast Sheet Windows 10 Forecast Sheet Office 2016
Forecast Sheet
Join Date: Jan 2017
Posts: 1
Bowzo is on a distinguished road
Default 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?
Reply With Quote
Old 01-26-2017, 08:33 AM
gebobs gebobs is offline Forecast Sheet Windows 7 64bit Forecast Sheet Office 2010 64bit
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about

Here is what Microsoft says about the topic in this article about Forecast Sheet.

Seasonality is a number for the length (number of points) of the seasonal pattern and is automatically detected. For example, in a yearly sales cycle, with each point representing a month, the seasonality is 12. You can override the automatic detection by choosing Set Manually and then picking a number.

NOTE: When setting seasonality manually, avoid a value for less than 2 cycles of historical data. With less than 2 cycles, Excel cannot identify the seasonal components. And when the seasonality is not significant enough for the algorithm to detect, the prediction will revert to a linear trend.
Does that help at all?
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Forecast Sheet 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
Forecast Sheet Open an existing sheet by clicking on a cell in a master sheet darbybrown Excel 3 09-12-2016 05:12 PM
Forecast Sheet 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

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 07:29 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd. is not affiliated with Microsoft