Tiny Lizard

Power Pivot Consulting and Training

  • About
  • Blog
  • Power Pivot
  • Training
  • Contact

Playing with Median Age Data

December 21, 2014 By Scott Senkeresty Leave a Comment

Now Power Pivot learnings here, just Scott being a total data geek.

I am watching the Chicago Bears holding their own against the Detroit Lions (backup QB for Chicago looks strangely solid)… but because I have massive ADHD like to multi-task I was also looking at this article on where young and old people live. 

Being “Data Curious”, I brought in the data from the CIA World Factbook and added a simple ratio… of the male to female median ages.

For example, in the United Arab Emirates, the median age for males is 32 and the median age for females is 25, giving a huge ratio of 1.28.  In contrast, in Curacao the male:female is 32.7:39.9 for a tiny ratio of 0.82 

I can’t decide if this has interesting “meaning”… somebody should tell me.  Smile  (Though, what is wildly missing is the actual populations numbers).

AgeRatio

 

Here is the total (male and female) age medians.  People in Monaco are freaking OLD.  Smile   Sadly, as you would expect the numbers for some of the African countries are nothing short of tragic.

MedianAge

Back to the football game.  Go Seahawks!

  • About Scott
  • Latest Posts
  • Contact

About Scott Senkeresty

Scott Senkeresty here… Founder and Owner of Tiny Lizard. Yes, I have done some stuff: A Master’s Degree in Computer Science from California Polytechnic State University in beautiful San Luis Obispo, California. Over twelve years developing software for Microsoft, across Office, Windows and Anti-Malware teams… Read More >>

  • The streak is alive! – August 10, 2017
  • DAX KEEPFILTERS Plus Bonus Complaining! – July 20, 2017
  • VAR: The best thing to happen to DAX since CALCULATE() – July 11, 2017
  • Review: Analyzing Data with Power BI and Power Pivot for Excel – June 20, 2017
  • Power BI Date Table – June 2, 2017

View All Posts

Scott Senkeresty here… Founder and Owner of Tiny Lizard. Yes, I have done some stuff: A Master’s Degree in Computer Science from California Polytechnic State University in beautiful San Luis Obispo, California. Over twelve years developing software for Microsoft, across Office, Windows and Anti-Malware teams… Read More >>

DAX CONTAINS( ) function
The DAX EARLIER Function

Filed Under: Power Pivot

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 307 other subscribers

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Latest Blog Posts

  • The streak is alive! August 10, 2017
  • DAX KEEPFILTERS Plus Bonus Complaining! July 20, 2017
  • VAR: The best thing to happen to DAX since CALCULATE() July 11, 2017
  • Review: Analyzing Data with Power BI and Power Pivot for Excel June 20, 2017
  • Power BI Date Table June 2, 2017

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 307 other subscribers

Copyright © 2026 Tiny Lizard

MENU
  • About
  • Blog
  • Power Pivot
  • Training
  • Contact