MA for three years is calculated by using the average function in Excel; similarly, MA for seven-year is calculated. The exponential moving average for (W = .25) is calculated by giving 0.25 weight to the sales and 0.75 to the value obtained by the exponential average. While ESV at 0.5 ...