ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Predicting results (https://www.excelbanter.com/excel-worksheet-functions/206181-predicting-results.html)

Alfredo_CPA

Predicting results
 
Im trying predicting some sport results (14). I know I can predict very well
some of them ((lets say 10) but I know some are very hard to predict. Let say
the price is $50.00 and each bet cost me $0.10. So Im planning to bet as
many times as needed to cover all possible results for the games I dont fell
comfortable with. Example
My first bet: Will be my 10 good choices plus the other 4 with the home team
as winner (it cost me $0.10)
My second bet: Will be my 10 good choices plus the other 4 with the visitor
team as winner (it cost me $0.10)
My third bet: Will be my 10 good choices plus the first of the 4th with the
home team as winner and the other 3 as visitor winners (it cost me $0.10)
Etc,

I need a formula where I can change the number of total games, the number of
€śgood choices€ť and the number to unknown results. The result of the formula
should give me how much money I need to put to see if is a lot less than the
possible price


Any ideas?

Thanks



Glenn

Predicting results
 
Alfredo_CPA wrote:
Im trying predicting some sport results (14). I know I can predict very well
some of them ((lets say 10) but I know some are very hard to predict. Let say
the price is $50.00 and each bet cost me $0.10. So Im planning to bet as
many times as needed to cover all possible results for the games I dont fell
comfortable with. Example
My first bet: Will be my 10 good choices plus the other 4 with the home team
as winner (it cost me $0.10)
My second bet: Will be my 10 good choices plus the other 4 with the visitor
team as winner (it cost me $0.10)
My third bet: Will be my 10 good choices plus the first of the 4th with the
home team as winner and the other 3 as visitor winners (it cost me $0.10)
Etc,

I need a formula where I can change the number of total games, the number of
€śgood choices€ť and the number to unknown results. The result of the formula
should give me how much money I need to put to see if is a lot less than the
possible price


Any ideas?

Thanks




The number of bets necessary is two to the power of the number of unknown
results (2^x). The number of "good choices" or total number of games is irrelevant.

Unknown Results Bets Required
1 2
2 4
3 8
4 16
5 32

Alfredo_CPA

Predicting results
 
Thanks Glenn, I was complicating a very simple task.
Thanks for put me back in the right track

--


"Glenn" wrote:

Alfredo_CPA wrote:
Im trying predicting some sport results (14). I know I can predict very well
some of them ((lets say 10) but I know some are very hard to predict. Let say
the price is $50.00 and each bet cost me $0.10. So Im planning to bet as
many times as needed to cover all possible results for the games I dont fell
comfortable with. Example
My first bet: Will be my 10 good choices plus the other 4 with the home team
as winner (it cost me $0.10)
My second bet: Will be my 10 good choices plus the other 4 with the visitor
team as winner (it cost me $0.10)
My third bet: Will be my 10 good choices plus the first of the 4th with the
home team as winner and the other 3 as visitor winners (it cost me $0.10)
Etc,

I need a formula where I can change the number of total games, the number of
€śgood choices€ť and the number to unknown results. The result of the formula
should give me how much money I need to put to see if is a lot less than the
possible price


Any ideas?

Thanks




The number of bets necessary is two to the power of the number of unknown
results (2^x). The number of "good choices" or total number of games is irrelevant.

Unknown Results Bets Required
1 2
2 4
3 8
4 16
5 32



All times are GMT +1. The time now is 03:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com