Today, I present a real-life problem that actually goes back many years in terms of the type of problem and method to tackle such. Here’s the scenario: There was a robbery and the software has identified the perpetrator to be black. The case goes to jury and they must decide with the help of the […]
Tag: STEM
Anatomy of a goal (part 2)
This is a continuation of the original soccer goal tracking chart and animation posted @: https://flyingsalmon.net/blog/?p=869 It’s recommended that you read that blog first for context. In this blog, I added actual players involved in that goal (denoted by their jersey and individual numbers). The players data are added as an addition series (much like […]
Behind every goal, there’s science. Anatomy of a goal (part1)
With the World Cup, Copa America underway, obviously I try to catch some games and follow the scores on matches I missed. The other day I noticed a chart on BBC site that showed charts with points plotted on a field where the ball had traveled on a particular game. This got me thinking, how […]
Wading through Billions of $$$!
Welcome to this post. Today, I want to share my process of retrieving some Mega Million Lottery winning data, curating them, and analyzing them to tell a story. The results may or may not make us super-rich 🙂 but I certainly had fun throughout the process. Disclaimer: I used Excel, but this is not a […]
World’s Oldest Cat Is 31! So, what do you as an analyst?
Did you know the world’s oldest living cat is now 31 years old? My first thought was: “that’s old alright! But how does it translate to human age? Must be really old.” Turns out, yes it is. Although it’s not that straight forward as many of us learned in the past, but not too difficult […]
Risks & Odds: Matter of Life or Death (Analytics)
Risks & Odds ratios are heavily used in medical fields mainly to track survivability of patients or effectiveness of some treatment on patients. You’re not a surgeon, nor a doctor. But you’re in charge to deliver information that’ll be used to determine the future of all patients! (e.g. Whether to administer a particular treatment, to […]
Analysis of Wine Data (analytics)
You’re given a massive list of data about wines around the world, their prices (a huge range from $4 to $3300 per bottle!), expert tasters’ scores, who scored them, how many scored them, name of the wine, description of the win, their origins including country, province, region, subregion, their variety or category, just to name […]
The Dictionary Challenge-Part 2
This is a continuation of the Dictionary Challenge previously completed. To follow along, you should read that post here. So, we have already downloaded a free Webster dictionary but completely unformatted and unstructured. So, we created a new file in a more structured way that our program can process. The code is in the previous […]
The Dictionary Challenge-Part 1
Ok, today I’m inflicting a self-imposed challenge…here it is: Get an English dictionary. Then find how many words start with vowels. How many words are there starting with “odd” letters, which I’ll set as: Z, Q, J. Then find the longest word in that dictionary. (Say, we’re going to make a word guessing game) All […]
Burger-Economy Charting! (Excel)
Welcome back! Just saw the latest released data on Big Mac prices world-wide, and the articles showing some simple histograms—and some of them even slapped on a cheesey (pun intended) burger animation to make their hohum horizontal bar charts appear to be more eye-catching. Well, today I’ll show you how to use the same data […]