(ending_value/starting_value)^(1/num_periods-1)-1."
This is actually the formula for compound monthly growth rate, a modification of the commonly used compound annual growth rate (CAGR), with an extra -1 thrown in after num_periods. The correct formula for compound growth is:
(ending_value / starting_value) ^ (1 / num_periods) - 1
T6m(x) = 1/6 * sum(x[1], x[2],..., x[6])
This is actually the formula for compound monthly growth rate, a modification of the commonly used compound annual growth rate (CAGR), with an extra -1 thrown in after num_periods. The correct formula for compound growth is:
The T6m average is the arithmetic average of, surprise, the last six months: where x is a vector of the last 6 months' data (sales, users, etc.). The T6m average will be in the same unit as the monthly figures, not percentages.