Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 45
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,240
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 45
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
#NAME? and other results. Narendra Boga[_2_] Excel Discussion (Misc queries) 3 July 21st 07 01:26 PM
SUM and IF results David Excel Worksheet Functions 5 June 12th 07 03:17 AM
Predicting a Number From a Time Series Carl Excel Worksheet Functions 4 August 31st 06 08:51 AM
Conditional Sum Argument results do not equal cell results Excel Randy R Mullins Excel Worksheet Functions 3 August 9th 06 07:16 PM
Predicting new Ys given new Xs using known relationship for X and malwatson Excel Discussion (Misc queries) 2 January 12th 05 09:07 PM


All times are GMT +1. The time now is 05:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"