Using Excel for Mega Millions?

Reply #3

Just6ntlc — Mon, 13 Feb 2006 18:18:13 GMT

Welcome back Kristin. I usually pick my own numbers in my MM and PB predictions based upon the hot/cold numbers and overdue numbers. In MM, I usually look at my document for their history in seeing which numbers haven't been the winning numbers of both WB and MB to see which numbers are left. Then in my MM predictions, I usually pick those numbers.

Reply #2

hypersoniq — Sat, 11 Feb 2006 13:49:25 GMT

welcome back Kristin.

I remember a thread where the late kbcherokee was explaining the bell curve with regards to mega millions picks. I had spent several years toying with median/mode/average/forecast and backtesting (checking against past results) was never impressive.

I work with the powerball and I am trying to update/refine the bell curve , if you send me your mega history I will put those numbers into my powerball excel sheet and send it back to you and maybe we could work on it,

Reply #1

time*treat — Sat, 11 Feb 2006 06:08:44 GMT

Two questions to start with: Do you prefer macros, or spreadsheet formulas? Do you have an idea for a system

Using Excel for Mega Millions?

Kristin — Sat, 11 Feb 2006 02:10:24 GMT

I haven't been here in a while, but I was thinking about playing tonight's game. I have been reading on some of the posts from the passed on members using Excel for games such as Mega Millions etc......

I was wondering how can I use excel to pick numbers that are frequently being played in excel? I have put all of the passed drawings already in a spreadsheet and I have included rows such as Median, Mode, Range etc...... Can anyone tell me what to do next