STUMP » Home Page » visualization category listing.

Mortality with Meep: Guessing at Trends  

by meep

Someone on facebook linked to the Storyline site, and I’ve really enjoyed it.

The concept is very simple — there’s a time series of some sort, based on historical data — generally, there are points for every decade, or maybe every five years. You are given one point on...

Keep Reading...

Geeking Out: Improving Public Pension Dataviz  

by meep

This piece was brought to my attention:

Not All Cities Have A Pension Problem

The Top 21% of Cities With High Pension Funding Levels Deserve Attention and Usually Praise

With so much well-deserved negative attention focused on cities with huge unfunded pension overhangs, it’s probably a good time to draw attention...

Keep Reading...

An Ugly Interest Rate Environment and Public Pensions Chasing Returns  

by meep

The Federal Reserve Open Markets Committee (FOMC) had a meeting this past week, and the reactions have been ugly.

This is what I mean by ugly: a yield curve inversion.

The x-axis is years, and the y-axis is the percent rate.

What that graph shows is that the 1-month to...

Keep Reading...

Bye Bye 2018 - And the 80 Percent Funding Myth Persists  

by meep

Ugh. What a year. I’m beat.

It also doesn’t help that I just slogged through the end of War and Peace (because I had to get it done by 6am this morning when the audiobook was going poof).

One of the things that was a positive for 2018 is that...

Keep Reading...

Checking the Numbers: How Much are Social Security Benefits?  

by meep

No, I’m not addressing the affordability of the program, etc.

I’m looking at: how much are people actually paid in Social Security benefits

Luckily, the Office of the Chief Actuary of the Social Security Administration has lots of information so we can get a good idea. I went here, clicked through...

Keep Reading...

Mornings with Meep: Data Visualization  

by meep

I review three books on data visualization, and try out a couple visualizations using some of the ideas from the first book, Storytelling with Data.

Keep Reading...

Alternative Assets and Pension Performance: A Dive into Data  

by meep

As promised in a prior post, I’m going to be digging into the many dimensions that drive public pension deteriorating status.

I have a news hook for this:

Pa. treasurer says ‘we have seen this movie before’ as pension system shifts toward costly hedge funds:

Pennsylvania’s $30 billion state pension fund...

Keep Reading...

New Project(s): Re-visualizing the Public Pension Database  

by meep

I’ve taken the data from the Public Pension Database and put it on kaggle – while I hope this will get a few other people dipping into this data, it’s more that I can put together some notebooks that others can get and look at….using tools a bit cooler...

Keep Reading...

Happy Halloween! Some Scary Public Pension Projections  

by meep

Do you want to see something really scary?

I have updated my public pension cash flow projection spreadsheet. You can get a copy of the latest version here.

I ran the 170 plans with updated data up to (possibly) fiscal year 2016, using data from the Public Plans Database.

The...

Keep Reading...

Geeking Out (and Illinois Pensions): Fixing a Graph and Assigning Blame for Underfundedness  

by meep

I used a graph last week that I knew was wrong (well, part of it was wrong).

It’s my graph of the unfunded liabilities of the 5 Illinois state-funded pension plans, and how it stacks up over time. I know I’ve mentioned this issue before — it doesn’t work well...

Keep Reading...