Duke of Marmalade
Registered User
- Messages
- 4,596
Just stumbled on this thread. Can I suggest that dub_nerds excellent post from a previous thread is promoted to Key Post status. This is by way of update. I will work with 100k. Assuming all prizes are €50 the annual expected return is 0.60% i.e. 12 wins. So taking Rabo 90 day deposit just for argument I only need to win 5 times in a year to beat that. Using the Poisson distribution (which is a perfectly acceptable approx for the binomial here) I reckon the chances of not beating that are less than 1%.Ultimately, prize bond returns are down to luck and nothing more...
I unfortunitely don't tend to be very lucky so I don't see myself putting much into prize bonds anytime soon.
Actually, I'd like to suggest that dub_nerd gets sent to the dunce's corner!Can I suggest that dub_nerds excellent post from a previous thread is promoted to Key Post status.
The Poisson distribution just reproduced all my carefully calculated discrete odds to four decimal places! Looks like my efforts were a bit misdirected.Using the Poisson distribution (which is a perfectly acceptable approx for the binomial here) I reckon the chances ...
I don't know why you are beating yourself up. Your original post is a classic.Actually, I'd like to suggest that dub_nerd gets sent to the dunce's corner!
You mean this one. Yeah, I'm just embarrassed how much work it took to produce those graphs when your Poisson distribution does it perfectly well.I don't know why you are beating yourself up. Your original post is a classic.
Yep, that's the one. Posting an online link using 300,000! could crash the World Wide Web.You mean this one. Yeah, I'm just embarrassed how much work it took to produce those graphs when your Poisson distribution does it perfectly well.
EDIT: on the up side, I can finally produce a Google Sheet that let's people do the calculation for themselves. My original method involved factorials too large for any spreadsheet.
Excel and Google Sheets both croak above 170!Posting an online link using 300,000! could crash the World Wide Web.
Are you saying you can now post a Poisson friendly tool?
As an actuary the duke is well used to using Poisson for example in modelling mortality outcomesFinally! Just found the piece of the puzzle I'd been missing ... the Poisson Limit Theorem.
(And I get it, so maybe exiting the dunce's corner)
Ok, try this one for size. Enter a new value in the investment amount cell. May take a couple of seconds for the chart to be re-centred to show columns with values > 0.1%. Anyone can edit, so it may behave a bit strangely if multiple people do it at the same time.Your data is in tabular form, I have supplied a calculator for individual sums, albeit it needs a bit more effort by the user.
We use cookies and similar technologies for the following purposes:
Do you accept cookies and these technologies?
We use cookies and similar technologies for the following purposes:
Do you accept cookies and these technologies?