Consider a calculation of by simulation with random numbers. Implement a Monte Carlo scheme to estimate .
[Random number generation with MS Excel] Test of a quarter of a unit circle with its center at the origin inside a square: 0 < x < 1, 0 < y < 1
Step 1: Generate (x, y) coordinates from a pair of independent random uniform distributions: Rand() function in Excel generates a random number following U(0,1).
Step 2: Calculate the distance of a random point (x, y) from the origin: x^2 + y^2 < 1
Step 3: Count the point (x, y) if it is within the circle, else move to Step 1
Number of points within the circle: Area of Circle / T
P (point is located in the circle) = Number of points within the circle / Number of total points generated
Area of square = 4
Plot your estimates for sample sizes of n = 2, 4, 8, 16, 32, 64, 128, 256, 512, and 1024.
(b) What is your conclusion based on the result of (b)? 10 points