Question

Generate 1000 random numbers between 0 and 1*Create a frequency table with the following Generate 1000 random numbers between 0 and 1*Create a frequency table with the following bins 0, 0,1, 0.2, ..., 0.8, 0.9 , 1Find the expected value

bins 0, 0,1, 0.2, ..., 0.8, 0.9 , 1Find the expected value

Answer 1

To generate 1000 random numbers between 0 and 1, in excel, at first column, use formula =RAND()

and drag this upto 1000 rows.

Now enter Bin values

Now click on Data->Data Analysis and select Histogram

Enter random numbers in range of data and also enter Bin values

Click OK

The frequency table is shown below:

Bin	Frequency
0	0
0.1	94
0.2	96
0.3	103
0.4	92
0.5	113
0.6	92
0.7	100
0.8	108
0.9	89
1	113

By using excel, the expected value (average) of those 1000 random numbers is 0.5.