Question

Gice excel formula please

4. Estimate f x2 dx between 0 and 2 using Monte Carlo Inte ratio on. Here's how: Generate 1,000 random (x.y) pairs where 0

Answer 1

Here's the procedure in excel:

In the formula bar for cell A1 (say), write:

=RAND()*2

This generates a random number between 0 and 2

In the formula bar for cell B1(say), write:

=RAND()*4

This generates a random number between 0 and 4

In the formula bar for cell D1(say), write:

=IF(A1*A1>B1,1,0)

and then drag for the 1000 entries in each column.

The number of 1s in D1 is the number of times x²>y

So to count the total let E1=SUM(D1;D1000)

Then our Monte-Carlo estimate for the area is 8*E1/1000.

The 8 is the area of the rectangle { (x,y) : 0<x<2, 0<y<4 }