Posts Tagged ‘excel’

So the bible counts 12.687 distinct words.

But what are the most frequent used words ? Here the graph (made in excel).

Not very intersting. Of course the most frequent words are ‘the’, ‘and’, etc… The word ‘Lord’ is the first ‘meaningful’ word on the 14th place. ‘God’ is 28th, ‘Isreal’ is 49th and ‘Jesus’ is only 112th. Get the full in list below.

Then I tried to visualize the top ‘meaningful’ words and their occurence in he bible. I got inspired by the wunderfull ‘box office’ visualization made by the New York Times. To generate the data I used the tool processing again (it is also great for non-visual data processing) and made the graph in excel. To ease the graph lines (less irrgular peaks) i used moving averages.

All 12.687 words with frequency count: view/download.


Read Full Post »

In this second visualisation I try to visualise the whole bible in one picture. To create the pictures i made use of a very handy application called ‘processing’ (http://processing.org). It is a simplified (but very powerfull) programming environment based on java and it’s “ideal for artists”. Check it out.

Every pixel in this 2000×500 picture represente 1 word. The color of the pixel is derived from the letters of the word and should be unique for every word (as we can show 16mio collors, that is no problem because we only have 12.687 distinct words).

This picture is not the original one as it is to heavy to put on the site. Actually it is a standard compressed jpeg so some quality is lost (todo: I should make a lossless copy available somehow).

If you look closely (click to enlarge) you can see variations of colors (horizontal bands) throuhout the picture.

In the next picture (clik to enlarge) you only see the pixels for the word “God”. I could try to make an online application where you can enter a word and get the picture visualizing the words occurence (If you want me to make you one in the meantime, just send me a message).

Read Full Post »