Question
The moving average is calculated ignoring the missing values. Is there a way to calculate the moving average including missing values?
e.g.) If some data is missing as shown below, If you set the moving average for the previous 3 days, the calculated result on Jan 4 is 150 ( = (100+200+150) / 3) while the assumed result is 112.5 ( = (100+200+150+0) / 4).