All articles with 'MMult()' Tag
How to predict cricket scores [Excel + Machine Learning]
Can we predict cricket match score in Excel? Using machine learning, ensemble modeling, multiple regression and Excel formulas we can. This tutorial explains how.Continue »
Calculating Maximum Change [solutions & discussion]
Last Friday, we had a fun little Excel challenge – Calculate Maximum Change. More than 170 people commented and shared their solutions to this problem.
And the best part?
The best part is the variety of solutions & thinking displayed by our community. So if you are one of those 170, puff your chest & pat yourself on the back. Go ahead, I will wait.
Today, lets take a look at some of these awesome formulas and understand how they work. Read on and watch the video you below to gain few awesomeness pounds.Continue »
Formula Forensics-No. 036: Calculating Costs that Vary by Year and Age
In this episode of Formula Forensics, lets talk about how to build a model where costs vary per year and age. In this example, we are talking about a plantation project. The costs & yields of plants vary by the year they are planted in and the age of plants. In this case, how do we calculate the total costs or returns with formulas?
Formula Challenge 001 – Return everything from a string after the first block of numbers (Part 4.)
Welcome back to another gripping episode of “When good formulas go GREAT”. Just like the immortal combatants in the classic 1986 movie Highlander, over the last three posts in this series our Excel nerds have been locked in an ages-old battle to decapitate. A text-string, that is. Not each other. So far we have seen […]Continue »
Formula Challenge 001 – Return everything from a string after the first block of numbers (Part 2.)
Today we look at the third place winner from our inaugural Formula Challenge, a neat solution provided by Sajan.Continue »