Modeling Driving Distances (2)
The National Household Travel Survey (NHTS) is probably the most comprehensive data source on driving behaviors of people in the US. It captures travel by US residents in all...
Category
statistics
Modeling Driving Distances (1)
In order to qualitatively study range anxiety, one of the first steps is to understand people’s driving behavior. A basic question is: What is the statistical...
Why Hasn’t Anybody Done This Graph about COVID-19?
The COVID-19 pandemic has been going on for over 9 months now (I am writing this in mid-December of 2020). One question that I have always been thinking about: Has the risk of...
PivotTable: Calculated Fields
Sometime, after you have made a PivotTable you realize you might want to do some further calculations based on the summary results. For example, After getting the total...
How to Draw a Combo Chart, i.e. Chart with 2 Y-axis, and Change Chart Type on a Mac
When two columns of data are of different scale, you will need to use a combo chart to plot each column on a separate axis. In the video below, one column is numbers of...
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....
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...
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...
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...