World Cup Prediction Competition

Has anyone let Excel decide on the results by using RANDBETWEEN(0,?)?
I'm thinking perhaps the machine would be better at predicting scores than I am........

You're right, it works ;)
Book4
ABCD
1Scotland05England
Sheet1


Dom
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
For the analysts here, JP Morgan's quant approach to the predictions might be interesting:

http://www.e696.com/data/0000002A0518J3.pdf

...and for the wannabe-quants, might prove a painless introduction.

England are going to win, apparently, which probably explains the recent global financial crisis.
 
You're right, it works ;)
Dom

When I did that, it knocked out France, Argentine, Netherlands, Germany and Brazil in the group stages. Brazil got 0 points. England got through with Slovenia, which sounds about right.
 
Anybody who hasn't entered but still intends to.....you have another 24 hours - I will attempt to post all the predictions back here - if you want you can update the scores and see how you are doing.....

Good Luck
 
Is that the same model that they used to calculate the risk on their derivaties?
Given that it was especially written for the world cup, I'd say that it's a newer, upgraded version.
 
Newer, upgraded maybe, but they say in ther paper

• Quant Models are mathematical methods built to efficiently screen and
identify stocks.
• They are based on information and data (analyst upgrades, valuation
metrics etc) proven to help predict stock returns.
• Having developed a rather successful Quant Model over the years, we
intend to introduce it to our readers and also use its methodology to
apply it to a fruitful field for statistics: Football and the World Cup.

That suggests to me that it is their old risk model adapted, and that was a proven success wasn't it.
 
e-mail sent

Scotland is now officialy participating in the World Cup.

Bertie
 

Forum statistics

Threads
1,222,636
Messages
6,167,218
Members
452,104
Latest member
jadethejade

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top