ZuoTi.Pro
Question

Monte Carlo Simulation- Generate π Using Excel and Rand() function generate an estimate of π(3.14159….). The...

Monte Carlo Simulation- Generate π

Using Excel and Rand() function generate an estimate of π(3.14159….). The sample must have 10000 samples that is 10000 rand() functions. When you hit recalc F9 the model should re-generate an estimate of π.

math   Statistics-And-Probability   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

Both X and Y are calculated using =RAND() function in excel

X2 + Y2 is evaluated using the equation of a circle, here using the radius 1

Checking the cases, where 1 denotes the sum less than 1 and 0 denotes otherwise

Simulating 10000 values for the estimation of pi

As all values are in first quadrant, the values would represent the quarter circle and hence multiplied by 4 for a complete circle.

Regenerating the new estimate of pi after pressing (Alt + F9)

0 0
Add a comment
Know the answer?
Add Answer to:
Monte Carlo Simulation- Generate π Using Excel and Rand() function generate an estimate of π(3.14159….). The...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • Monte Carlo Simulation This lab assignment consists of two problems involving Monte Carlo simulation. You should...

    Monte Carlo Simulation This lab assignment consists of two problems involving Monte Carlo simulation. You should use either Excel or Python for this assignment. References: Seila, A. F., V. Ceric, and P. Tadikamalla, Applied Simulation Modeling, Duxbury - Brooks/Cole, Belmont, CA, 2003. Schriber, T. J., "Simulation for the Masses: Spreadsheet-based Monte Carlo Simulation," Proceedings of the 2009 Winter Simulation Conference, Rossetti, Hill, Johansson, Dunkin, and Ingalls, Eds., December 2009. Adopted from Problem 2.13 from Seila et al. (page 74) with...

  • 4. Estimate f x2 dx between 0 and 2 using Monte Carlo Inte ratio on. Here's how: Generate 1,000 r...

    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

  • The assignment is to perform a Monte Carlo simulation for the probability distribution of rolling two...

    The assignment is to perform a Monte Carlo simulation for the probability distribution of rolling two die and taking the sum of the two die. Therefore, your random variable will be x=2,3,4,5,6,7,8,9,10,11,12 and you will obtain the probabilities for each of those random variables by a Monte Carlo simulation. The requirements to get full credit are 1. R script must run 2. When I run your R script the script should clearly display the mean, the standard deviation and a...

  • Solve the following Monte-Carlo simulation problem both with Excel data tables and @Risk. Include all your...

    Solve the following Monte-Carlo simulation problem both with Excel data tables and @Risk. Include all your answers directly in your Excel file using text boxes or comment boxes. Please show formulas used within excel. NCAA Sweatshirt Problem An enterprising OU student is trying to decide how many sweatshirts to print for an upcoming NCAA Basketball Tournament game. The final four teams have emerged from the quarterfinal round, and there is a week left until the semi-finals, which are then followed...

  • Solve the following Monte-Carlo simulation problem both with Excel data tables and @Risk. Include all your...

    Solve the following Monte-Carlo simulation problem both with Excel data tables and @Risk. Include all your answers directly in your Excel file using text boxes or comment boxes. Please show formulas used within excel. NCAA Sweatshirt Problem An enterprising OU student is trying to decide how many sweatshirts to print for an upcoming NCAA Basketball Tournament game. The final four teams have emerged from the quarterfinal round, and there is a week left until the semi-finals, which are then followed...

  • Problem 9 (for all students) Monte Carlo simulation is often used to analyze probabilities of failure...

    Problem 9 (for all students) Monte Carlo simulation is often used to analyze probabilities of failure of geotechnical engineering structures. a) For a case, where the limit state function, G, can be described by three normally distributed random variables such that G-Xi-X2x X3, describe a step-by-step methodology (i.e. an algorithm; MatLab code is not needed) that calculates the probability of failure with Monte Carlo simulation. (3 p) I. Il Running the algorithm that you proposed in a), you can visualize...

  • 1. (10 points A Monte Carlo analysis can be used for optimization. For example, the trajectory...

    1. (10 points A Monte Carlo analysis can be used for optimization. For example, the trajectory of a ball can be computed with 2vo cos2 Go where y is the achieved height in meters (m), 6% is the initial angle (radians), is the horizontal distance (m), g is the gravitational acceleration (-9.81 m/s2), vo is the initial velocity (m/s), and yo is the initial height. Given yo 1 m, vo 25 m/s, and 500 (or T/180 x 50 rad), determine...

  • Write a Java program that uses the Monte Carlo method to estimate the value of PI....

    Write a Java program that uses the Monte Carlo method to estimate the value of PI. This method uses the unit circle inscribed in a square with sides of length 2 and random numbers to perform the estimation. The estimation works as follows: • Two random numbers are generated during each iteration of a loop. • The random numbers are each in the range of -1 to 1. One random number is the x-coordinate and the other is the y-coordinate....

  • MONTE CARLO HYPOTHESIS TEST HELP?! We are given the following averages in categories (How much ti...

    MONTE CARLO HYPOTHESIS TEST HELP?! We are given the following averages in categories (How much time you spend a week on HW, on FB, READING, and LISTENING TO MUSIC: These were the averages for each category: HW = 12.0276 /wk FB = 385.403 /wk BOOKS = 42.4919 /wk MUSIC = 18.8011 /wk -- (Basically my hypothesis are testing whether or not my class does more or less when compared to graduate students) I NEED TO USE MY AVERAGES IN A...

  • Answer in Python please: Compose a function mc_pi( n ) to estimate the value of π...

    Answer in Python please: Compose a function mc_pi( n ) to estimate the value of π using the Buffon's Needle method. n describes the number of points to be used in the simulation. mc_pi should return its estimate of the value of π as a float. Your process should look like the following: Prepare an array of coordinate pairs xy. This should be of shape ( n,2 ) selected from an appropriate distribution (see notes 1 and 2 below). Calculate...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT