Answer to Question #221500 in Statistics and Probability for Arya pratap mishra

Question

Describe a method of generating a random variable with distribution function F(x) = x n , 0 < x < 1. 

Answer 1

Creating Random Numbers in an Excel Worksheet

Use function

=RAND() without parameters

Click Enter

The RAND command ‘‘looks to the left of the cell with the RAND() COMMAND in it’’ and assigns a random number to that cell.

Now, put the pointer using your mouse in cell A1 and then move the pointer to the bottom right corner of that cell until you see a ‘‘plus sign’’ in that cell. Then, click and drag the pointer down to cell A15 to add a random number.