The accuracy of your IRRs and NPVs depends to a large extent on the quality of the assumptions that go into the financial model. However, there is one element that also affects the accuracy of the calculations.
read more >

Many finance problems inherently involve circular calculations. The most common of them is balancing the balance sheet. So how do we typically solve such kind of modeling problems?
read more >

In his brilliant book Beautiful Evidence, Edward Tufte—nicknamed the Leonardo da Vinci of data by The New York Times—introduced six principles that he calls the fundamental principles of analytical design.
read more >

We've always been fascinated by the concept of “time”. It's probably the most important concept known to mankind and has long been a major subject of study in religion, philosophy, and science.
read more >




Adopted public policies affect everyone—they're called public for a reason after all. Nowhere is this truer than in the realm of defense policy.
read more >

The danger of using the wrong metrics for policy making how-accurate-are-your-irrs-and-npvs Avoid circularity in financial models Edward Tufte analytical principles compared with what to find seasonality use cycle plots how accurate are your IRRs and NPVs

It’s useful to distinguish two types of average measures: Simple average (or arithmetic average) and weighted average. Both—simple and weighted averages—are widely used in practice but each type is more appropriate to use than the other for certain purposes and applications.
read more >

Don't average averages. simple average versus weighted average The ecological correlation fallacy

If you ask a group of data analysts and data visualization experts to choose the most important chart type to display data, most probably “The scatterplot” would be the response you’ll get. And they have a point.
read more >

Review of the book The Functional Art by Alberto Cairo

Outside the realm of hard sciences, I generally follow a simple heuristic to identify books worth reading. 1) Read books that have been in print for 15 years or so. 2) Break rule #1 for books written by authors who have in their portfolio at least one book that passes rule #1.
read more >


how to create a Fourfold Chart in Excel how to create a Non-ribbon Sankey Diagram in Excel how to create a Waffle Fourfold Chart in Excel using Conditional Formatting how to create a Bar Chart with color ranges in Excel How to create a Dot Plot in Excel How to create a Lollipop Chart in Excel how to create a Horizontal Bar Graph with endpoints How to create a Bivariate Area Chart in Excel how to create a Dumbbell Chart in Excel How to create a Fan Chart in Excel Tufte in Excel - the Bar Chart Edward Tufte in Excel The Box Plot Edward Tufte in Excel the Slopegraph How to create a Strip Plot in Excel How to create a Grid Map in Excel How to Create a Grid Map with Sparklines in Excel How to create a scatterplot with dynamic reference lines in Excel How to create a Heatmap in Excel The Ecological Correlation Fallacy Part 2 Edward Tufte in Excel The Dot-Dash-Plot How to create a Grid Map with circles in Excel

When you look at correlation, when you hear correlation you’ve got to be suspicious. Learn how not to be fooled by relationships that are completely spurious.
read more >

How to Create a Bar Chart With Labels Above Bar in Excel