On 2009 Jun 25, at 18:52 , Irv Bromberg wrote:
It would be neat to try fitting an appropriate curve, it looks quasi-sinusoidal, although that is not a built-in feature of Excel, my macro would have to carry out the fit.
Irv adds: A simple alternative would be to have the macro do a symmetrical moving average. Excel's moving average trendlines are forward only, so they always lag behind the data. A symmetrical moving average has the benefit of knowing the past and future, so can make each point the average of n points before and after itself, for lag-free smoothing. Perhaps the value of n could be a user-specified setting.
-- Irv Bromberg, Toronto, Canada
