fm3_problems22 - about 8.000.000 8-decimal accurancy...

Info iconThis preview shows pages 1–10. Sign up to view the full content.

View Full Document Right Arrow Icon
Number of data points 100,000 Value of pi? 3.14 StartTime 10:38:02 AM StopTime 10:38:04 AM Elapsed 0:00:02 #MACRO? Press Ctrl-A to start the magic
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Number of data points 400,000 Value of pi? 3.14 StartTime 10:39:01 AM StopTime 10:39:02 AM Elapsed 0:00:01 Update Frequency 10,000 (Enter 0 to DISABLE) Press Ctrl-B to start the magic
Background image of page 2
Number of data points 10,000,000 Area 19.08158 Real result 19.08554 #MACRO? X EXP(X) 0 1 0.1 1.11 0.2 1.22 0.3 1.35 0.4 1.49 0.5 1.65 0.6 1.82 0.7 2.01 0.8 2.23 0.9 2.46 1 2.72 1.1 3 1.2 3.32 1.3 3.67 1.4 4.06 1.5 4.48 1.6 4.95 1.7 5.47 1.8 6.05 1.9 6.69 2 7.39 2.1 8.17 2.2 9.03 2.3 9.97 2.4 11.02 2.5 12.18 2.6 13.46 2.7 14.88 2.8 16.44 2.9 18.17 3 20.09 Press Ctrl-C to start the magic 0 0.2 0.4 0.6 0.8 1 1.2 1.4 0 5 10 15 20 25 EXP(X) X EXP(X)
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Sub MonteCarlo1() Dim X As Double, Y As Double n= Range("Number") Hits=0 For Index = 1 To n X= RND()*3 Y= RND()*20 If Y < Exp(X) Then Hits= Hits + 1 Next Index Range ("Estimate") = (Hits/n)*60 End Sub 1.6 1.8 2 2.2 2.4 2.6 2.8 3 )
Background image of page 4
Approximately how many runs does it require until you get 4-decimal accurancy for π using the MC 4-decimal accurancy
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 6
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 8
Background image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 10
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: about 8.000.000 8-decimal accurancy Computer gave up; because 20 minutes and 500,000, 16-decimal accurancy Failure!! Number of data points 10,000,000 Pi? 3.141775200000000000 Differences 0.00018254641020699 3.14159265358979000 StartTime 10:42:48 StopTime 10:42:55 Elapsed 0:00:07 resulting time Press Ctrl-D to start the magic simulation? ,000 datas are just enough for a accurancy around 6 decimals Pi 3.141592653590 #MACRO? Pi 3.1415 decimals 4 Decimal accuracy 10307 1 23 2 600 3 1611 4 10307 5 359863 6 1461054 7 17820363 8 too time consuming Press Ctrl-E to start the magic 1 2 1 10 100 1000 10000 100000 1000000 10000000 100000000 3 4 5 6 7 Ramanujan N 1 Pi from Ramanujan #MACRO? Pi from Excel 3.14159265358979000 As you can see, with n = 2, the numbers are exactly the same, even we have here #MACRO? #MACRO? re more than 15 digits...
View Full Document

This note was uploaded on 01/23/2011 for the course FGB 780 taught by Professor Edwardchang during the Spring '09 term at Missouri State University-Springfield.

Page1 / 10

fm3_problems22 - about 8.000.000 8-decimal accurancy...

This preview shows document pages 1 - 10. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online