Forums

General Betting

Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
prestbury road
27 Nov 12 12:26
Joined:
Date Joined: 06 Feb 06
| Topic/replies: 280 | Blogger: prestbury road's blog
Can anyone help with this:

I want to take the goal expectancy of a football team and work out the price for them to score 0 goals, 1 goals, 2 goals, etc up to 5 goals.  I am prepared to assume that no more than 5 goals can be scored by the team to make the calculation easier.

I think its a binomial distribution problem, but I dont know how to input this into excel.

If anyone can help with a) the maths and/or b) inputting it into excel, I would be very grateful.

Thanks in advance
Pause Switch to Standard View Maths/Excel Question
Show More
Loading...
Report IanP November 27, 2012 12:47 PM GMT
Look at the POISSON.DIST function.
Report prestbury road November 27, 2012 1:14 PM GMT
Thanks Ian, got it sorted, your are right its poisson dist not binom dist, cheers
Report KOBEFROMDOWNTOWN December 12, 2012 4:41 PM GMT
Quick question for someone who knows more about 'simplify the surd' than I do.

3√14
----
√42   Any idea how you write this in its simplest form, showing your working?

Thanks in advance.
Report JLivermore December 12, 2012 4:51 PM GMT
what does this have to do with excel?

are those 4 dashes meant to reflect a division?

so (3√14)/(√42)?
Report Darlo Bantam December 12, 2012 4:55 PM GMT
More to the point is it a serious question?
Report KOBEFROMDOWNTOWN December 12, 2012 5:19 PM GMT
livermore that is correct.  I am posing the question on behalf of my sister.

It has nothing to do with excel.  The thread was dead so I didn't think it would be a problem posting the question on here.
Report JLivermore December 12, 2012 6:07 PM GMT
is this your sisters homework?
Report mouse trap December 13, 2012 8:19 AM GMT
(3√14)/(√42)=(3*√2*√7)/(√6*√7)=(3*√2)/√6

Wink
Report mouse trap December 13, 2012 8:24 AM GMT
(3√14)/(√42)=(3*√2*√7)/(√6*√7)=(3*√2)/√6=(3*√2)/(√2*√3)=3/√3=√3*√3/√3=√3
Report JLivermore December 13, 2012 9:13 AM GMT
or

(3√14)/(√42)=(3√14)/√(3*14)=(3√14)/(√3√14)=3/√3=√3
Post Your Reply
<CTRL+Enter> to submit
Please login to post a reply.

Wonder

Instance ID: 13539
www.betfair.com