London

81 Chancery Lane
London
WC2A 1DD
01235 821 160
View map

Edinburgh

1 Lochrin Square
92 Fountainbridge
Edinburgh
EH3 9QA
01235 821 160
View map

Dublin Office

24A Baggot Street, Upper
Dublin 4
Ireland
D 04 N5 28
01235 821 160
View map

Administrative Office

BH Office
Church Street
Ardington
Wantage
Oxfordshire
OX12 8QA
01235 821 160
View map

Send us a message
CLOSE X
Contact Us
01.06.2018

Just How Expensive is it to Complete the Panini World Cup Album?

Panini stickersWith the 2018 Football World Cup approaching amidst great excitement, in some quarters at least there is surely just as much enthusiasm for the accompanying Panini sticker album. There are 682 empty spots in the book waiting to be filled and the local newsagent will surely do a roaring trade in those pocket-money packets of stickers.

But how much does it really cost to fill the album completely? At a very minimum, you’d need 137 packets of 5 stickers at 80p each. That’s £109.60. And a swift back-of-the-envelope calculation will show that the chance of never getting a repeat sticker in all 137 packets is vanishingly small, much less likely than winning the lottery. So what’s a realistic estimate? What if we have friends to swap our spares with? And what would a good or a bad case scenario look like?

As actuaries, there’s really only one thing for it. Start by doing the maths and then, when that becomes too complex to handle neatly, build a model.

The Question

So what exactly is the question we’re trying to answer here?

The initial problem is as follows:

Suppose we start with an empty album and collect stickers one at a time. We know that the first sticker will be new, since we don’t have any yet. But after that, there’s a chance of getting a repeat. If we currently have k unique stickers, then the chance of the next sticker being a new one is (682–k)/682. On average, when we currently hold k stickers, we’ll therefore have to wait for 682/(682–k) more stickers before we see a new one.

If we assume all stickers are equally likely and independent of one another, we can simply sum these waiting times to get a total expected number of stickers as follows:

\(\begin{align}\sum\limits_{k=0}^{681} \frac{682}{(682-k)}\end{align}\)

That’s a total of around 4,844 stickers, or £775.08.

Scenario 1 – the base case

But we buy stickers in packets of five, not one at a time.

This leads us on to consider the base case. This is the setup whereby one individual collector buys packets of stickers one at a time until their album is complete.

In contrast to the original assumptions, we actually know that stickers are not all independent of one another. In particular, we can add the following assumptions to our problem setup:

Now the problem becomes more complex, because at each point in the calculation we need to consider where we’ll be in five stickers’ time (one pack later), rather than just one sticker’s time.

To work this out, let’s start at the end and suppose for the moment that we have all but one of the stickers. Then in each new packet, we have a 5/682 probability of getting the one we’re missing. Therefore, on average, from this point we’ll need to buy 682/5 = 136.4 more packets. Let’s call that e681, the expected number of packets we need given we currently hold 681 unique stickers.

We also know that e682 = 0, because at that point we already hold all the stickers.

The next step is to think about what happens if we currently hold 680 stickers. At this point, there are three possibilities for our next packet of stickers: we’ll get no new stickers, or just one new sticker or we’ll get both of the missing stickers. We can calculate the probabilities of these options fairly easily, knowing that all stickers are equally likely. Call pk,i the probability of getting i new stickers in the next packet given we currently hold k unique stickers.

So from 680 stickers, our expected number of packets to completion can be expressed as:

\(\begin{align}e_{680} = 1 + p_{680, 0} \times e_{680} + p_{680,1} \times e_{681} + p_{680, 2} \times e_{682}\end{align}\)

Given what we know already, we can solve this for e680.

In fact, we can repeat this approach for k = 679, 678, all the way back to k = 0 using the following recursive formula:

\(\begin{align}e_{k} = 1 + \sum\limits_{i=0}^{5} p_{k, i} \times e_{k+i}\end{align}\)

Or equivalently:

\(\begin{align}e_{k} = \frac{1}{1-p_{k,0}} \times \left( 1+\sum\limits_{i=1}^{5} p_{k,i} \times e_{k+i} \right)\end{align}\)

This gives us a total expected number of packets needed (e0) of about 966.4, or a cost of £773.12. So the fact that all five stickers in a packet are different from one another doesn’t save us much!

We can use a similar method to calculate other features of the distribution in this base case.

MomentNo. packetsTotal cost
Mean966.4£773.12
Standard deviation173.8£139.03
Skewness1.151.15
Excess kurtosis2.432.43

 

We can see from this that not only is the expected cost pretty high, but also that there’s a lot of variability around this expectation. The skewness of around 1 shows us that the distribution is asymmetric and positively skewed (a feature we also see clearly in the later graphs). The positive excess kurtosis tells us that the tails of this distribution are relatively heavy – meaning that we have quite a big chance of seeing extreme outcomes.

This suddenly stops looking like a pocket money hobby, and more like one you’d need a well-paid full-time job to sustain!

The model

Had enough of all this probability and fancy notation? Let’s build a model.

Fortunately for all the enthusiastic collectors out there, there are ways of bringing the costs down. To investigate these, the next step is to build a model. The model used here is built in VBA, as this is used commonly across different areas of actuarial work, but it could easily be built using other software. Using this model we can look at a full range of outcomes over a large number of simulations.

The histogram below shows the results of a ‘base case’ run on 10,000 simulations. The height of each bar represents the number of simulations which fell within each cost category.

MomentNo. packetsTotal cost
Mean965.97£772.76
Standard deviation174.49£139.59
Skewness1.161.16
Excess kurtosis2.582.58

 

 

From this we can see the result of every one of our 10,000 simulations plus some summary statistics. Reassuringly, the various moments of this distribution are pretty close to the ones calculated earlier!

You can see from the histogram that the total cost ranged from around £500 up to more than £1,500. In 10,000 simulations of filling the book, barely any cost the collector less than £500 – a far cry from the £109.60 that we might have hoped for at the very start. We can also look at the percentiles; half of the time, the cost was over £750 and in more than 1-in-20 cases the cost was over £1,000. Even somebody who was in the ‘luckiest’ 5% of collectors would be paying around £600.

Scenario 2 – the swapsie

Everyone in the office is collecting / all of the kids in your child’s class have an album. How much do ‘swapsies’ save you?

The benefit of building the model is that it then becomes relatively easy to adapt and consider different setups and scenarios. In this case we can adjust the model to allow for sharing with other collectors and fortunately for you (or your child), this does translate to significant savings.

The output below is a result of a run which is as per the base case, but with 5 friends swapping. It is based on the assumptions that everyone starts with an empty album and they continue buying packets until they have 5 complete albums between them. This shows the mean cost per person. In this run there were 1,000 simulations.

Notice the change of scale on the x-axis.

 

MomentNo. packetsTotal cost
Mean411.75£329.40
Standard deviation48.31£38.65

 

 

We can see here that the average cost is less than half of what it was in the base case. In this case, collectors have a decent chance of spending less than £300 and none of our 1,000 simulations saw the cost rise above £550. Not only do we see a significant saving in costs, but also a much smaller standard deviation of costs, so we can be more certain that our actual cost will be close to our expected cost.

Scenario 3 – the cheat

You can buy 50 stickers direct from Panini – does this save you much money?

The next scenario to consider is that it is possible to buy the last few stickers to complete the album direct from Panini. Starting again from the base case, we here add the following assumptions:

Here, the ‘Number of packs’ column tells us how many packets were purchased, whereas the ‘Cost’ column is the total cost of packets plus individual stickers bought directly.

This run was completed on 10,000 simulations. See the output below (notice again the change in scale):

MomentNo. packetsTotal cost
Mean354.51£294.58
Standard deviation16.21£12.97

 

 

Again, you can see the expected cost falling enormously, to significantly less than half the base case. The variance of outcomes is also very narrow.

This might seem counter-intuitive, given that 50 stickers represent far less than a tenth of the book, and yet buying these directly saves over 60% on expected cost. This happens because the more stickers you have, the less and less likely it becomes that the next sticker will be new. As we saw in the first section of this article, the last sticker alone takes us an average of 136 packets to find (in the base case). Cutting off that tail end of the search saves an enormous amount of money.

Scenario 4 – the shiny

What if you’re convinced there’s a conspiracy, and that you’re only half as likely to get a ‘shiny’ as any other sticker?

Now Panini stress (see http://collectibles.panini.co.uk/company/curiosity.html#c606) that all stickers are printed in the same quantities, and we certainly aren’t disputing this claim – so our base case assumes that all 682 stickers are equally likely to appear in any packet.

But a quick internet search suggests that many collectors insist that this isn’t the case and that some stickers – perhaps the most popular players or the team photos – are rarer than others. This scenario looks at how, if that were the case, the costs would be impacted.

This scenario has the same setup as the base but with the following additional assumptions:

Of course, there are any number of possible combinations here. Maybe you think that the Germany squad stickers are only a quarter as likely as any other, in which case we could set the model up with 18 ‘rare’ stickers and a ‘rare probability’ of 25%. However, this example should give an idea of the impact.

This scenario has been run over 5,000 simulations. Again, note the scale.

MomentNo. packetsTotal cost
Mean1,222.70£978.16
Standard deviation303.38£242.70

 

 

It might not be much of a surprise to learn that introducing rare stickers makes the whole project more expensive – now close to £1,000 on average. For 1-in-100 collectors that cost is now over £1,750. The variance of outcomes has also increased.

Scenario 5 – the game

So now let’s put this all together

Finally, how do all of these features interact? This scenario combines the ones considered earlier. It’s as per the base setup but with:

MomentNo. packetsTotal cost
Mean188.33£161.65
Standard deviation3.71£2.97

 

 

And finally…

This article ends with apologies to anyone that has been put off of collecting stickers having found out how costly it really is (similarly to anyone who feels this level of mathematical analysis takes the fun out of it all)! However, armed with this information, those still determined to continue should now be able to go ahead and complete their album in the most cost-efficient way possible. Best of luck to you – you will need it!

The Excel model used in these projections can be downloaded here. Please do play around, try out your own scenarios and let us know of any interesting observations or feedback on the model.  On the published version we have protected the VBA code, but if you would like a copy of the unprotected version do get in touch with us via our contact page and we’d be happy to send you a copy.

Sammy Ford

June 2018

Sammy Ford