Information Technology

Class 06

09. 11. 2015


Introduction

There are many formulas for calculating the value of π = 3.1415926535897932384626433832795028841971693993751 ··· 

F. Vieta (1540 – 1603) (1)
F. Wallis (1616 – 1703) (2)
J. Gregory (1638 – 1675),
G. W. Leibniz (1646 – 1716)
neboli
(3)
L. Euler (1707 – 1783) (4)
(5)
S. Ramanujan (1887 – 1920) (6)


Tasks

  1. Open a new workbook and save it in your folder under the name calculations.xls.



  2. Create the table (as given below). All decimal numbers will be displayed with a precision of 6 decimal places. The number of approximation steps is 200. In the column Error, there is the value of the difference between the calculated and the exact value of π returned by the function PI().







  3. Use the equation editor to create formulae. The following example shows you how you can create a table.





  4. Create a graph (in a new sheet) for the calculated values, as shown below. The y-axis will range from 2.5 to 4.0.





  5. OPTIONAL TASK – Try to compute the value of π according to the formula given by S. Ramanujan, as shown below.








Selected functions

SUM( ... ) Adds all the numbers given as arguments and returns the sum.
PRODUCT( ... ) Multiplies all the numbers given as arguments and returns the product.
PI() Returns the mathematical constant π, accurate to 15 digits.
POWER(number;power) Returns the result of a number raised to a power.
SQRT(number) Returns a positive square root.
FACT(number) Returns the factorial of a number.