I cant thank you enough for this tutorial. It is clear and well explained. I was able to understand the Linear Interpolation and how to apply using Excel application. Without the instruction, I almost calculate the missing value in a 500 rows dataset manually based on a equation.
if anyone can help, my forecast column is never showing more than one value consecutively, even where there are three values missing in a row. always just the last one that shows