How To Use VBA To Create A Moving Average Of Prime Numbers In Lotto Results

Identifying patterns in lotto results can be difficult but one pattern that is consistent is the frequency of prime numbers.

Prime numbers should make up around 30% of all lotto results and this article introduces the idea of moving averages and how they might help improve your own lotto odds.

A moving average is simply the average over a subset or period of data. It becomes a powerful tool when you consider subsequent averages which might indicate a move away or back to the mean.

Prime Numbers And A Random Data Set

The easiest way to test lotto ideas is to create your own random data set which should simulate a series of lotto results.

You need to create a table of random results and calculate how many prime numbers are in each line. Then, we can write some VBA code to calculate the average to see if there are any patterns in the numbers.

You should have a data table looking like this, where the final column is a count of how many primes are in each line.


18 19 26 29 30 33 2
2 9 12 22 35 39 1
6 9 12 19 20 31 2
5 16 20 22 27 29 2
18 20 23 28 31 39 2
3 19 20 27 31 35 3

Now we’re ready to write some VBA code which will calculate the averages.

Lotto Results, VBA Code And Moving Averages

As an example, in our data set above the result with a period of 2 lines would look like this.


18 19 26 29 30 33 2
2 9 12 22 35 39 1 1.5
6 9 12 19 20 31 2 1.5
5 16 20 22 27 29 2 2
18 20 23 28 31 39 2 2
3 19 20 27 31 35 3 2.5

In our VBA code, we’ll use a period of 10 to get some meaningful results.

The Excel formula to create an average over the first 10 lines is below, where “h” is the column which will hold your results.


=AVERAGE(h1:h10)

To calculate the next 10 period moving average you simply increment the row number.


=AVERAGE(h1:h10)
=AVERAGE(h2:h11)

In this example, just type the formula into row “h10” on the right hand column; then we’ll use VBA code to reiterate through the data set.

The code selects the first cell with the formula, calculates how many rows of data there are and then fills in the same formula through the whole data set.


range("h10").activate
i = ActiveCell.Offset(0, -1).End(xlDown).Row
Selection.AutoFill Destination:=Range("H10:h" & i)

Development Of The Lotto Prime Numbers Moving Average

When I ran the moving average module the results came out as expected, with moves away from the median on a regular basis. Some further development of the module might include the following:

  • Creating a chart to enable visual identification of trends.
  • Highlighting the lines of data that are above or below the global average.
  • Determining maximum and minimum variations from the mean.

Summary

This article has introduced the concept of using VBA code to calculate averages of prime numbers in random data sets. The concept can easily be applied to lotto results and with a little creativity other idea and theories can be developed and explored.



Source by A. Lewis Gibson

Please follow and like us:
0

The Best Red-Black Roulette Strategies

There are many roulette systems and strategies available to the avid roulette player, some probably as old as the game itself. The majority of these don’t work, if at all. Here I will share two simple outside betting strategies that capitalize on the patterns in roulette. Patterns, you say?

Yes, allow me to explain. As you’re probably aware, many roulette systems bet on numbers that have not shown for some time and felt to be due. These are typically called cold numbers. Some systems try to play repeat numbers or numbers occurring frequently in a specific period of time. These are sometimes called hot numbers. In reality, they are both right. To beat roulette, you must combine both methods. Why?

Because the numbers of the roulette wheel tend to occur in cycles of 21 spins and create what can be called patterns. In addition, certain sets of numbers tend to trend together thus creating what people call “hot” numbers. These numbers will turn “cold” after they run for an unspecified length of time and then stop. The key to winning roulette is exploiting short-term patterns. Basically, play when the numbers are hot and stop when the numbers are cold or bet on a particular pattern.

The challenge is locating the patterns and knowing when to start and stop. Here I offer you one way to do this. The following are two highly profitable outside betting strategies, in particular playing red and black. The only drawback is that they use a 5-step Martingale progression but that is because of how the patterns work. The win rate more than makes up for it. Here’s how they work –

Red & Black Roulette System: Pattern 1

This is an amazing roulette strategy with a high win rate. When you see 5 black or red numbers in a row, you bet the SAME color to win using a 5-bet progression. If a zero occurs in the series, ignore it, and count the numbers as if it weren’t there. It works on both wheels as well as online. Win rate is practically 99%!

Examples:

25 (R)

1 (R)

14 (R)

5 (R)

27 (R)

27 (R)

5 (R)

31 (B)

After you see the fifth red number in a row, you would then bet on RED. You would’ve won on the first bet.

17 (B)

0

35 (B)

20 (B)

15 (B)

17 (B)

5 (R)

22 (B)

You ignore the zero. After the 5th black number, #17, you would’ve started betting on black and won on the second bet with the #22.

Other Even Money Wagers:

You can do the same for all other even money wagers. Wait for 5 high/lows or 5 odd/evens in a row then bet the SAME, not the opposite, to win!

Pattern 2:

Here is another outside bet pattern that occurs frequently. It also plays Red (R) or Black (B). When you see the pattern BBRB bet on Red. When you see RRBR bet on Black. Ignore zeros in the sequence. Progression is also 5 bets. It wins 98-99 out of 100 wagers. That equals $140-$340 using $5 chips.

Example 1:

6

26

15

22

6 (B)

28 (B)

9 (R)

28 (B)

21 (R)

17

3

Reading from top to bottom, this example shows the BBRB pattern winning on Red (#21).

Example 2:

25 (R)

34 (R)

35 (B)

12 (R)

31 (B)

21

5

4

4

1

8

24 (B)

31 (B)

19 (R)

35 (B)

11 (B)

30 (R)

8

32

Reading from top to bottom, this example shows RRBR winning on Black (#31) and the BBRB pattern winning 2 spins later on Red (#30).

Example 3:

25

19 (R)

18 (R)

0

31 (B)

21 (R)

20 (B)

This example demonstrates ignoring the zero in a sequence. The zero interrupts a RRBR pattern but still wins on Black (#20).

Note: This bet also works online but if you plan to test in real money mode, due to the way RNG software works, make sure you have not played Red or Black in the last 6 sessions and keep sessions within 15 minutes or less. Also, after you use this bet to win in a session, you can’t use it again for the next 5 sessions! A session ends when the software is exited for at least 20 minutes, not if you re-start the numbers. Never play at Flash casinos. The numbers do run the same way when playing for fun because software only reacts when playing for real money, so you can verify that this bet works in fun mode. When playing for real money, how you play will have to change but I can’t go into full details in this short document. Of course, live play does not have these restrictions.

Red/Black Progression:

1-2-4-8-16

31 units

This is just one way to use patterns to win roulette. Additionally, there are several other pattern bets that work in conjunction with these outside bets.



Source by Carrie LaShawn

Please follow and like us:
0

МЯСОРУБКА выпуск # 21 – FIKE



Снимать выпуск с FIKE мы поехали на “Комендан”-район, который сосредоточил в себе очень много деятелей рэп…

source

Please follow and like us:
0

Dissidia 012: Duodecim Final Fantasy – vs. GILGAMESH Encounter Quotes



Voiced by Keith Szarabajka. Ordered from FF1 all the way to Duodecim. No Chaos quote because no replay button. Sorry for the terribad quality. Everything the …

source

Please follow and like us:
0

Recogido bajo en cabello rizado u ondulado – Pedido Cynthia



Aqui teneis un recogido bajo, en la zona de la nuca, para cabello rizado u ondulado. Lleva una flor en la zona baja lateral. Es un recogido para novia o para …

source

Please follow and like us:
0

KBC Ghar Baithe Jeeto Jackpot 05 October Question with Answer | Kaun Banega Crorepati 2017



Jio KBC Ghar Baithe Jeeto Jackpot 5 October 2017 KBC Ghar Baithe Jeeto Jackpot 05 October Question with Answer Jio KBC Ghar Baithe Jeeto Jackpot 05 …

source

Please follow and like us:
0

Using Artificial Intelligence Techniques And SQL To Optimize A Lottery Application

Artificial Intelligence or “AI” can be defined as the “ability of a system to learn from previous experience in an attempt to predict future events”. While this might seem a forlorn hope in making lottery predictions, let’s see if this might be possible.

The big problem in analysing lottery results is the large number of possible combinations. In a standard “40 x 6” ball game there are 3,838,380 lines to choose from.

Generating A Starting Point For A Lotto AI System

It makes sense to reduce the possible number pool before we implement any AI possibilities. I’ll use the “Prime” probability system which assumes there will be 2 primes, 1 odd and 3 even numbers in each winning line.

We’ll try to use AI to group the prime results into some kind of pattern when they do occur.

For example, the last 6 weeks results of NZ Lotto were:


10,15,17,19,35,39
4,16,20,25,29,37
2,10,24,26,29,33
7,14,17,18,25,30
4,20,22,34,36,37
13,14,27,31,38,40

The numbers in results 2,3,4 and 6 meet the prime system criteria so we only want to look at those lines. If we can establish a pattern within the prime results then we can greatly reduce our combinations for when the prime system numbers come up.

We’ll use the Structured Query Language, or SQL, to query the prime system database of all possible lottery combinations; a total 575,586 lines of 6 numbers.

The structure of the database is as follows:


Number types: prime,prime,odd,even,even,even
Column name: n1,n2,n3,n4,n5,n6
For example:
3,5,9,10,14,28

Using A SQL Query To Recognize The Lottery Pattern

What I’ll do is create a SQL query that selects each line of winning prime system numbers. We can then combine the queries in an “and/or” statement to cover the different scenarios.

In this way, we can learn the commonalities between the different results, just like a real life AI application.

Most of the prime results above contained at least one number divisible by 4. We can cover that scenario with this query:


n4%4=0 or n5%4=0 or n6%4=0

Records returned: 525,690

The percent symbol is a special code in SQL which gives us the remainder from dividing the two numbers.

Each prime line appears to have at least two numbers within 4 of each other. We’ll cover that possibility like this:


(n6-n5<5)
or
(n5-n4<5)

Records returned: 305,316

We can now combine the queries with the following command:


(n4%4=0 or n5%4=0 or n6%4=0)
and
(
(n6-n5<5)
or
(n5-n4<5)
)

The combined query returned 276,210 combinations, a reduction of around 40%, which is fairly impressive.

I noticed the first even number was always equal to or less than 14 and when I factored that parameter in, the combinations returned were 165,726.

In future weeks I’ll look at other common factors, for example excluding numbers from recent results.

Summary

This article explored the possibility of using AI techniques and SQL to reduce possible combinations. By analysing results that meet certain parameters it should be possible to reduce line numbers and improve our lottery chances.



Source by A. Lewis Gibson

Please follow and like us:
0

Case Clicker – WE WON A HUGE JACKPOT



Below, you can find an assortment of links related to me. ☆ – – – – – – – – – – – – – – – – – – – – ☆ My Other Channel: https://www.youtube.com/c…

source

Please follow and like us:
0

Высший пилотаж Су-35C / Su-35S ( Flanker-E)



Су-35 – глубоко модернизированный сверхманевренный многофункциональный истребитель поколения «4++». В нем…

source

Please follow and like us:
0

I Got This 179 Days Lock with 100 PEOPLE (Super Rare) – Growtopia



Download Growtopia For Free ¦ ¦ http://growtopiagame.com ¦ ¦ Music Used: ¦ Lostboy & Slashtaq – Elysium [NCS Release] ¦ Growtopia Name: Brebbiamats …

source

Please follow and like us:
0

Enjoy this blog? Please spread the word :)

RSS20
Follow by Email
Facebook0
Google+0
http://skytvgambling.com/author/conrad/">
Twitter20
Pinterest