|Depending on the nature of the quantitative data you are investigating, different trend lines may be more appropriate at representing patterns. The platform allows you to choose the method in which trend lines are calculated.|
To access trend line options:
1. Navigate to a column chart such as the Happiness analytics dashboard.
2. Hover over the column chart to see options appear on the right side of the chart, including the trend line graph and chart settings.
3. Select the trend line graph to turn the trend line off.
4. Select the chart settings to customise the type of trend line used on the graph.
5. You can select a Moving Average, Linear Regression or Polynomial Regression.
6. You can also choose the period the trend line is calculated on (such as every three months).
Types of Trendlines:
Moving Average: is used to show a trend by averaging sets of data points together. It works by creating a rolling average across the specified number of data points to form each point of the trendline. For example, if the period is set to 2 then the line will be drawn as follows:
Linear Regression: is a straight line drawn to fit your data set. It will help identify trends in the data set where the data points are increasing or decreasing over time consistently.
Polynomial Regression: is useful when the data set has a curved trend rather than a straight line. This can be helpful for drawing a trendline over a cycle of highs and lows.