random number generation

Hi all, Can anyone help me please: I am trying to generate random lotto in 8 groups of 8 rows each. The aim is to have 8 groups with the following criteria. numbers appears only once per group; if 16 & 27 appears together in the same row in group 1, it does not appear together again in any...

Hi i'm using the following macro that is set to run every time i press my form button: Sub One() Range("b1:B1000").Value = Int((200 - 1 + 1) * Rnd + 1) End Sub the problem is when i press the button each cell brings back the same result, ie. all the cells display 154 then when...

I am having trouble with the following code to get repeated series of random numbers using a seed value. The series obtained are always different. Option Base 1 Option Explicit Function MyRnd(n, Optional seed) Dim x() As Double ReDim x(n) ' Dim xc As Integer ' Dim xp As Double...

As my final project for my statistics class, I want to prove that using a combination of the most frequent drawn lottery numbers can lead to a better chance of winning the lottery (Hot Numbers method). Now, the sequence ranges from 0-50 with only 5 numbers drawn. I will not use all of the drawn...

I need to generate a list of about 50 zeros and ones where each position on the list have a certain probability (say 70/30) to be picked over zeros and the result is to be used in a monte carlo simulation. Easy enough: if(rand()<0.7,1,0). The problem is I need the list to “go towards the mean”...

I'm spinning wheels. Here is what I'm attempting I'm trying to use the empirical discrete probability distributions to generate 1000 days of Widget sales and returns. I need to use Nested IF statements to generate the 1000 days of sales. So for 1000 days, generate a number in a column that...

Hi Guys. What I am trying to achieve: A Single form to create quotes and orders, with a cell that generates a random quote number each time the form is amended. The quote number must be different if an amendment has been made to the document. The quote number needs to then become a static fixed...