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:
Calculates the average of the values as a constant value.
Calculates the middle value in sorted list of values as a constant.
Calculates the trend as a line fitted using a linear regression.
Calculates the specified percentile of the range as a constant.
Calculates the lowest value as a constant.
Calculates the highest value as a constant.
Calculates the trend as a line fitted using a linear regression on the logarithm of the data
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.
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.
In this example, we calculated the means of the CAPE Shiller Index in two time windows with +1 / -1 standard deviation bands around them.
Here, we calculated the average growth rate per decade for the US GDP.
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.
Using the log of the real US GDP, we calculated two linear trends: one between 2000 and 2006, and another from 2009.