Love em or hate em, New England Patriots is a team to reckon with. They’ve implemented numerous creative and suspicious internal strategies that most other teams would love to copy or at least understand. Well, I cannot expose those details as they’re not available anywhere. What is available however is their scores and stats. So, […]
Tag: fun
Generating, plotting trajectory and…gamification (Excel)
Reminiscing the old tank game, I wanted to re-create a low-weight, low-code option of that simulation. The game depended on a canon (projectile) shot at your selected speed and angle to hit an enemy tank. The foundational formula is used in missile launch, sports, and many (you guessed it) military applications. Here, using the same […]
Some of my faves: Live-Streaming Underwater Cams
Here are some of my favorite live-streams of underwater cams. They range from sharks, to coral reef life, to manatees. Also, there’s a link for an hour-long meditation while watching the apex predator of the underwater. Enjoy! Coral City Camera. Miami (FL, USA) Live stream from an urban coral reef in FL. Great streaming and […]
Selected movies: searchable, sort-able for utility and fun
Today, I present a web application with a list of selected movies (about 3,000 titles) I extracted using developer APIs from IMDB and OMDB databases using my Python app. After extraction in the app, I reshape the data according to my needs and then export programmatically to XLSX format (for Excel). Which is then wrapped […]
How many cats and dogs are there in your city? (method and cool charts)
In this seemingly simple couple of charts, I demonstrate a few nifty tricks that are fun and effective. First, we want to find out how many cats and dogs in a few selected cities (around me) and come with an educated estimate based on data. Then, we will use some cool, free add-in to create […]
A Fluid Family From a Scientist’s POV (Humor)
Relationships Explained by Statistics (humor)
The following charts are based on real datasets (plotted in Excel) that I created (for mainly humor, but probably not too distant from the truth) in order to attempt to visually depict relationship dynamics. The way to read them (or to get the most humor out of them), is to recognize that the x-axis shows […]
Simulating coin-toss in Excel
Most of us know that theoretically, there’s a 50-50 chance of getting a “head” from an unbiased coin-toss. There are numerous implementations and simulations done in virtually all programming languages around this age-old ‘riddle’. In this blog, I share a simple but very effective simulation in Excel. Here’s the simulation: As you can see, I’m […]
A “Dicey” Experiment
You roll a pair of dice. My task is to predict which numbers will roll (total from both dice). How would I go about it? It’s obviously a probability problem. I want to find the probability of each roll for all possible outcomes. How would I arrange and solve it in Excel? Answer: Quite easily […]
Compare and understand: Spread and Consistency
Imagine you have a product line with an average price of $20, and another product line where the average is $100. Which has more spread? Imagine you have 3 players whose bowling scores you have (which are all over the place by the way) and you want to know which player is more consistent? Or, […]