|
![]() |
|
|||||||||
|
|
|||||||||||||||
| Sample calculation |
| Index |
| Example | Calculation contents | Digit number | Calculation mode | ||
| Arithmetical operation | 10+20-30*4/6 [execution] | 10 | 6 | ||
| Calculation with parenthesis | (2+3)*4 [execution] | 20 | 6 | ||
| Power calculation | 3*4^2 [execution] | 48 | 6 | ||
| Calculation with Exponent | 99*1.23E+3 [execution] | 121770 | 6 | ||
| Use of function | sqrt(4) [execution] | 2 | 6 | ||
| Increase of digit number | sin(12345) [execution] [setting] operation digit number from 6 to 10 [execution] |
0.965926 0.9659258263 |
6 ↓ 10 |
real number DEG | |
| Use of variable | sin(x) [execution] (variable) x = 456 [execution] |
0.9945218954 | 10 | real number DEG | |
| Change of operation digit number | cos(12345) [execution] [setting] operation digit number from 10 to 22 [execution] |
-0.2588190451 -0.2588190451025207623489 |
10 ↓ 22 |
real number DEG | |
| Change of calculation mode | cos(123456) [execution] [setting] calculation mode from real number DEG to real number RAD [execution] |
0.9135454576426008955021 -0.67229488165658452 |
22 | real number DEG ↓ real number RAD |
|
| Repetition calculation x = 1,0.1,10 1: initial value 0.1: incremental value 10: repeat count |
sin(x) [execution] (variable) x = 1, 0.1,10 [execution] |
1 1.1 1.2 1.3 1.4 1.5 1.6 1.7 1.8 1.9 |
0.8414709848078965066525 0.8912073600614353399518 0.9320390859672263496701 0.9635581854171929647013 0.9854497299884601806595 0.9974949866040544309417 0.9995736030415051643421 0.9916648104524686153461 0.9738476308781951865324 0.9463000876874144884897 |
22 | real number RAD |
| Example | Calculation contents | Digit number | Calculation mode | |
| Arithmetical operation | (3+4i)*(5+6i) [Execution] | -9 +38i | 6 | complex number RAD |
| Elementary function | sin(1+i) [Execution] ln(-5) [Execution] |
1.29846 +0.634964i 1.60944 +3.14159i |
6 | complex number RAD |
| Special function | gamma(2+3i) [Execution] | -0.082395 +0.091774i | 6 | complex number RAD |
| Example | Input formula and variable | Digit number & Calculation mode |
Chart drawing | Chart setting |
| √ | sqrt(x) x=0,0.1, 51 |
6 real number DEG |
![]() |
chart width =300, height =200 X axis tick skip =10 |
| Trigonometric function | sin(x); cos(x) x=0,5,101 |
6 real number DEG |
![]() |
chart width =400, height =250 X axis tick skip =18 ■=sin(x) ■=cos(x) |
| Normal distribution | normalpd(x) x=-5,0.1, 101 |
6 real number DEG |
![]() |
chart width =400, height =250 Y axis scale Max=0.4 and Min=0 |
| Bessel function J0(x), Y0(x) |
besselj(0, x); bessely(0, x) x=0,1,101 |
6 real number DEG |
![]() |
chart width =400, height =250 Y axis scale Max=1 and Min=-1 ■=J0(x) ■=Y0(x) |
| Example | Digit number & Calculation mode |
Keisαn (6 operational digit number) |
Excel2003 (16 operational digit number) |
Comment |
| Decimal calculation 0.4-0.3-0.1 |
6 real number RAD |
0.4-0.3-0.1 = 0 |
(0.4-0.3-0.1) = 2.77556E-17 |
Error is caused by binary-to-decimal conversion. |
| π Calculation sin(9π) |
6 real number RAD |
sin(9*pi) = 0 |
SIN(9*PI()) = 1.10263E-15 |
Error is caused by numerical calculation of irrational number. |
| Irrational number calculation 9√2- √162 |
6 real number RAD |
9*sqrt(2)-sqrt(162) = 0 |
(9*SQRT(2)-SQRT(162)) = 1.77636E-15 |
Error is caused by numerical calculation of irrational number. |
| Complex number calculation (1+i)4 |
6 complex number RAD |
(1+i)^4 = -4 |
IMPOWER(“1+i”, 4) = -4+4.89842541528951E-016i |
(1+i)4= (√2*eiπ/4)4= (√2)4*eiπ= -4 |
| Square root calculation of √(1+x) - 1 √ (1+1.23456E-100) -1 |
6 real number RAD |
sqrt(1+1.23456E-100) -1 = 6.1728E-101 |
SQRT(1+1.23456E-100) - 1 = 0 |
In case of x ≪1、Excel often approximates the calculation of "x+1" as "1", and thus reduces its calculation precision. |
| Exponential calculation of e^ln(1+x) -1 e^ln(1+1.23456E-14) -1 |
6 real number RAD |
e^ln(1+1.23456E-14) -1 = 1.23456E-14 |
EXP(LN(1+1.23456E-14))- 1 = 1.24345E-14 |
In case of x≒1E-14,Excel shows only three digit of precision. |
| Exponential calculation of e^ln(1+x) -1 e^ln(1+1.23456E-15) -1 |
6 real number RAD |
e^ln(1+1.23456E-15) -1 = 1.23456E-15 |
EXP(LN(1+1.23456E-15))- 1 = 0 |
In case of x <1E-15, Excel shows low precision in calculation. |
| Kinetic energy of human body E=mc2(1-√(1-v2/c2)) m=80 kg, v=100/9.77 m/s, c=299792458 m/s |
6 real number RAD |
m=80; v=100/9.77; c=299792458; m*c^2* (1-sqrt(1-v^2/c^2)) = 4190.55 |
m=80; v=100/9.77; c=299792458; m*c^2* (1-SQRT (1-v^2/c^2)) = 3991.274772 |
In case of v ≪c, Newton method approximation can be applied. E=mv2/2=4190.55 |
| Contact us Terms of use About us | All Rights Reserved, Copyright (C) CASIO COMPUTER CO., LTD. |