Pivoting over death causes in Germany using Calc from LibreOffice 3.6

This article is going to cover the usage of pivot tables and charts with Calc LibreOffice 3.6 using statistics on death causes in Germany from 1980 to 2010 – categorizing gender and 18 age groups. I am tempted to make this a data labeled article – but as the meaningfulness of absolute numbers regarding a population whose age distribution is changing over time is very restricted I won’t (did I leave out commas here?). As a matter of fact I covered fatalities caused by viral hepatitis in a previous article in more detail – I use this cause of death also in this post.

Continue reading

GENESIS – the online source for statistics on Germany

The German Federal Office of Statistics (Statistisches Bundesamt Deutschland) maintains a web site called GENESIS which offers a huge amount of statistics available with a few mouse clicks. Unfortunately the web site is only offered in German language and a tad clumsy to use. But still, a wide variety of topics regarding German economics, society and politics is covered – which makes this source indispensable.

Continue reading

Counting the frequency of ordered character pairs

I wrote this PHP script to count the character combinations for a previous post. This script is covering more functionality than I acutally used for the article. First I was fetching web-sites – using a service from www.alchemyapi.com which extracts the actual text information from a site. But after figuring that it was a bit tricky to choose a halfway representative set of web sites for a language, I took a short cut and just evaluated a big text file containing a classic novel for each language.

Continue reading