Seattle Seahawks find themselves at a crossroads after the 2023 NFL season. The team faces critical decisions regarding their coaching staff and personnel. Changes came hard and fast to some fans’ surprise, and to some, expectedly if not a little later than expected. Whatever your position is there are arguments for both supporting an overhaul […]
Tag: datascience
My Neocaridina Water Parameters Tracker
Here’s a live water parameter history view of my fairly new neocaridina shrimp tank. For ideal parameters and more information about neos, see this post. For all shrimp-related posts to-date, click here. The top and bottom red horizontal, parallel lines indicate the rectangular area or band of a good range for the parameter in each […]
Projecting Neocaridina Shrimp Population
Two months ago I wrote an app for myself to keep track of my new hobby Neocaridina Shrimpkeeping. It was only 2 weeks before that I started the hobby before I recognized that a handy application to keep track of my shrimp’s water parameters, treatments and care with curated, accurate information would be very useful. […]
All About NFL’s Top Heach Coaches
I dug some information on some of the 32 head coaches in NFL today, and did some analayses. I was intrigued by their performance, compensation, their roots, their network and influence, correlations among various parameters like age, experience, wins, and salary. I also looked at how many teams they’ve coached in the past, and how […]
Republican Candidates’ Primaries Spend 2024
The campaign trails are blazing for the upcoming elections and the Republican party still needs to narrow their final nominee down to one in the coming months. Niki Haley and Donald Trump are the only two remaining runners (written: Jan 25, 2024). Below are some charts I created to show how much they’ve spent on […]
How to chart ranges in Excel
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 […]
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 […]
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 […]