Help to Analyse 30 Past Lottery Draws

Hello everyone, I hope everyone is well!
My name is Humberto, I'm 70 years old, I'm from Brazil!
I have Excel 2007 installed on my computer, my knowledge about Excel is zero!
Please, I need help, with Progressão Geometrica, here in Brazil there is a lottery called Megasena (1 to 60), with draws held three times a week, because of this I have to update the draws in Excel 2007, I have to do the Progression Geometrics of the Thirty last competitions, in this result some guesses will appear, here in Brazil there is a person who uses this method, but he doesn't share it, I've already asked for help from several people, but I couldn't get help from anyone, I can't do it, my cognition is no longer the same.
I'm going to attach the Excel with the last thirty contests, sorry for asking you this, also sorry if there are any errors in English, I'm using Google Translate
Please, can anyone help me!
Thanks in advance for your help!
​

Humberto Silva

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

I have amended it for you this time - "Help" is the most useless thread title in the world!!!

Progression Geometrics

Explain what this is.

There are NO expected results in your workbook - you have not showed us what you are trying to do and osrry, but your opening post doesn't actually tell us enough about what that is.

What is geometric progression? Explain what you are trying to do fully. We can help you with a formula, but you need to explain the mechanics.

Neither do I - sorry. I'm not a mathematician. You'll have to hope that someone else understands the maths.

I don't see any obvious geometric sequences in the data, and I don't understand how you intend to take the data and create a new geometric sequence from the data. You've implied that you know how to do this outside of Excel, but not in Excel. Help us understand the sequence of calculations you want to do for this analysis (how you would do it outside of Excel), and we should be able to help you program that sequence of calculations in the spreadsheet.

I do not understand what you expect to see!!!

If the first row was 2,4,8,16,32,64, the common ratio would be 2.

However the first row is

10 23 30 31 49 56


Since these are (essentially) random non-repeating choices from 1-60, there can be NO common ratio. Or am I completely missing the point here??? (I'm an analytical chemist, not a mathematician...).

What answers do you EXPECT to see?

Lottery drawings are random numbers. You cannot derive a geometric progression from a series of random numbers. So I think you just have a vague idea of the method you want to use rather than a rigorous mathematical specification. (A geometric progression is like a chain letter: 1 person sends it to 5 people, then those 5 people send it to 25 people, then those 25 people send it to 125 people, multiplying by 5 each time.)

If a lottery drawing is fair, that is, truly random, there is no mathematical model that will predict an outcome any better than a random pick. If you have massive amounts of past data you can determine whether the lottery is actually fair (Note: 30 is not massive). My guess is that the mathematicians who work for the lottery make sure it's fair.

We can take a method and help implement it in Excel, but you are asking for some magic maths to predict lottery numbers and that is not our area of expertise.

If you can predict the numbers everyone choose these numbers and everyone wins
Everyone will win an equal amount and this is always less than the bet.