Jump to content

File:USS pension fund percent funded.png

Page contents not supported in other languages.
This is a file from the Wikimedia Commons
From Wikipedia, the free encyclopedia

Original file (1,174 × 693 pixels, file size: 76 KB, MIME type: image/png)

Summary

Description
English: A plot of the USS ("Universities Superannuation Scheme") pension fund deficit across time.

https://en.wikipedia.org/wiki/Universities_Superannuation_Scheme

R code to create graph

library(ggplot2) library(cowplot)

  1. ============================
  2. = data read and formatting =
  3. ============================

fp = "~/Desktop/USS_pension_assets_and_liabilities.xlsx" df = gdata::read.xls(xls = fp, stringsAsFactors=FALSE, sheet="transposed") df$Year = as.Date(paste0(df$Year, "-03-01")) df$percent_funded = df$percent_funded *100 as.numeric(df$Year)

  1. ==================
  2. = Construct Plot =
  3. ==================

p = qplot(Year, percent_funded, data= df) p = p + geom_smooth(method = "auto", se = TRUE) p = p + labs(title= "USS Balance sheet", x = "Year", y = "Percent of scheme funded") p = p + geom_hline(yintercept = 100, color = "red")+ theme(text = element_text(size = 13)) p = p + scale_x_date(date_breaks = "1 year", date_labels = "%Y", minor_breaks = NULL) p = p + draw_label("2011 Changes", x = 15034, y = 102, hjust = 0, vjust = 0) p = p + draw_label("2015 Changes", x = 16495, y = 90, hjust = 0, vjust = 0)

p
Date
Source Own work
Author Tim bates

Licensing

I, the copyright holder of this work, hereby publish it under the following license:
w:en:Creative Commons
attribution share alike
This file is licensed under the Creative Commons Attribution-Share Alike 4.0 International license.
You are free:
  • to share – to copy, distribute and transmit the work
  • to remix – to adapt the work
Under the following conditions:
  • attribution – You must give appropriate credit, provide a link to the license, and indicate if changes were made. You may do so in any reasonable manner, but not in any way that suggests the licensor endorses you or your use.
  • share alike – If you remix, transform, or build upon the material, you must distribute your contributions under the same or compatible license as the original.

Captions

Add a one-line explanation of what this file represents

Items portrayed in this file

depicts

4 March 2018

File history

Click on a date/time to view the file as it appeared at that time.

Date/TimeThumbnailDimensionsUserComment
current19:34, 4 March 2018Thumbnail for version as of 19:34, 4 March 20181,174 × 693 (76 KB)Tim batesUser created page with UploadWizard

The following page uses this file:

Metadata