How to draw ranking data properly
A slight problem with drawing data on ranking is how we normally think about ranking. We normally associate “#1” as the best, and “#10” as worse...
Category
video
Simulation: It all starts with a coin toss
There are many sophisticated tools dedicated to Monte Carlo simulation, but Excel is powerful enough to handle a variety of simulation needs. Here are the basic steps of...
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 Dawn of the Modern Power Grid Started Right Here in Massachusetts (and It was Clean Energy!)
Electrification is indeed the single great achievement of our society. And yet, I was delighted to find out the modern power grid actually started in Massachusetts, a state I...
Zero-Carbon Economy: A Grand -and Necessary – Vision
I just watched a video produced by Cambridge University called “The Climate Crisis: Towards Zero Carbon”: Well done, Cambridge! The video first shows that data on...
Digital Technology and Clean Energy
I just finished a book titled “Energy’s Digital Future” authored by Professor Amy Myers Jaffe. The book raises a few very important points that are worthy of...
How to Provide Electricity Access to Rural Africa: An Example
How to provide electricity access to the remote regions in developing countries is a vast topic, both in terms of its scope and its related research. Take Africa as an...
Why is Chick-Fil-A Picking up Market Share (and Why is McDonalds Testing Robot Fryers and Voice-Activated Drive-Through)?
WSJ recently ran an interesting article (and video) on how and why McDonalads is testing using robots to cook and voice-recognition software to take orders at drive-through....
Filter Data Right in your Pivot Table Fields!
One of the ‘hidden treasure’ in Pivot Table a lot of people do not know about is that you can filter data right in your Pivot Table Fields. This is extremely...