Data Analyst
Chess.com offers puzzles to help people to improve their chess playing skills. The stats relating to the last 25 puzzles completed by any user of the website can be see online here: https://www.chess.com/stats/puzzles/PLAYERUSERNAME , as shown below. I copied a table of this data, dropped it into an Excel worksheet, and added an index column…
I have continued experimenting with Microsoft Power BI trying to find situations in which it is faster and easier to use than Excel for data visualisation. If I find something faster and easier in Power BI (in which I have <=0 experience), then it really must be a strong use case for the application. Looking…
The chart above shows the percentage drop in detected Covid-19 cases comparing each day to the same day one week earlier, and covering the dates from 1st Nov 2020 to 21st Feb 2021. The trend shows that (even before the lifting of restrictions from lockdown #3), cases could start increasing again by mid-March 2021. [Raw…
My generic Chinese fitness watch measures my heart rate and sleep patterns 24/7. It has an associated app which displays very high level summary information on my phone via an associated app. The watch does however send all the data it has collected in a very non-standard file format every day via Bluetooth to my…
Below is a chart to showing the percentage of positive Covid-19 tests in the UK each day for 1st October 2020 to 17th January 2021. The red trend line shows the 7 day rolling average test positivity rate. The first downward slope shows the effect of the second national lockdown, followed by a steep peak…
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…
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…
This evening (28th August 2020), popular YouTuber educator Veritasium (Derek Muller) asked the question of whether success is a result of hard work or luck. During the video (link below) he discusses how in January of this year, NASA selected 11 new astronauts from 18,300 applicants to join their corps.He wanted to know how much…