Average of above 'n' values if a null is encountered

[arpitkhurana]

Hi, 

I am trying to insert a column where if a null value is encountered , it automatically takes an average of above ‘n’ values:

So, in this scenario 

The highlighted yellow should generate an average of (1.3 and 0.7) if the value is null otherwise the value (1.3/0.7)