can i predict the first digit of a six digit random number?

W

wigi

Well-known Member

Joined

Jul 10, 2006

Messages

7,964

Office Version

1. 365

Platform

1. Windows
2. Mobile
3. Web

• Oct 22, 2013

• #2

Hello

Do you understand what randomness means?
If it were possible, the lottery would not exist anymore.

 

Upvote 0

H

hereticwrath

New Member

Joined

Oct 21, 2013

Messages

5

• Oct 23, 2013

• #3

@wigi,i asked if i can "predict" with better probability,and just only the first digit i-e:-from 0-9?
if there is any way just for the first digit kindly do suggest,thnx alot for your reply,would be waiting
on this one too....
regards

 

Upvote 0

mohan.pandey87

Board Regular

Joined

Sep 14, 2012

Messages

146

• Oct 23, 2013

• #4

Yes you can get first digit by using below formula:

=LEFT(D2,1)
where D2 is the cell address

 

Upvote 0

Rick Rothstein

MrExcel MVP

Joined

Apr 18, 2011

Messages

38,463

Office Version

1. 365

Platform

1. Windows

• Oct 23, 2013

• #5

hereticwrath said:

i asked if i can "predict" with better probability,and just only the first digit i-e:-from 0-9?
if there is any way just for the first digit kindly do suggest,thnx alot for your reply,would be waiting
on this one too....

Click to expand...

No, you cannot predict an upcoming number from a series of past randomly generated number... numbers do not have memory, so what numbers came out in the past cannot influence the next number that will come out.

 

Upvote 0

H

hereticwrath

New Member

Joined

Oct 21, 2013

Messages

5

• Oct 23, 2013

• #6

thanks for the replies all,@rick,thanks but is there any way if i can make a better guess of an upcoming number,i mean if i have three tries to guess
what the first digit can be from 0-9,can i guess it in these three tries?

 

Upvote 0

S

Stiuart_W

Well-known Member

Joined

Jul 3, 2013

Messages

516

• Oct 23, 2013

• #7

NO

You CANNOT do what you want. If you could then the numbers wouldn't be random.

If you are saying that you already have a lot of data and you want to use it to make a guess of the probabilities of the first digit of the next number in the sequence I suppose it might be possible to do that but ONLY if the data weren't random (you said it is).

 

Upvote 0

H

hereticwrath

New Member

Joined

Oct 21, 2013

Messages

5

• Oct 23, 2013

• #8

again thanks all,@stuart_W...i also said i have 3 to 5 tries to make it happen and its only the first digit,i have to chose from 0 to 9,as i have narrowed
it down,now can it happen?
thanks in advance all...
regards

 

Upvote 0

XOR LX

Well-known Member

Joined

Jul 2, 2012

Messages

4,517

• Oct 23, 2013

• #9

You can have as many 'tries' as you want - you still won't improve your chances of a correct prediction.

Please try and understand what the multiple people who have responded to your query have been trying to tell you: whether you have 1 'try' or a million, there is absolutely no difference whatsoever in your 'chances' of correctly predicting what a chosen number from a random set will be.

Regards

 

Upvote 0

RoryA

MrExcel MVP, Moderator

Joined

May 2, 2008

Messages

42,251

Office Version

1. 365
2. 2016

Platform

1. Windows
2. MacOS

• Oct 23, 2013

• #10

I don't think you are listening. If the numbers are random, then no. (unless you have 10 tries for one number so you can guess every possibility)

 

Upvote 0