Question: how to do ewma in excel?
Answer: To calculate an exponentially smoothed moving average, first click the Data tab's Data Analysis command button. When Excel displays the Data Analysis dialog box, select the Exponential Smoothing item from the list and then click OK. Excel displays the Exponential Smoothing dialog box. Identify the data.