Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
#NAME? and other results. | Excel Discussion (Misc queries) | |||
SUM and IF results | Excel Worksheet Functions | |||
Predicting a Number From a Time Series | Excel Worksheet Functions | |||
Conditional Sum Argument results do not equal cell results Excel | Excel Worksheet Functions | |||
Predicting new Ys given new Xs using known relationship for X and | Excel Discussion (Misc queries) |