by Peter Koebel | Jul 28, 2022 | Business Intelligence Tips, Data Visualization Tips, Logic / Probability Tips
What is your company doing to avoid the survivorship bias trap? I’ll give you a classic example of survivorship bias. You might recognize this picture if you’ve studied survivorship bias, statistics, or data visualization. In World War 2 the U.S. Military wanted to...
by Peter Koebel | Jul 24, 2022 | Excel Tips, Walkthroughs / Tutorials
Let’s say you want cells that are currently vertically in a column, horizontally in a row – let’s learn how to use “paste transpose” to prepare the data in the desired format. One thing you can do is, select the relevant cells. Then copy them....
by Peter Koebel | Oct 27, 2020 | Excel Tips, Walkthroughs / Tutorials
Has you ever opened an Excel file and noticed the column names are cut off and you can’t see all the information you want to look at? Adjusting column and row width is what you need! One thing you can do, to widen the column width is select the column. Then go on the...
by Peter Koebel | Jul 14, 2020 | Uncategorized
The Monty Hall problem is named after the original host of the game show Let’s Make a Deal, Monty Hall. The problem is this: Let’s pretend you’re on a game show, and you’re given the choice to pick one of three doors. Behind one door is a...
by Peter Koebel | Jun 9, 2020 | Uncategorized
Let’s pretend you’re on the board of directors for a company (ABC Corp in this example) and are looking into potentially acquiring a competitor company (XYZ Corp). You and the other board of directors want to understand the impact this acquisition could...
