archive

Archive for February, 2011

Excel: Constant Annual Growth Rate (CAGR)

Friday, February 25th, 2011

In order to calculate the (average) annual growth rate over multiple year, use this formula:

CAGR: =((End Value/Start Value)^(1/(Periods - 1)) - 1

Posted in Excel | Comments Off on Excel: Constant Annual Growth Rate (CAGR)

Treemap – Household Budget in Germany

Monday, February 7th, 2011

Nice application showing in treemap form the expenditures of the german government.

Posted in Design | Comments Off on Treemap – Household Budget in Germany