Excel BI’s Excel Challenge #308 — solved in RDefining the Puzzle:The newest puzzle by ExcelBI is still focused on world of words. We need to determine if words are Portmanteau, which means that they are complex structure taking parts of root words whic...

Excel BI’s Excel Challenge #307 — solved in RDefining the Puzzle:Today ExcelBI gave us another puzzle, this time based on string manipulation rather than numbers.List all Palindromic phrases.A Palindromic phrase is that which is same when read from bac...

Excel BI’s Excel Challenge #306 — solved in RDefining the PuzzleWe are getting back to checking numbers properties with ExcelBI. Today we have some numbers to determine if they are Semi Prime. Post with riddle is here.List all Semi Prime Numbers.A Semi...

Excel BI’s Excel Challenge #305 — solved in RDefining the PuzzleToday task from ExcelBI which is under this link has another approach. We are not manipulate numbers or string to check their properties, but we are painting with them. That is why I will ...

Excel BI’s Excel Challenge #304 — solved in RDefining the PuzzleThe puzzle revolves around sports team statistics and their respective weightages. Each team has matches that are either Wins (W), Draws (D), or Losses (L). These are given weightages of 1...

Excel BI’s Excel Challenge #303— solved in RDefining the PuzzleOur puzzle revolves around identifying numbers that, when any digit is removed, still remain prime. Let’s take a closer look:Example 1: Consider the number 371.Removing the first digit (3) ...

In the captivating realm of machine learning, myriad techniques continually evolve to enhance predictive accuracy, offering innovative pathways for problem-solving. One such dynamic method is “boosting.” Imagine, if you will, the rigorous regimen of weightlifting. Each session targets heavier weights, challenging the lifter to push past previous limits. In a ...

Excel BI’s Excel Challenge #302— solved in RIntroductionToday’s Excel BI puzzle is available here. It is pure generational work today. We have to create from scratch so called Vigenere grid. Exercise file today is purely for comparison reason: file.Def...

Excel BI’s Excel Challenge #301 — solved in RIn a recent LinkedIn post, ExcelBI threw down an interesting challenge: Find the Polydivisible numbers from a list. This caught my attention, and I decided to tackle this using R. In this post, I’ll walk you...

Embarking on a machine learning journey often feels like being handed the keys to a high-end sports car. The possibilities seem endless, the power under the hood palpable, and the anticipation of speed, exhilarating. But anyone familiar with cars knows that no matter how advanced or powerful the vehicle might ...

The tapestry of metaphors we’ve been weaving in the “Metaphors in Motion” series takes a mythical twist as we step into our fourth installment. We’ve traversed the plains of linear regression, delved into the binary realms of logistic regression, and c...

Embark on a journey through the intricate realms of machine learning where decision trees emerge as mystical entities, whispering the secrets of the unknown. They weave intricate tales of destiny, unfurling their branches to narrate the saga of categor...

Welcome back to the “Metaphors in Motion” series! Today, we’re stepping into the bustling world of nightclubs, where a discerning door bouncer stands, meticulously vetting each individual against a list of criteria. The air is charged with anticipation, the line is long, and the decision is binary: you’re ...

Photo by Marcelo MoreiraIn the vast, bustling circus of data science, linear regression emerges as a tightrope walker. Poised and elegant, it teeters on a slender thread of predictions, each step deftly adjusted according to the pull of underlying data...

In the grand theater of machine learning, algorithms and models are more than mere equations and computations — they are performers, each with its unique style, story, and significance. As we prepare to lift the curtain on this series of tales, I invit...

In the intricate landscape of machine learning, each algorithm and model is like a unique LEGO piece. They come in various shapes, sizes, and colors, each offering its own distinct function. Whether you’re working with the sturdy ‘brick’ of linear regression or the intricate ‘gear’ of neural networks, these ...

Data preprocessing is the backstage work that seldom receives the limelight but ensures that the main act — machine learning models — shine. Think of it as tuning the instruments before an orchestra’s performance. Within the Tidymodels ecosystem, one package serves as the Swiss Army Knife for this critical process: recipes. ...

In the age of data, forecasting has become an instrumental compass guiding businesses, researchers, and policymakers alike. Just as climate scientists decode nature’s rhythms to predict impending storms or anticipate sunnier days, forecasters in various domains analyze past data to glean insights about the future. It’s a delicate ...

The dimmed lights of the cinema hall, the hushed anticipation of the audience, and the opening scenes of Nolan’s portrayal of Dr. Oppenheimer drew me in instantly. Amidst the enthralling narrative and cinematic brilliance, my mind began drawing parallels that transcended the screen. The palpable tension, the nexus of ...