The professor is making fun of you. Each drawing is totally independent of
previous results, so looking at the statistical frequency of earlier drawing
is a fools ploy.

The probability of winning the megamillions, for example, is the number of
combinations of sets of 5 numbers drawn from 52 (numbers 1 - 52 are possible
and non-repeating) times the number of power power/mega numbers (again, 52
as I recall ; 1 - 52).

=combin(52,5)*52

This produces 135,145,920

Just like is advertised on

http://www.megamillions.com/howtoplay/game_faq.asp pick how to win


--
Regards,
Tom Ogilvy


"Timothy Consolo" wrote in
message ...
I am taking a stat class. The professor gave a challenge to any one who
can come up with a furmula for the lottery. Is this possible to in xl?
I am pretty proficent in it, and I am fairy certain it can be done, but
the peramters by which to conceive such a formula are beyond my reach.
This formula needs to work using the mega ball format. It also needs to
take into account past numbers drawn w/ their statistical frequency of
appearance. Any help is welcome. Thank you.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/