Dec 15, 2020

Perform trend analysis on wave data

Identify trends over time by applying moving averages with just a few clicks.

In time series analysis, we want to be able to identify trends. As we collect data, random fluctuations can obfuscate a trend. Smoothing is an analytic process whereby we ‘iron out’ differences between time periods by taking the average of previous periods. This is also known as a moving average. You can now apply smoothing to your analyses with just a few clicks. In the smoothing tab accessed by clicking ⋮ select ‘One-sided moving average’ and choose the number of periods to ‘look back’ at each point.

For example, the following plots show the same data but the first shows the point estimates (unsmoothed) and the second shows a 4-period moving average.

This feature makes use of the new categorical date variable type which brings other advantages including the ability to give your own names to the date categories (“Quarter 1”, “Quarter 2” etc.).

Your chosen smoothing settings are saved with your analyses when you add them to your deck, and are then reflected in both exports (Excel and PowerPoint) and on dashboards. Table coloring and column comparison are not yet available for smoothed trend estimates.

For full details of this new feature and where to find it, see the help center.

We’d love your feedback at support@crunch.io.