General Betting
There is currently 1 person viewing this thread.
27 Nov 12
12:26
Joined:
Date Joined:
06 Feb 06
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
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
sort by:
Show
per page
Replies: 10
|
By:
Look at the POISSON.DIST function.
|
|
By:
Thanks Ian, got it sorted, your are right its poisson dist not binom dist, cheers
|
|
By:
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. |
|
By:
what does this have to do with excel?
are those 4 dashes meant to reflect a division? so (3√14)/(√42)? |
|
By:
More to the point is it a serious question?
|
|
By:
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. |
|
By:
is this your sisters homework?
|
|
By:
(3√14)/(√42)=(3*√2*√7)/(√6*√7)=(3*√2)/√6
 |
|
By:
(3√14)/(√42)=(3*√2*√7)/(√6*√7)=(3*√2)/√6=(3*√2)/(√2*√3)=3/√3=√3*√3/√3=√3
|
|
By:
or
(3√14)/(√42)=(3√14)/√(3*14)=(3√14)/(√3√14)=3/√3=√3 |