Analytics
Growth Rate Calculator
Growth rate between two values, and the average (compound) growth per period across several periods.
Total = end ÷ start − 1
Also called percent growth · growth rate formula
Marketing & Growth · 9 calculators
Analytics Calculators
Growth rates, moving and weighted averages, percentage contribution, index numbers, variance and trend analysis.
Analytics
Average Growth Rate Calculator
Average growth rate of a time series — both simple average of period changes and compound (geometric) rate.
AAGR = mean of period growth rates
Also called average growth · aagr calculator
Analytics
Moving Average Calculator
Simple and exponential moving averages (SMA/EMA) of a data series for any window length.
SMA = mean of last n values
Also called sma calculator · ema calculator
Analytics
Weighted Average Calculator
Calculate a weighted average (weighted mean) from values and their weights — for grades, portfolios, prices and ratings.
x̄w = Σ(wᵢ·xᵢ) / Σwᵢ
Also called weighted mean calculator · weighted mean
Analytics
Percentage Contribution Calculator
Each item’s contribution to a total change or total value — e.g. which products drove revenue growth.
Contribution = item change ÷ total change
Also called contribution to growth · share of change
Analytics
Index Number Calculator
Rebase a series to an index (base period = 100) to compare growth of values on different scales.
Index = value ÷ base value × 100
Also called index calculator · base 100 index
Analytics
Variance Percentage Calculator
Budget vs actual variance in amount and percent, marked favorable or unfavorable.
Variance % = (actual − budget) ÷ |budget|
Also called budget variance · actual vs budget
Analytics
Trend Percentage Calculator
Trend percentages for financial statement analysis: each period as a percentage of the base year.
Trend % = value ÷ base-year value × 100
Also called trend analysis · horizontal analysis
Analytics
Forecast Growth Calculator
Simple linear-trend forecast from past values: slope, next values and projected growth.
Least-squares line y = a + b·t
Also called linear forecast · trend forecast
Key analytics formulas
| Growth Rate | Total = end ÷ start − 1 · Per period = (end ÷ start)^(1/n) − 1 |
|---|---|
| Average Growth Rate | AAGR = mean of period growth rates · CAGR = (last/first)^(1/n) − 1 |
| Moving Average | SMA = mean of last n values · EMA = x·k + EMAₚᵣₑᵥ(1 − k), k = 2/(n+1) |
| Weighted Average | x̄w = Σ(wᵢ·xᵢ) / Σwᵢ |
| Percentage Contribution | Contribution = item change ÷ total change |
| Index Number | Index = value ÷ base value × 100 |
| Variance Percentage | Variance % = (actual − budget) ÷ |budget| |
| Trend Percentage | Trend % = value ÷ base-year value × 100 |
| Forecast Growth | Least-squares line y = a + b·t |