Use Microsoft EXCEL or Corel Quatro Pro. Your work should include at least a floppy diskette with your spreadsheet file on it, a printout of the generated numbers with proper headings for columns, and explanation pages to show how the numbers were calculated with one of example from each column.

Please make sure to consult the general information page for proper format.

1.Generate 90 random numbers from U(0,1). Use ONLY these numbers for the rest of the

instruction on this assignment. [Hint: use rand() function and to fix the number press F9]

2.Generate 90 random numbers from U(3,7)

3.Generate 90 random numbers from the following discrete distribution:

P(X=1)=0.04

P(X=2)=0.22

P(X=6)=0.39

P(X=7)=0.26

P(X=9)=0.09

4.Genrate 90 random numbers from the following continuous distribution:

f(x) = 2x 0 ≤ x ≤1

= 0 elsewhere

5.Generate 180 random numbers from EXP(3).

6.Generate 90 random numbers from gamma(1,2)

7.Generate 10 random numbers from gamma(4,3)

8.Generate 10 random numbers from 2-Erlang(3)

9.Generate 10 random numbers from chi-square 6 degrees of freedom

10.Generate 10 random numbers from gamma(6,3)

11.Generate 10 random numbers from beta(2,4)