Why HoltWinters Forecast returns null?

DylanZZZ
DylanZZZ New Altair Community Member
edited November 5 in Community Q&A
Simple Process


Only one attribute with no missing


Param of Holt-Winters


Param of Apply Forecast


However, it gives nan prediction


What happens??
Tagged:

Answers

  • DylanZZZ
    DylanZZZ New Altair Community Member
    I have figured out. That's because there are zeros in data. So, how to train model with zero value?
  • YYH
    YYH
    Altair Employee
    Hi @DylanZZZ,

    Glad to see you figured out by your self. The trick to handle zeros could be, re-scale data and add a small "error" to every example. For instance, using the formula

    b0*10+0.01   ------>> b0'

    to transform your original input b0, and make all zeros become 0.01 or even smaller (anything > 0 works).

    You will forecast the new re-scaled value, and inverse it back using (b0' - 0.01)/10

    Hope it helps.

    YY
  • David_A
    David_A New Altair Community Member

    I think the problem in your case is a combination of a very short seasonality value (are you sure about this, it would mean you have a pattern of length two in your data) and the zero values. In that case you will get segments in the model training, where very likely a division by zero or something similar happens.

    Best,
    David

Categories