In my previous post, I shared how to predict using a single criteria leveraging machine learning in Python. If you haven’t read that, be sure to read that first here to get a better understanding of what we’re trying to do. In this post, I’ll let computer predict something based on multiple criteria. For example, […]
Tag: analytics
Machine Learning in Python (Univariate Linear Regression)
In this post, I share a method to utilize Machine Learning using Python. I have collected some data from CDC site about birth rate in the USA over several years. What I’d like to show you is how we can predict birth rate for a year that is NOT present in the dataset. For example, […]
Words to numbers challenge – Python
In this blog I share techniques on how to convert a dataset containing words into actual numbers (integer or float) save the output with numbers to an external CSV/XLSX data file. If you’re wondering why would one ever need this? Here’s a scenario: A list of movies and their corresponding revenues were read into a […]
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 […]
Eiesenhower Matrix in Excel (Quadrant Matrix)
Former US President Eisenhower is known to have said: “What is important is seldom urgent and what is urgent is seldom important.” This is reflected in a popular quadrant design, often referred to as “The Eisenhower Matrix”, used to effectively prioritize tasks according to their urgency and importance. This can be expressed in a quadrant matrix (image) […]
Car simulation and analytics. OOP in Python
In this post, I share a program that is built with an object-oriented design from the ground up in Python. It’s a game or simulation if you will, but has all the plumbing necessary to make it fancier, and a 2D or even a 3D game. It works as follows:You create a car object. Then […]
Venn Diagrams Done Right (Excel)
Venn diagrams are best used to show overlapping or interconnected relationships, especially overlapping segments. While they are ubiquitous, very few diagrams actually update automatically when data changes…that’s because most of them are one-time illustrations with no ties to the underlying data…they’re just drawn up like Infographics. It doesn’t have to be that way! In this […]
Murphy’s Law – Joking aside 😉
One of today’s most recognized physical laws is Murphy’s Law…one of the seeming fundamental laws of mankind: “If anything can go wrong, it will.” In this post, I discuss its brief history, and entertain the attempt of mathematically formulating his maxim in order to apply to some real-world sitations. The history: The adage or truism, […]
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 […]