Weight Multiplier = K = 2/(n+1) where n = period Calculate the weighting multiplier using this equation: 212+1=0.1538\frac{2}{12+1}= 0.153812+12 =0.1538 Calculate the 12 EMA sequentially as ...

You will get your result. Read: How to calculate Median in Excel. To calculate EMA, we should have the first EMA value, which we get by calculating the SMA and the weight multiplier or smoothing ...