Maybe this link will be useful:

http://www.vbaexpress.com/kb/getarticle.php?kb_id=760

In the true sense, it is not possible to draw a random sample in

MS-excel. The sample drawn in MS-excel is actually a pseudo random sample.

@Dhritikesh Chakrabarty sir , in that case what should i do.

Hi,

Sampling with replacement is quite easy in XL : you simply need to select randomly (with an uniform distribution) the 10 lines number of the data.

Sampling without replacement is a little bit more complicated in XL if you do not want to order values of a column. The idea is simple, you draw randomly (with an uniform distrib.) 100 numbers between 0 and 1, your order these 100 numbers ; during this ordering, the dataset should be permuted in the same way as the 100 random numbers. Then you take the first 10 values of the permuted dataset.

The attached file shows an implementation of this without requiring any basic code.

Didier

Dear Shikhar Tyagi ,

Thank you for reading my answer.

You can draw random sample by using random numbers' table. Several random numbers' tables are available.

You go through the following book:

Dhritikesh Chakrabarty (2017): “Selection of Random Sample: Drawing of Random Numbers”, (ISBN-10: 3659959804 , ISBN-13: 978-3659959806), Lambart Academic Publishing.

I wish you success in life.

@ Didier Concordet sir in without replacement sampling , I got first value but remain values are zero.

The column E contains 10 random numbers between 0 and 1. each random number is associated to a data

The column F contains the rank of each of these random numbers. The rank of the smallest random number (0.0384516358092014) is 1. Then the number that is immediately greater than the smallest (0.0938540867873542) has rank 2; and so forth.

The column G contains the line number

The column H contains the line number of the random number that has rank 1, then rank 2, then 3 etc… As an example, the line at which lies the random number with rank 1 (ie the smallest random number) is 11 The line at which lies the random number with rank 2 is 8

The column B contains the data whose lines are given in column H

If you want another sample without replacement, you need to draw other random numbers in columns E using the function RAND()

I have found little bit difficult to follow/understand your answer just given.

You're right !

It is simply an explanation of the different steps to obtain in XL a random permutation of the data without using the "sort" button.

This allows to obtain differrent samples by simply pressing the F9 key of the keyboard.

Thank to Didier Concordet for his clarification.