# Sensitivity Study (or Scenarios) with Data Table

In managerial decision making, many time we need more than just an optimal decision. Often we would like to know how my results change if I change my decision in a certain...

# How much gasoline do we American consumers buy each week? An Example of Excel Modeling

I am a fan of Bill Gates. But the reason I bring his name up in here is because he just demonstrated the power of logical thinking, something very important in Excel modeling....

# Chance of Nothing Happening? The Power of Joint Probabilities

Yesterday, as I was reading a book about Blackstone, the famed asset management company, something caught my attention.  It was about how one of its executives describing...

# All Great Boston Area Towns Benefitting from the Housing Boom? Not Quite So

I recently came across an interesting summary table on median condo prices in the Great Boston area (re-created in Excel below; original data from the Boston Magazine, whose...

# How to Estimate Uber’s Monthly Ride Volume in 3 steps

Many of my students are heavy Uber users.  So I asked them one day, “What do you guess should Uber’s monthly ride number be in the US?” It turned out to be a...

# How to Draw a Pareto Chart?

Pareto chart, put simply, is a sorted frequency chart. It is used mainly for identifying the most frequent occurrences in a collected sample. Some business-situation questions...

# Data Table is a Secret Weapon in Excel Modeling and Analysis

Scenario analysis (also called What-ifs) is an indispensable part of business decision models. What is demand is only half of predicted? What if conversion rate is 50% higher?...

# “That’s twice the size of Texas. They may never find us.”

Wait…what’s this? You might be wondering.  What does it have to do with Excel modeling?   Let me explain.   First of all, this is a quote from the move...