{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

fm3_problems22

fm3_problems22 - about 8.000.000 8-decimal accurancy...

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

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

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

View Full Document
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
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 1. 0 5 10 15 20 25 EXP(X) X EXP(X)

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

View Full Document
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 )
Approximately how many runs does it require until you get 4-decimal accurancy for π using the MC 4-decimal accurancy

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

View Full Document

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

View Full Document

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

View Full Document
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

{[ snackBarMessage ]}