Anyone know how to do this for Powerball combinations?Prev TopicNext Topic

• LottoNick56

  

  Tampa, FL
  United States
  Member #121,758
  January 16, 2012
  188 Posts
  Offline
  Apr 26, 2013, 6:12 pm

  ▲▼

  I want to be able to figure out only combinations that exist in the 85% effective percentage range of 130-179 without the powerball so that I can only choose from the combinations that yield the most times drawn.  By doing so I can throw out any combination that exists that does not fit into my pre-determined play range.I know this will still yield A LOT of combinations, but at least it will be fewer than including all combinations.  Does anyone know how this can be created in excel?  Thanks. 

  NOTE Effective Percentage Of Suggested 85% Position Frequency Ranges For Winning Jackpots For SUM Ranges
  SUMS w/o POWERBALL	Number of Times Drawn Within 85 Percent Position Frequency	Effective Percentage
  15 - 89	0	0.0000
  90 - 99	0	0.0000
  100 - 109	10	45.4545
  110 - 119	16	55.1724
  120 - 129	30	78.9474
  130 - 139	43	95.5556
  140 - 149	42	89.3617
  150 - 159	40	90.9091
  160 - 169	37	92.5000
  170 - 179	33	84.6154
  180 - 189	26	65.0000
  190 - 199	12	40.0000
  200 - 209	3	18.7500
  210 - 219	0	0.0000
  220 - 229	0	0.0000
  230 - 285	0	0.0000

  ...Someone's going to win eventually...

  ...Never know, could be me...