Difference between revisions of "User:Regina"

From Apache OpenOffice Wiki
Jump to: navigation, search
Line 77: Line 77:
  
 
===Sematics===
 
===Sematics===
: <code>IMCOSH("a+bj")</code> calculates:
+
<code>IMCOSH("a+bj")</code> calculates:
 
: <math> \cosh{(a)}\, \cos{(b)}+ \sinh{(a)}\, \sin{(b)} \mbox{ j}  </math>   
 
: <math> \cosh{(a)}\, \cos{(b)}+ \sinh{(a)}\, \sin{(b)} \mbox{ j}  </math>   
  
Line 93: Line 93:
  
 
===Semantics===
 
===Semantics===
: <code>IMCOT( z )</code> is equivalent to <code>IMDIV(IMCOS(z);IMSIN(z))</code>
+
<code>IMCOT( z )</code> is equivalent to <code>IMDIV(IMCOS(z);IMSIN(z))</code>
: To get better accuracy it is not implemented that way. With the notation <code>IMCOT("a+bj")="c+dj"</code> the used formulas are
+
To get better accuracy it is not implemented that way. With the notation <code>IMCOT("a+bj")="c+dj"</code> the used formulas are
 
: real part <math> c = \frac {\sin(2a)} {\cosh(2b)-\cos(2a)}</math>
 
: real part <math> c = \frac {\sin(2a)} {\cosh(2b)-\cos(2a)}</math>
 
: imaginary part <math>d= \frac {-\sinh(2b) } {\cosh(2b)-\cos(2a)}</math>  
 
: imaginary part <math>d= \frac {-\sinh(2b) } {\cosh(2b)-\cos(2a)}</math>  
Line 105: Line 105:
  
 
==IMCSC==
 
==IMCSC==
Returns the cosecant of a complex number
+
Returns the cosecant of a complex number.
  
 
===Syntax===
 
===Syntax===
Line 112: Line 112:
  
 
===Semantics===
 
===Semantics===
:<code>IMCSC( z )</code> is equivalent to <code>IMDIV(1;IMSIN( z ))</code>
+
<code>IMCSC( z )</code> is equivalent to <code>IMDIV(1;IMSIN( z ))</code>
: To get better accuracy it is not implemented that way. With the notation <code>IMCOT("a+bj")="c+dj"</code> the used formulas are
+
To get better accuracy it is not implemented that way. With the notation <code>IMCOT("a+bj")="c+dj"</code> the used formulas are
 
: real part <math> c = \frac{2\sin(a)\,\cosh(b)}{\cosh(2b)-\cos(2a)}</math>
 
: real part <math> c = \frac{2\sin(a)\,\cosh(b)}{\cosh(2b)-\cos(2a)}</math>
: imaginary part <math>d = - \frac{2\cos(a)\,\sinh(b)}{\cosh(2b)-\cos(2a)}</math>
+
: imaginary part <math>d = \frac{-2\cos(a)\,\sinh(b)}{\cosh(2b)-\cos(2a)}</math>
  
 
===Issues===
 
===Issues===
Line 123: Line 123:
  
 
==IMCSCH==
 
==IMCSCH==
Summary: Returns the hyperbolic cosecant of a complex number
+
Returns the hyperbolic cosecant of a complex number.
Syntax: IMCSCH( Complex N )
+
 
Returns: Number
+
===Syntax===
Constraints: None
+
<code>IMCSCH( z )</code>
Semantics: Computes the hyperbolic cosecant. This is equivalent to:
+
: where z is a complex number as described in [[Documentation/How_Tos/Calc:_Complex_Number_functions]]
IMDIV(1;IMSINH(N))
+
 
See also IMSINH, CSCH
+
===Semantics===
 +
<code>IMCSCH( z )</code> is equivalent to <code>IMDIV(1;IMSINH( z ))</code>
 +
: To get better accuracy it is not implemented that way. With the notation <code>IMCOT("a+bj")="c+dj"</code> the used formulas are
 +
: real part <math> c = \frac{2\sinh(2a)\,\cosh(b)}{\cosh(2a)-\cos(2b)}</math>
 +
: imaginary part <math>d = - \frac{2\cosh(2a)\,\sin(b)}{\cosh(2a)-\cos(2b)}</math>
 +
 
 +
 
 +
===Issues===
 +
The function is not implemented in versions before AOO 4.0 and before LibO 3.7.
 +
 
  
 
==IMSINH==
 
==IMSINH==
Summary: Returns the hyperbolic sine of a complex number  
+
Returns the hyperbolic sine of a complex number.
Syntax: IMSINH( Complex N )  
+
 
Returns: Complex
+
===Syntax===
Constraints: None
+
<code>IMSINH( z )</code>
Semantics: If N=a+bi, then sinh(N)=sinh(a)cos(b)+cosh(a)sin(b)i.  
+
: where z is a complex number as described in [[Documentation/How_Tos/Calc:_Complex_Number_functions]]
 +
 
 +
===Semantics===
 +
: If N=a+bi, then sinh(N)=sinh(a)cos(b)+cosh(a)sin(b)i.  
 +
 
 +
===Issues===
 +
The function is not implemented in versions before AOO 4.0 and before LibO 3.7.
 +
 
 +
 
 +
 
 
==IMSEC==
 
==IMSEC==
Summary: Returns the secant of a complex number
+
Returns the secant of a complex number.
Syntax: IMSEC(Complex N)
+
 
Returns: Complex
+
===Syntax===
Constraints: None
+
IMSEC( z )
Semantics: Equivalent to the following:
+
: where z is a complex number as described in [[Documentation/How_Tos/Calc:_Complex_Number_functions]]
 +
 
 +
===Semantics===
 +
Equivalent to the following:
 
IMDIV(1;IMCOS(N))
 
IMDIV(1;IMCOS(N))
See also IMCOS 6.8.7
+
 
 +
===Issues===
 +
The function is not implemented in versions before AOO 4.0 and before LibO 3.7.
 +
 
 +
 
 
==IMSECH==
 
==IMSECH==
Summary: Returns the hyperbolic secant of a complex number
+
Returns the hyperbolic secant of a complex number.
Syntax: IMSECH( Complex N )
+
 
Returns: Number
+
===Syntax===
Constraints: None
+
IMSECH( z )
Semantics: Computes the hyperbolic secant. This is equivalent to:
+
: where z is a complex number as described in [[Documentation/How_Tos/Calc:_Complex_Number_functions]]
 +
 
 +
===Semantics===
 +
Computes the hyperbolic secant. This is equivalent to:
 
IMDIV(1;IMCOSH(N))
 
IMDIV(1;IMCOSH(N))
See also IMCOSH, SECH
+
===Issues===
 +
The function is not implemented in versions before AOO 4.0 and before LibO 3.7.
 +
 
  
 
==IMTAN==
 
==IMTAN==
Summary: Returns the tangent of a complex number
+
Returns the tangent of a complex number.
Syntax: IMTAN(Complex N)
+
 
Returns: Complex
+
===Syntax===
Constraints: None
+
IMTAN( Z )
Semantics: Equivalent to the following (except N is computed only once):
+
: where z is a complex number as described in [[Documentation/How_Tos/Calc:_Complex_Number_functions]]
 +
 
 +
===Semantics===
 +
Equivalent to the following (except N is computed only once):
 
IMDIV(IMSIN(N);IMCOS(N))
 
IMDIV(IMSIN(N);IMCOS(N))
See also IMSIN, IMCOS, IMCOT 6.8.25
+
===Issues===
 +
The function is not implemented in versions before AOO 4.0 and before LibO 3.7.

Revision as of 17:15, 31 May 2012

native language
German
active in project
de, qa, sc, graphics, LibreOffice, Apache OpenOffice
user name
regina
special interest
www.ooowiki.de
email
rb.henschel@t-online.de

Anleitung

ToDo

Working on functions sides

Statistical functions

Functions listed alphabetically, Functions listed by category

ODFF and accuracy problems in statitistic functions

Treatment of new Excel 2010 functions

Planning Wiki-Pages

/MyDrafts new document on Precision and Accuracy

/MYDrafts2 new specification for print ranges

/MYDrafts3 TTEST

/MYDrafts4 TEX2WikiTest

/ComparisonWriterDrawPicture Comparison between Writer- and Draw-picture

Development

Currently: Adapt smoothing with splines to ODF1.2 norm

Sandbox

math tests

[[1]]

Test Wiki-markup here

<math>\sum_{k=1}^N k^2</math>

<math>\scriptstyle \sqrt {n-1}</math>

<math>\sqrt {n-1}</math>

<math> s_{X_1 - X_2}</math>

<math>1-P( -|z| \le Z \le |z|)</math>

<math>\textstyle \sum_{k=1}^N k^2</math>

<math>\sum_{k=1}^N k^2</math>

<math>\int_{1}^{3}\frac{e^3/x}{x^2}\, dx</math>

<math>\sum_{k=1}^N k^2</math>

<math>\frac{1}{N} \sum_{k=2}^N k^2</math>

\frac{1} {n} \sum_{i} {(x_i - \bar x)(y_i - \bar y)}</math>

dashboard

IMCOSH

Returns the hyperbolic cosine of a complex number.

Syntax

IMCOSH( z )

where z is a complex number as described in Documentation/How_Tos/Calc:_Complex_Number_functions

Sematics

IMCOSH("a+bj") calculates:

Issues

The function is not implemented in versions before AOO 4.0 and before LibO 3.7.


IMCOT

Returns the cotangent of a complex number

Syntax

IMCOT( z )

where z is a complex number as described in Documentation/How_Tos/Calc:_Complex_Number_functions

Semantics

IMCOT( z ) is equivalent to IMDIV(IMCOS(z);IMSIN(z)) To get better accuracy it is not implemented that way. With the notation IMCOT("a+bj")="c+dj" the used formulas are

real part
imaginary part

Issues

The function is not implemented in versions before AOO 4.0 and before LibO 3.7.



IMCSC

Returns the cosecant of a complex number.

Syntax

IMCSC( z )

where z is a complex number as described in Documentation/How_Tos/Calc:_Complex_Number_functions

Semantics

IMCSC( z ) is equivalent to IMDIV(1;IMSIN( z )) To get better accuracy it is not implemented that way. With the notation IMCOT("a+bj")="c+dj" the used formulas are

real part
imaginary part

Issues

The function is not implemented in versions before AOO 4.0 and before LibO 3.7.


IMCSCH

Returns the hyperbolic cosecant of a complex number.

Syntax

IMCSCH( z )

where z is a complex number as described in Documentation/How_Tos/Calc:_Complex_Number_functions

Semantics

IMCSCH( z ) is equivalent to IMDIV(1;IMSINH( z ))

To get better accuracy it is not implemented that way. With the notation IMCOT("a+bj")="c+dj" the used formulas are
real part
imaginary part


Issues

The function is not implemented in versions before AOO 4.0 and before LibO 3.7.


IMSINH

Returns the hyperbolic sine of a complex number.

Syntax

IMSINH( z )

where z is a complex number as described in Documentation/How_Tos/Calc:_Complex_Number_functions

Semantics

If N=a+bi, then sinh(N)=sinh(a)cos(b)+cosh(a)sin(b)i.

Issues

The function is not implemented in versions before AOO 4.0 and before LibO 3.7.


IMSEC

Returns the secant of a complex number.

Syntax

IMSEC( z )

where z is a complex number as described in Documentation/How_Tos/Calc:_Complex_Number_functions

Semantics

Equivalent to the following:

IMDIV(1;IMCOS(N))

Issues

The function is not implemented in versions before AOO 4.0 and before LibO 3.7.


IMSECH

Returns the hyperbolic secant of a complex number.

Syntax

IMSECH( z )

where z is a complex number as described in Documentation/How_Tos/Calc:_Complex_Number_functions

Semantics

Computes the hyperbolic secant. This is equivalent to: IMDIV(1;IMCOSH(N))

Issues

The function is not implemented in versions before AOO 4.0 and before LibO 3.7.


IMTAN

Returns the tangent of a complex number.

Syntax

IMTAN( Z )

where z is a complex number as described in Documentation/How_Tos/Calc:_Complex_Number_functions

Semantics

Equivalent to the following (except N is computed only once): IMDIV(IMSIN(N);IMCOS(N))

Issues

The function is not implemented in versions before AOO 4.0 and before LibO 3.7.

Personal tools