User Tools

Site Tools


public:on_uea_gig_ticket_price_and_ftse_100

This is an old revision of the document!


On UEA Gig Ticket Price and FTSE 100

Please don't take any of the findings too seriously!

Abstract

By analysing The Gig List 1), I discovered that a ticket to a UEA SU's gig has been increasing on average 7.57%, since sterling decimalisation 2) This is higher than the inflation rate in most years. I also compared the price inflation of the gig ticket against FTSE 100. I discovered that between 1985-01-01 and 2017-01-01, FTSE 100 on average has grown by 309%, while average UEA gig ticket price has grown by 936%. This means that if UEA SU was a commercial organisation, it might have been more effective to invest in UEA SU than an index fund linked to FTSE 100.

Finally, some of these results were presented on Instagram and Concrete Confession. Reaction from others have been fairly interesting. The way these data get presented can certainly affect people's opinion of UEA SU.

Background

On Friday evening, I played Scrabble with AV. I threatened to write a program to solve Scrabble, because I was so bad at playing that game. Writing a Scrabble solver is a two part problem - first you need an anagram solver, second you need to search through the board to find the highest scoring solution. But then I discovered Scrabble solver on the Internet, which I gave me a massive boost, and I managed to defeat AV in one game. However, cheating makes the game so boring. The problem solving part of my brain was active, I was actively looking for problems to solve.

After AV has left, I arrived at UEA SU shop to get some snacks. I discovered a book named The Gig List, which contains the list of gigs played in UEA venue between 1966-02-22 to 2018-07-20. I immediate realised the historical significance of this book. It is a good tool for economics research I came up with the idea of investigating how the price of gigs changed over time.

Objective

  1. Convert The Gig List from a paper format to a textual format.
  2. Import The Gig List into Microsoft Excel, to plot a graph to show how price has changed over time.
  3. Analyse the graph.
  4. Disseminate findings from the analysis.
public/on_uea_gig_ticket_price_and_ftse_100.1574026405.txt.gz ยท Last modified: 2019/11/17 21:33 by fangfufu