Month: January 2021

Covid-19 Deaths in Sweden in 2020

Recently many politicians and other people have been claiming that Sweden’s death rate was unaffected by Coronavirus despite their controversial decision to keep restrictions looser than almost anywhere in the world while chasing herd immunity. Statistics Sweden (scb.se) have freely downloadable and comprehensive datasets on a wide range of national statistics. Included are data on…

Read the full article

1. First Steps with Microsoft Power BI – Simple Charts

I have a lot of experience using Excel for data processing and visualisation, but until today I had never used Microsoft’s business analytics tool, Power BI (Business Intelligence). Power BI Desktop can be downloaded here: https://powerbi.microsoft.com/en-us/get-started/ and used (with some restrictions) free of charge. To try it out, I started off by importing my 2020…

Read the full article

Wolfram Rules With Excel (VBA)

Stephen Wolfram is famous for many reasons. One of those reasons are his Wolfram Rules looking at cellular automata. One dimensional cellular automata are defined by very simple rules. Each cell is given a value of 1 or 0 depending on the values contained by the three neighbouring cells above (the cell directly above, the…

Read the full article

Game of Life with Excel (VBA)

The Game of Life rules are very simple. You start with a randomly generated grid of cells (some ‘[a]live’ and some ‘dead’).What happens next is decided by the following rules:* Any live cell with two or three live neighbours survives.* Any dead cell with three live neighbours becomes a live cell.* All other live cells…

Read the full article