Skip to content
  • Home
  • Analytics Blog
  • Energy Blog
  • Book
  • Videos
  • Close Search Form
    Open Search Form
Category

analytics

analytics
data
modeling
statistics
visulization
work efficiency

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...
analytics
data
visulization

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...
analytics
data
video
work efficiency

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...
analytics
data
statistics

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...
analytics
data
visulization
work efficiency

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...
analytics
data
work efficiency

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...
analytics
modeling
visulization
work efficiency

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...
analytics

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:...
Newer Articles »

Contact

Email: justinren AT excelprof.com

Your Account

Log In
Register Lost Password

Recent Posts

  • Why Hasn’t Anybody Done This Graph about COVID-19?
  • Wow What a Great Data Site
  • Excel Shortcut Keys (2020 Edition)
  • How to Provide Electricity Access to Rural Africa: An Example
  • Why is Chick-Fil-A Picking up Market Share (and Why is McDonalds Testing Robot Fryers and Voice-Activated Drive-Through)?
  • Filter Data Right in your Pivot Table Fields!
  • Sensitivity Study (or Scenarios) with Data Table
  • PivotTable: Calculated Fields
  • Dashboard with PivotTable
  • Data Slicer and Timeline are Useful Reporting Tools in PivotTable
  • How to Draw a Combo Chart, i.e. Chart with 2 Y-axis, and Change Chart Type on a Mac
  • How much gasoline do we American consumers buy each week? An Example of Excel Modeling
  • Most Used Excel Shortcut Keys – Mac and PC
  • How to Draw a 3-D Chart
  • Chance of Nothing Happening? The Power of Joint Probabilities
  • This Site Has Abundant Climate Data
  • Here is Another Example on Why Excel will Never Go Away – Julia Computing
  • Tesla Needs to Be More Rigorous in Discussing Numbers
  • What (and when) are the most popular US cities to visit?
  • Google Sheets is Catching up with Excel in Charting
  • What is Your Favorite Data Source?
  • All Great Boston Area Towns Benefitting from the Housing Boom? Not Quite So
  • How Advance do People Make Rental Car Reservations? The Result May Surprise You!
  • How to Estimate Uber’s Monthly Ride Volume in 3 steps
  • How to Draw a Pareto Chart?
  • Sparkline (aka chart-in-a cell) really sparkles!
  • Data Table is a Secret Weapon in Excel Modeling and Analysis
  • “That’s twice the size of Texas. They may never find us.”
  • The New Histogram Tool in Excel 2016 is Handy-Dandy
  • To build a frequency distribution chart, do NOT use Excel’s Histogram add-in tool
  • Flashfill in one of my favorite new feature in Excel
  • Excel Tutorial: How to Load Solver in Excel (Mac)
  • You Draw It: How Family Income Affects Children’s College Chances

©2018 Excelprof.com All Rights Reserved.

Facebook