HELP with programming an excel problem

[yamboe]

Hi everyone! Im new here, so im sorry if this is the wrong place to put my questions ... Anyway, i want to win the lottery ! ha ha who doesnt right? To win this particulary lottery , i need to strike 6 numbers of 60 . And the lottery choose always 6 numbers , 1 to 60 . Sorry for my poor english. I want to build a program that can read older sequences that been already sorted , and fragment the numbers, and tell me what numbers (to 0 to 9) doesn't show up. For exemple , in the sequence 01/12/14/23/39/55 , i want that the program read the sequence and fragment the numbers, 0 1 1 2 1 4 2 3 3 9 5 5 , and return to me the numbers that doesn't show up, in this case 6/7/8. Please help ! Anyone can give me any tips ?

[Richard Buttrey]

Hello and welcome to the forum

Unfortunately yYour post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[yamboe]

Richard Buttrey the title is better ? Can you help my problem?

[ben_hensel]

The most reliable way to win the lottery is to use insider knowledge to predict which ream of tickets the algorithm will stick the winning ticket in, and then drop 10 large to buy the whole ream.

This is, of course, usually illegal.

I mean, we can help you decomposing the digits, but I strongly predict that the result will just be an even distribution across all ten digits 0 - 9.

You will not be winning the lottery this way.

Statistically, you're better off aiming for high numbers, like in the 70 - 99 range.

Not because this is more likely to win, but because people tend to pick birthdays / ages / etc, so in the unlikely event you do win, the ROI on high numbers is better (well, less bad, technically; it's still below 1 on average) because they are split between fewer people.

[yamboe]

Ben hensel thank you for the reply!
well , if winning the lottery was easy , they would call charity instead. hahaha . to 01- 60 , the 0 apears 15 times , number 1 , 2, 3 ,4 , 5 appears 16 times, number 6 appears 7 times, and numbers 7, 8, 9 just 6 times. So yeah, i beliave that if i do this small program , the results will show an distribution according to this numbers.However, can you help me to do this program? And, if you have a better idea of predicting the numbers or better ways to do the statistic , please tell me =D

[shg]

I suggest you start with a warm-up exercise that requires nothing but pencil and paper.

Toss a coin 10 times and record the results. Predict the result of the 11th toss, then toss and record the result.

Repeat 100 times.

What fraction of the time was your prediction correct?

[yamboe]

shg hahaha you are a funny boy!

[shg]

If you don't see the parallel, I have a bridge you may be interested in buying.

[MrShorty]

I don't know exactly what you will do with the information. Ignoring the "lottery" part of the question, your question is to determine which digits in a series of two digit numbers are not used. Here's how I think I would approach this problem:

1) Convert numbers to text strings. =TEXT(1,"00")
2) Use LEFT() and RIGHT() functions to separate into digits. =LEFT("23",1)
3) Use the FREQUENCY() (or COUNTIF()) function to count how many of each digit are used.
4) Any 0 results from step 3 are the digits that are not used.

What part of programming that would you need help with?

[yamboe]

hahhahhaha i see very well. Thanks for the reply . I don't want to buy a bridge , i already made one in my city that cares my name. Im an engeneer , and i known that predicting a winner ticket is even more dificult than the exercise that you propose. However, i'd like to do this program even so , because im doing a statistic course and would like to put somethings that i learned into practice. Can you help me to build this program shg?

[Richard Buttrey]

..because im doing a statistic course and would like to put somethings that i learned into practice.

Purely out of interest has it been suggested in the statistics course that when you get a result that it will be in any way significant let alone a predictor?

Your whole question has shades of Benson's Law (aka the First digit law) entwined in it. Is that what's behind what is essentially a statistics question?

[yamboe]

thank you mr. shorty!