Lottery Analysis with Excel

[faracea]

Hi,
I wanted to do a few things with excel but am struggling to go about it. There are a few neccessary things I need and a few I would like but don't mind if I can't find out how to do.

The ones I need:
- to be able to collect random numbers based on probabilities.
- to collect 3or4or5or6 different numbers.

The ones I would like:
- to automatically retrieve data from the Internet on drawings.

Thank you in advance for your help.

 

[mole999]

the lottery is totally random, therefore unpredictable, beyond frequency questions. you'll never generate a value that is a winner for the current week. they use six sets of balls and three machines also at random, so beyond the 14 million odds on 7 random numbers its weighted against the player

as for downloading, some people do publish lists

 

[faracea]

I wanted to use chances of consecutive numbers being drawn and rate each ball a score based on so and so. Could you help me achieve my first two goals?

 

[mole999]

how to do it in excel I have no idea but you could read this Lottery probability question: consecutive numbers - Straight Dope Message Board. I would strongly suggest that each ball is EQUAL, only the painted number on the outside would change, now if you were talking of odds for 33 and 34 appearing that's another level