Question: how to calculate the weighted moving average 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.