Difference between revisions of "User:Regina"

From Apache OpenOffice Wiki
Jump to: navigation, search
(removed finished sections)
Line 66: Line 66:
  
 
=== dashboard ===
 
=== dashboard ===
 
 
 
==IMCOSH==
 
Returns the hyperbolic cosine of a complex number.
 
 
===Syntax===
 
<code>IMCOSH( z )</code>
 
: where z is a complex number as described in [[Documentation/How_Tos/Calc:_Complex_Number_functions]]
 
 
===Sematics===
 
<code>IMCOSH("a+bj")</code> calculates
 
: <math> \cosh{(a)}\, \cos{(b)}+ \sinh{(a)}\, \sin{(b)} \mbox{ j}  </math> 
 
 
===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===
 
<code>IMCOT( z )</code>
 
: where z is a complex number as described in [[Documentation/How_Tos/Calc:_Complex_Number_functions]]
 
 
===Semantics===
 
<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
 
: real part <math> c = \frac {\sin(2a)} {\cosh(2b)-\cos(2a)}</math>
 
: imaginary part <math>d= \frac {-\sinh(2b) } {\cosh(2b)-\cos(2a)}</math>
 
 
===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===
 
<code>IMCSC( z )</code>
 
: where z is a complex number as described in [[Documentation/How_Tos/Calc:_Complex_Number_functions]]
 
 
===Semantics===
 
<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
 
: 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>
 
 
===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===
 
<code>IMCSCH( z )</code>
 
: where z is a complex number as described in [[Documentation/How_Tos/Calc:_Complex_Number_functions]]
 
 
===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)\,\cos(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==
 
Returns the hyperbolic sine of a complex number.
 
 
===Syntax===
 
<code>IMSINH( z )</code>
 
: where z is a complex number as described in [[Documentation/How_Tos/Calc:_Complex_Number_functions]]
 
 
===Semantics===
 
<code>IMSINH("a+bj")</code> calculates
 
: <math>\sinh{(a)}\, \cos{(b)}+ \cosh{(a)}\, \sin{(b)} \mbox{ j}</math> 
 
 
===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===
 
<code>IMSEC( z )</code>
 
: where z is a complex number as described in [[Documentation/How_Tos/Calc:_Complex_Number_functions]]
 
 
===Semantics===
 
<code>IMSEC( z )</code> is equivalent to <code>IMDIV(1;IMCOS( 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\cos(a)\,\cosh(b)}{\cosh(2b)+\cos(2a)}</math>
 
: imaginary part <math>d = \frac{2\sin(a)\,\sinh(b)}{\cosh(2b)+\cos(2a)}</math>
 
 
===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===
 
<code>IMSECH( z )</code>
 
: where z is a complex number as described in [[Documentation/How_Tos/Calc:_Complex_Number_functions]]
 
 
===Semantics===
 
<code>IMSECH( z )</code> is equivalent to <code>IMDIV(1;IMCOSH( 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\cosh(2a)\,\cos(b)}{\cosh(2a)+\cos(2b)}</math>
 
: imaginary part <math>d = \frac{-2\sinh(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.
 
 
 
==IMTAN==
 
Returns the tangent of a complex number.
 
 
===Syntax===
 
<code>IMTAN( Z )</code>
 
: where z is a complex number as described in [[Documentation/How_Tos/Calc:_Complex_Number_functions]]
 
 
===Semantics===
 
<code>IMTAN( Z )</code> is equivalent to <code>IMDIV(IMSIN( z );IMCOS( 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{\sin(2a)}{\cos(2a)+\cosh(2b)}</math>
 
: imaginary part <math>d = \frac{\sinh(2b)}{\cos(2a)+\cosh(2b)}</math>
 
 
 
===Issues===
 
The function is not implemented in versions before AOO 4.0 and before LibO 3.7.
 

Revision as of 15:25, 8 June 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

Personal tools