New Way to Calculate Pi in Excel - Manually
Loading...
Uploaded by ChookaTV on Dec 3, 2010
This video shows how PI is calculated by using the Pythagorean Theorem in an algorithm that calculates the hypotenuse of an increasing number of triangles within the circle - akin to pizza slices in a pizza pie. An overview of the algorithm is given, followed by the actual formulas being implemented in excel.
The output after 24 iterations of the main algorithm calculates Pi to 15 decimal places - the limit of Excel's calculating engine. The result is compared against the Excel formula for Pi which is "=PI() " and shown to be identical. At this point, the formula calculates the length of the hypotenuse of over 67 million triangle slices in order to determine the value of Pi out to 15 decimal places.
Further iterations of the algorithm calculate the lengths of an increasing number of hypotenuse that would result in a more refined value for Pi, were it not for the limitation of Excel.
9:59
Archimedes Pi Calculation IIby nymathteacher3,358 views- 1:13
Pi, How do you calculate it?by mathematicsonline8,791 views
- 10:15
Calculating Pi 2.MP4by purdueMET2,862 views
- 11:13
How to calculate formulas and functions in Excel using Windowsby kbcoble19,023 views
- 1:27
Piby StephensAccountify4,500 views
- 9:33
Calculating Pi 1.MP4by purdueMET3,129 views
- 3:52
How To Compute Piby videojugeducation600 views
- 1:35
if you are genius solve thisby sarijaradat2,786,786 views
- 9:37
Happy Pi Day!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!by pimanrules530,664 views
- 5:26
PROGRAMACION EN EXCEL -Avanzado P I - Richard Zegarra Estradaby TheMasterZ77710,897 views
- 10:28
EXCEL PARA CONTADORES - P I - Richard Zegarra Estradaby TheMasterZ77742,708 views
- 1:24
Zeno's Paradox # 1by JoshL1118526,343 views
- 6:29
Capital Rationing & Profitability Indexby rcatweets1,055 views
- 5:37
How to Calculate Pi Exactlyby FaradaysBirdCage745 views
- 1:52
Happy Pi Day!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!by Nigznigzdotcom13,784 views
- 2:33
How to Calculate pi by throwing hotdogsby durtyrolo1,065 views
- 0:08
Archimedes' Approximation of Piby wolframmathematica5,298 views
- 7:50
Excel for Math Classes: Pythagorean Triples Iby dborkovitz902 views
- 1:11
the constant value of pi from the circleby ADITSHARMA900791 views
- 5:24
Math Made Easy: Measuring Angles (part 2)by jediteacher200729,212 views
0.0 nice
c0ssu1 6 months ago