How to Draw a 3-D Chart
If you have 3-dimensional data, drawing a 3D chart can be very helpful in visualizing how the two variable jointly affect the outcome. In Microsoft Excel, such 3D charts are...
Category
analytics
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...
This Site Has Abundant Climate Data
I have always been fascinated by climate data. Just today while researching for data on this topic, I came upon the Berkley Earth website and found that it has warehoused...
Here is Another Example on Why Excel will Never Go Away – Julia Computing
Recently I had a conversation with a colleague who argues that Excel will die because he felt people are switching to other computing environments such as R. While I agree...
Tesla Needs to Be More Rigorous in Discussing Numbers
Not to pick on Tesla – Many companies do this – But it really needs to be more rigorous in discussing its numbers. Take the most recent press release on its car...
What (and when) are the most popular US cities to visit?
For some business reasons, I need to check what the most popular tourists destinations in the US are. It is not hard to find such data. The US National Travel and Tourism...
What is Your Favorite Data Source?
My students and I recently began a crowd-sourcing project – To collect some of the most worthy data-centric websites, so that others can learn and share as well. We need...
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 calculate Time Difference in Excel
Microsoft Excel has a function to calculate the numbers of days between two dates (DATEDIF), but there is no specific function to compute the hours and minutes between two...
You Draw It: How Family Income Affects Children’s College Chances
New York Times has this super-interesting article, partly because of its interactive nature:...