With Excel’s toolbox of thousands of formulas and VBA support, it’s not out of question to be able to create games although it’s not designed for that purpose. However, not for the sake of playing, rather for experimentation and learning, I decided to present a simple form of a spin game. Game Rules Have 2 […]
Tag: coding
Random Fun with Excel
This is a seemingly useless but visually fun usage of visuals, combined with Excel functions and VBA I did to take a break from my typical gnarly Excel analytics work 🙂 How it works: 1. Fill in a formula to generate random numbers between 1 and 100 (inclusive) across the cell range. 2. Apply 2 […]
Phone number formatting tips (Excel and Python)
For most people working with data for a significant amount of time, formatting raw data from different sources are both a reality and a pain. Today, I show different ways to format an un-formatted string that contains phone numbers using Python, and Excel. Our task is to format it (either for human-reporting, or consumption by […]
Sample Size in Python
This is part of a 3-part series on the topic. Please read the posts in the order for maximum clarity and context: 1. Sample Size and Margin of Errors. Everything you need to know and ++ 2. Sample Size (Contd.) 3. Sample size in Python (This one) Ok, after reading the first 2 posts, you […]
Sample Size (Contd.)
This is part of a 3-part series on the topic. Please read the posts in the order for maximum clarity and context: 1. Sample Size and Margin of Errors. Everything you need to know and ++ 2. Sample Size (Contd.) 3. Sample Size in Python In this blog, we’ll use actual numbers to determine […]
Sample Size and Margin of Errors. Everything you need to know and ++
I’m not a statistician by profession or training. However, I find it fascinating with even the basics under my belt and find plethora of statistic’s practical usage. Without it, we’re really ignorant. With it, we’re equipped but not always best educated either. I heard the phrase again and again, “Correlation does not equal causation!” and […]
Running code from within another code (Python)
Most of us who have done any programming know that virtually all languages allow you to execute another program from within a program. For example, you start your program, which may start another process (via calling Execute or the like) that’s a self-contained program by itself, resulting in another process or spawn another thread as […]
The 3n+1 Problem & More! (Part 2)
This is a continuation (part 2) of my blog titled The 3n+1 Problem & More! I recommend you read that first to get the context, or it’ll be really boring or at least confusing 🙂 In the previous blog we generated a sequence of numbers starting from ANY number and converging to 1…always! I also […]
The 3n+1 Problem & More! (Beyond Collatz)
Recently, I was reading a post about an mathematical formula when applied to any number (positive integers) will end up at 1, no matter odd or even. It’s called the 3n+1 problem or the Collatz Conjecture. So, of course, I tested the theory and sure it works. Actually, when you think about it, it’s no […]
The Dictionary Challenge-Part 2
This is a continuation of the Dictionary Challenge previously completed. To follow along, you should read that post here. So, we have already downloaded a free Webster dictionary but completely unformatted and unstructured. So, we created a new file in a more structured way that our program can process. The code is in the previous […]