Saturday, October 04, 2025
Analytics Coding Education STEM

Forecasting with Seasonality & Linear (Time-Series)

In one of my earlier blogs, I used linear forecasting method to predict a team’s scores in the future. While that was darn close to reality (when we checked with actual results), it did not mathematically account for fluctuations or seasonality and the outcome was always linear. In this blog, I show another method (that […]

Read More
Analytics Coding Education STEM

Quick! Pick a number between 1 and 10!

“Pick a number between 1 and 10”—There’s been plethora of variations of such a game manifested in ways of magic tricks, simulations, statistics, and for sheer intellectual and nerdy curiosity. But is there an answer? Better yet, is there a pattern? If so, what is it…and how can it be explained? Some experiments claim to […]

Read More
Analytics Coding Education STEM

Simulating coin-toss in Excel

Most of us know that theoretically, there’s a 50-50 chance of getting a “head” from an unbiased coin-toss. There are numerous implementations and simulations done in virtually all programming languages around this age-old ‘riddle’. In this blog, I share a simple but very effective simulation in Excel. Here’s the simulation: As you can see, I’m […]

Read More
Coding Education STEM

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 […]

Read More
Coding Education STEM

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 […]

Read More
Back To Top