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 […]
Category: Analytics
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 […]
How is chatGPT useful?
Author’s note: Instead of me explaining the benefits of ChatGPT, I figured why not let ChatGPT write its own summary and toot its own horn, and best of all write it straight into my blog site, creating a real blog post (without having me to copy/paste) and go live?! So, there we have it…this post […]
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 […]
What is Sigmoid function and why?
In this blog, I touch on a core function that’s used in many machine learning scenarios whether explicitly or as a part solving a given problem. This is extremely useful for recoding values for classification (binary or multiclass) where we need to map some categorical values into a finite range of values (e.g. 0 or […]
A Manifestation Formula
Will your dream come true? If so, how likely is it? What really is your desire composed of? And are there factors that affect that, if so, what are they; and which ones can we control? Following the search for answers to these questions, my ultimate quest was: Can we manufacture a formulation for quantifying […]
Mass and Energy – Explained Simply
In this blog, I explain in simple terms, the relationships between mass, weight, and ultimately energy as it relates to anything, including your own body mass, and how all of this can be tied to Einstein’s equation: E=MC^2. By the end of this post, you’ll be able to tell how much energy is stored within […]
Complementary post to: Pop Quiz [And Solutions With Low Code!]
This post is a continuation of or complementary post to about using Excel and SQL for pop-quizes. Please read that first to get proper context…otherwise, this wouldn’t make much sense. As discussed in the post linked above, the SQL queries can be saved from Microsoft Query Editor to an external file. It’s really convenient because […]
Pop Quiz [and Solutions with Low Code!]
Every now and then I see some simple quizzes pop-up on Facebook such as: “Name a state without letter A in it.” The letter can be another, they just switch it around from time to time. This particular post is inspired by such posts. Sure we can go through all the states in our heads […]