Sunday, 30 October 2016

Quibans 44: Glastonbury

Glastonbury 2017 tickets sell out in less than an hour as music fans complain about festival website crashing
Bad news for anyone still hoping to make it to Glastonbury Festival 2017: over 100,000 tickets sold out this morning before 10am, amid complaints that the ticketing website was crashing
The coveted tickets were released this morning at 9am and were all gone before 10.  The festival organisers posted the tweet below, breaking the news to disappointed music fans, at 9.54am.

A smaller batch of  15,000 tickets with coach packages, released on Thursday last week, are also all gone, selling out within 23 minutes.

Questions:
  1. What is the rate at which the tickets sold?
  2. What is the rate at which the ‘tickets with coach packages’ sold?
  3. What is the combined rate for both types of ticket?
  4. How long did each standard ticket take to sell?
  5. How long did each ‘ticket with coach package’ take to sell?
  6. How long did each ticket take to sell on average?


Comments:
It is necessary to choose units here.  This could be ‘number of tickets per minute’ (or per second, or per hour).  The other big idea is that when combining both types of ticket we can’t just take the average.  We need to use the total number of tickets divided by the total time.



Quibans 43: Buy Apple in the Big Apple

A news website called Fast Company has this:

Due to Apple price hikes in the U.K., it’s now cheaper for Brits to fly round-trip to the U.S. to buy a MacBook Pro
On Thursday, Apple raised prices by as much as £500 on its products sold in the U.K.—thus making it cheaper to buy a round-trip ticket to the U.S. or Canada to buy your latest device and fly back to London, reports the Financial Times. For example, a MacBook Pro just jumped in price from £2,499 to £2,999,



Question:
1)  Is it true?   Here’s an opportunity to do some research and to find out.
2)  Are there any other products for which this is true too?
You might want to display the headline only and to ask for comments about that.  This appears to come from a Financial Times article, but that is paywalled. 


Comments:
2)  Various other things have risen in price (reportedly) recently, from Marmite to tea bags.  Presumably it doesn’t make sense to fly to the USA to save 20p on a jar of Marmite.  It also doesn’t seem sensible to buy a fridge in the US because the cost of shipping it to the UK would more than wipe out any saving.  A car would also have shipping costs, but worse than that it would be incompatible with the UK, because the steering wheel would be on the ‘wrong’ side (while legal to drive it would be annoying).  Which other goods fall into these categories?
Small electronic devices (like laptops and iPads) would seem to be ones it would be sensible to fly to the US to buy.  Are these the only things?



Saturday, 29 October 2016

Quibans 42: Brexit 1

A Daily Telegraph article about Brexit featured this graphic:




We did lots of things with this.

Questions:
1) Which country is each of the ‘financial capitals’ in?
2) We know the number of financial employees and the % of total employment that is financial services, so how many workers are there altogether?
3) What is the percentage increase/decrease in rent if you move from London to each of the other cities?
4) Comment on the diagrams that are used.
5) In which country is beer overpriced?

Comments/Answers:
1) We talked discussed the reasons why Berlin isn’t the financial centre of Germany.
2) We divided the first column by the percentage column and expected that this would give the population of the city. The numbers seemed to be far too big. We then decided that the percentage column (financial services as a percentage of total employment) is actually a percentage of the whole country and not the city.
3) This was straightforward.
4) Comment on the diagrams:
a. Number of financial employees: seems to use area – this is appropriate.
b. Financial services as a %: the whole bar is 18.6% – the rest are compared to this.
c. The beer seemed particularly odd. The cost of one pint of beer is shown with several full and partially filled pint glasses, where each full glass stands for £1. It seems rather odd to have 3½ pint glasses standing for the £3.46 price of one pint.
d. We didn’t like the taxi graphic much either.
5) To find out where beer is overpriced we compared the price of a pint to the taxi journey in each country and also to the average rent.

Source: http://www.telegraph.co.uk/business/2016/10/11/the-city-exodus-is-already-happening-it-just-doesnt-look-like-yo/




Friday, 28 October 2016

Quibans 41: Phil Collins

From the Daily Telegraph:

Phil Collins and the rise of mid-lifers drinking their way to oblivion
For Phil Collins it started at home in the long afternoons, drinking a glass of two or wine in front of the England versus West Indies Test match.  In 2011 the former Genesis frontman had decided to retire from music and move to Switzerland to devote himself to his family."I stopped work because I wanted to be a dad at home,” he said in a press conference on Monday in which he announced a comeback tour. “As bad luck would have it, as soon as I retired, my family split up. I didn't have anyone to go home to. That's why I started drinking."


Questions:
1)  How much is one unit of neat alcohol?
2)  How many units will 1 litre of each drink contain?
3)  If someone drinks 15 units in a week then it ought to be spread over 3 days.  That suggests 5 units as a maximum in one session.  How many of each drink is that?
[To be clear: drinking lots wasn't a good thing for Phil Collins.  Don't try this at home.]

Here is the table again, suitable for copying and pasting into a spreadsheet:
Drink
ABV*
Size
Alcohol
ABV
Size in ml
Units of alcohol
Wine
14%
125ml glass
1.8 units
14%
125
1.8
Wine
14%
175ml glass
2.5 units
14%
175
2.5
Wine
14%
250ml glass
3.5 units
14%
250
3.5
Wine
14%
750ml bottle
10.5 units
14%
750
10.5
Beer
2.80%
Pint
1.6 units
2.8%
568
1.6
Strong beer
4.80%
Pint
2.7 units
4.8%
568
2.7
Vodka
40%
25ml shot
1 unit
40%
25
1
Vodka
40%
50ml double
2 units
40%
50
2
Flavoured cider
4%
330ml bottle
1.3 units
4%
330
1.3


Answers:
It appears from the spreadsheet that 10ml of alcohol is 1 unit.  Note the rounding errors. 
Note also how the rounding errors affect the number of units that are in 1 litre of wine, as calculated from the different glass/bottle sizes.

Drink
ABV*
Size
Alcohol
ABV
Size in ml
Units of alcohol
Amount of alcohol
Drinks for 5 units
Units in 1 litre
Wine
14%
125ml glass
1.8 units
14%
125
1.8
17.5
2.8
14.4
Wine
14%
175ml glass
2.5 units
14%
175
2.5
24.5
2
14.3
Wine
14%
250ml glass
3.5 units
14%
250
3.5
35
1.4
14
Wine
14%
750ml bottle
10.5 units
14%
750
10.5
105
0.5
14
Beer
2.80%
Pint
1.6 units
2.8%
568
1.6
15.904
3.1
2.8
Strong beer
4.80%
Pint
2.7 units
4.8%
568
2.7
27.264
1.9
4.8
Vodka
40%
25ml shot
1 unit
40%
25
1
10
5
40
Vodka
40%
50ml double
2 units
40%
50
2
20
2.5
40
Flavoured cider
4%
330ml bottle
1.3 units
4%
330
1.3
13.2
3.8
3.9

Quibans 40: Tom (Cruise + Hanks)

From the Guardian:
Cruise and Hanks: from golden boys to wasted talents
The two Toms are the last 80s superstars still able to open a movie on their name alone. But movies such as Inferno and Jack Reacher confirm their descent into dependability
 Statistically speaking, there must be some people who are desperate to see Inferno, the third Ron Howard film to star Tom Hanks as a “symbology” professor who saves the world by misinterpreting paintings. By the same token, some people must be counting the days until they can watch Tom Cruise breaking strangers’ limbs again in Jack Reacher: Never Go Back – an eyebrow-raising subtitle for any sequel. But are these airport-paperback adaptations, both released in October, really the most productive use of their stars’ time? Given that Hanks is now 60 and Cruise is 54 – and that they wouldn’t need any more money if they lived to 1,000 – shouldn’t they be doing something more worthwhile than prolonging a couple of second-rate action franchises?

What can we do with this?  The part that caught my eye is the “wouldn’t need any more money if they lived to 1,000”. 

I suggest we model/explore this in increasingly sophisticated ways.  (You might want to focus on just one of the Toms rather than both.)

Version 1: 
Assume that the cost of living stays the same as it is now and work out how much people need to live over 1,000 years.  Work this out for a ‘subsistence level’ and for a ‘luxury level’ of living.

Version 2: 
Factor inflation into this.  Assume different values of inflation.

Version 3: 
Look up the worth of Cruise/Hanks and consider the effect that different values of interest rates on their bank account and inflation will have. 

Version 4: 
How much money do you need to have in 2016 to ensure not only that you never need to work again but that your great-grandchildren don’t need to work?  What about your great-great-grandchildren (g^2-grandchildren)?  What about … g^n-grandchildren?


Information that might be useful (although you may want students to search for this themselves – and the values will change over time):
According to http://www.therichest.com/top-lists/top-100-richest-actors/ Tom Cruise is worth $480 million and Tom Hanks is worth $350 million.  (Clearly, I have no idea how accurate this is, whether this is career earnings, or whether they have looked at tax returns, or bank accounts, etc.)
The exchange rate is currently £1 = $1.21
Inflation is currently at 1% in the UK.
The average salary in the UK is £26,500


Possible answers
Version 1: 
Cruise is worth about £400 million and Hanks £290 million (we need to round off after dividing by 1.21).  At the average UK salary of £26,500 this gives 15,000 years for Cruise (TC) and 11,000 for Hanks (TH).
If you want the money to last for 1000 years (from now – I won’t quibble over the current age of the actors) then that gives £400,000 (TC) and £290,000 (TH).
If you want £100,000 per year then 4000 years (TC) and 2900 (TH).

Version 2: 
If we factor inflation into this we find that the compounding factor makes things worthless before 1000 years is up.  If we start with £26,500 and increase it by 1% each year then after 1000 years the total will be £56 billion.  I used a spreadsheet to keep track of this.  After 473 years TH would run out of money and TC would last for 505 years.

Version 3: 
Clearly, if they can get exactly the rate of inflation in investments then the first scenario will hold true.  If they can get a return that is better than inflation then things will be fine.

Version 4: 
If we assume that everyone has two children at the age of 25 and lives to be 75 years old, then ensuring everyone had £100,000 per year would mean the generations up to and including the great-great-grandchildren (of which there are 16) would need a total of £310 million.
A spreadsheet is a good plan for this …


Quibans 111: How much energy and water do our AI tools really use?

Here is how I used the article below from the Times.  Before showing the article, I started with this information and these questions: Mic...