Home

Issues with Timeline for FORECAST.EST

%3CLINGO-SUB%20id%3D%22lingo-sub-721896%22%20slang%3D%22en-US%22%3EIssues%20with%20Timeline%20for%20FORECAST.EST%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-721896%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20having%20issues%20when%20using%20the%20FORECAST.EST%20function.%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20forecast%20something%20on%20a%20daily%20basis%20within%20a%20month%20and%20I%20would%20want%20to%20base%20my%20forecast%20on%20data%20for%20the%20same%20month%20in%20previous%20years.%20For%20example%2C%20I%20want%20to%20forecast%20the%20data%20for%20every%20day%20of%20the%20month%20of%20June%20using%20the%20daily%20data%20of%20June%20for%20previous%20years.%3C%2FP%3E%3CP%3EI%20think%20the%20issue%20with%20this%20is%20rooted%20in%20the%20fact%20that%20the%20function%20does%20not%20recognise%20a%20constant%20time%20interval%20since%20there%20is%20a%20daily%20step%20within%20the%20month%20itself%20but%20the%20months%20are%20separated%20by%20a%20whole%20year.%3C%2FP%3E%3CP%3EAnyone%20has%20any%20recommendation%20on%20how%20to%20get%20around%20this%20issue%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-721896%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
jamesdoe735
Frequent Visitor

Hello everyone,

 

I am having issues when using the FORECAST.EST function.

I am trying to forecast something on a daily basis within a month and I would want to base my forecast on data for the same month in previous years. For example, I want to forecast the data for every day of the month of June using the daily data of June for previous years.

I think the issue with this is rooted in the fact that the function does not recognise a constant time interval since there is a daily step within the month itself but the months are separated by a whole year.

Anyone has any recommendation on how to get around this issue?