Statistics

Overview

With the Statistics analysis, you can calculate statistical measures for specific series on a time range that you define. This analysis differs from the Cross section analysis, which calculates statistical measures across a group of series at each point in time. Use it when you want to add one of these measures to a chart:

Mean

Calculates the average of the values as a constant value.

Median

Calculates the middle value in sorted list of values as a constant.

Trend

Calculates the trend as a line fitted using a linear regression.

Percentile

Calculates the specified percentile of the range as a constant.

Min

Calculates the lowest value as a constant.

Max

Calculates the highest value as a constant.

Exponential trend

Calculates the trend as a line fitted using a linear regression on the logarithm of the data

Line

Calculates a straight line between two data points that you specify: the start and the end date of the range. If no dates are specified as start / end range, the first / last value of the range will be used.

It differs from the Cross section analysis, which calculates statistical measures across a group of series at each point in time.

Settings

For each calculation in statistics, you can:

  • Set the Date range in which the calculation is performed.
  • Select Extrapolate to extend the graph of the calculated output outside of the date range that you set.
  • Add a Standard deviation band and adjust its Coefficient.
    • The Coefficient defines the number of standard deviations from the mean that will be included in the confidence interval. The coefficient is the percentage of values that should fall within the boundary of the confidence interval assuming normally distributed data.

Examples

Mean and standard deviations

In this example, we calculated the means of the CAPE Shiller Index in two time windows with +1 / -1 standard deviation bands around them.

Mean per decade

Here, we calculated the average growth rate per decade for the US GDP.

Line in Statistics

We used the line statistic to draw a straight line between two data points. We chose to extrapolate the lines backwards and forwards in time.

Trend line

Using the log of the real US GDP, we calculated two linear trends: one between 2000 and 2006, and another from 2009.