Tag Archives: startups

Dear Analyst Episode 24: Finding and ranking percentiles

I discuss how to calculate percentiles in Excel or Google Sheets using the PERCENTILE function. With the PERCENTILE function, you can calculate the value that would represent nth percentile in your list of values. This is not exactly the calculation I was looking for. Instead, what if you wanted to know what the rank percentile […]

Startups, Coming Of Age, And Boyhood

People love coming-of-age stories. That fuzzy mix of nostalgia, longing, and “if I only knew that when I was younger.” What if your childhood and adolescence could be summarized in 2 hours? The movie Boyhood took 12 years to produce, but we, the audience, have the luxury of witnessing the majority of a young boy’s life in matter of […]

Join our community of 5,000+ Excel and data analysis enthusiasts!

  • Learn Excel techniques and shortcuts
  • Episode updates from the Dear Analyst podcast about Excel
  • Updates on online and offline data workshops

Enter your e-mail and hit the blue button!