Elon Musk Gets Manufacturing
Why is large-scale manufacturing hard? This is one thing that many people do not quite grasp. And indeed it can be hard to explain, because there are a number of governing...
Category
analytics
Road Transportation is the Single Largest Decarbonization Opportunity with a Clear Path Forward
My apology for the unwieldy title. But I chose the long title to highlight one thing: Although there are many decarbonization opportunities with large impact, road...
Excel Pivot Table Trick: Drawing Charts Using Only Part of the Pivot Table
As I showed in a previous post about dash-boarding with Pivot Table, generating multiple charts with a Pivot Table can be very useful. But the problem is that Excel will...
Two-way Data Table in Excel is a great tool for sensitivity analysis
In an earlier post, I have introduced Data Table as a “secret weapon” to conduct sensitivity analysis. Now let’s go one step further and look at a more...
The Most Factual and Poignant Article on the Failure on COVID Data Collection and Interpretation (So Far)
Today, WSJ published a scathing opinion piece by Dr. Marty Makary from Johns Hopkins University titled “The Flimsy Evidence Behind the CDC’s Push to Vaccinate Children:...
Modeling Driving Distances (3)
Since my last post on using NTHS dataset to fit people’s driving distances, I have made some further modifications: (1) There are some very large TRPMILE data values, in...
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...
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...