Let’s say you have some actual measurements of some parameter over time or a series, and you’re measuring it to see if it falls within the “safe” or “ideal” range. How can you create a visualization to show both the measurements and the safe/idea range values effectively? That’s what I’m going to answer in this […]
Tag: analytics
How to create visualizations in Excel given nested scores
Here’s the scenario:We have two players named Eve and Inna in a game competition (say, Tennis). They play 5 matches against each other, and each match is composed of 3 games called Sets.We have data on scores of the players set by set for all 5 matches.So, the question is: How do we present this […]
Early gambler’s prediction of Super Bowl winner for 2023 season
Here are the probabilities of each team winning the Super Bowl according to the betting odds from Caesars Sportsbook as of September 6, 2022: As you can see, the Buffalo Bills had the highest probability of winning the Super Bowl according to the betting odds, followed by the Tampa Bay Buccaneers and the Green Bay Packers, who […]
Football is ON! Interesting NFL stats (2023 season)
Are you a fan of NFL (American Football)? Do you want to know the odds of your favorite team making the playoffs this season? Well, you are in luck, because we have some amazing stats for you. Based on the historical data from the past 23 seasons, here is what we found: But what about […]
Impressive Voice->Text AI tool
I came across this newest entrant to voice to text AI generation tool called AudioNotes. It converts your ‘random’/unstructured voice notes and unstructured text notes into structured text summaries using AI. Essentially, it’s a note-taking app that analyzes the voice notes and can generate many variations depending on the need. I decided to give it […]
Extract sample subset with given criteria
How to load a subset of data from a full dataset with given percentages proportions by a column (“Group” in this example) plus how to import/export the Excel data file. Objective:We have n food items from 4 different groups: dairy, fruits, protein, vegetable in an XLSX sheet with a header and 3 columns: Name, Group, […]
Finding target values with constraints
In this post, I share an example of a very common challenge in business which is complex to solve just by hand, along with the easy solutions. The Scenario: Let’s start with the scenario. We have a bakery that bakes 4 items that sell at our pre-determined prices as shown below: Cost (each) Bun $3.00 […]
Finding a missing number in a sequence
Imagine having a list of thousands of numbers in a sequence that is supposed to be sequential (incrementing by one) and somewhere there’s a number missing. That number could be an ID or some required piece of information. Also, what if the sequence is not incrementing by one but by some other number (e.g. by […]
Animating Charts in Excel and beyond
Some time ago I demonstrated how to create Time-lapse animations in Excel in my post here. Part of that procedure utilized a short-lived but cool feature called ‘PowerView’. Unfortunately, as of late 2021, Microsoft has removed support for PowerView in Excel (that made this time-lapse animation possible) and instead is encouraging users to use PowerBI […]
Decision Tree and Prediction (Python)
This is an example of a Decision Tree model (very useful and popular method) to make prediction using the power of Machine Learning…using just a normal PC. Here we predict salary (depedendent variable) by giving various types of criteria (different forks in a decision tree). e.g. What’s the salary of a particular gender, of some […]