I have a series of numbers that I know the long-term probability for and I would like to predict the next number(s). There are 1320 possible outcomes listed in sheet 2 column e2 to e1321. I have 18370 trials in sheet1 column g2 to g18371, and I would like to predict (or find the most likely) outcome for next trial(s). The probabilities are listed as 809.06 (1 in 809.06 trials) or 566.57 (1 in 566.57 trials) and range from 96.64 to 47619.05001. Is there a way to do this?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Predicting next number in a series
- Thread starter twalters1
- Start date
-
- Tags
- predict probability
Similar threads
- Question
