Difference between revisions of "User:Regina"

From Apache OpenOffice Wiki
Jump to: navigation, search
(→‎Syntax)
 
(75 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 
;native language: German
 
;native language: German
−
;active in project: de, qa. sc
+
;active in project: de, qa, sc, graphics, LibreOffice, Apache OpenOffice
−
;OOo user name: regina
+
;user name: regina
 
;special interest: www.ooowiki.de
 
;special interest: www.ooowiki.de
−
 
+
;email: rb.henschel@t-online.de
  
 
[[Anleitung]]
 
[[Anleitung]]
  
−
==Sandbox==
+
== ToDo ==
−
 
+
=== Working on functions sides ===
−
__NOTOC__
+
−
 
+
−
== CHISQDIST ==
+
−
Calculates values for a &chi;<sup>2</sup>-distribution.
+
−
 
+
−
=== Syntax ===
+
−
<tt>'''CHISQDIST(x; k; Cumulative)'''</tt>
+
−
 
+
−
: <tt>'''x'''</tt> is a number.
+
−
 
+
−
: <tt>'''k'''</tt> is the (positive integer) degrees of freedom for the &chi;<sup>2</sup>-distribution.
+
−
 
+
−
: <tt>'''Cumulative'''</tt> is a logical value. In the case Cumulative=TRUE() the cumulative distribution function is used, in the case Cumulative=FALSE() the probability density function. This parameter is optional. It is set to TRUE() if missing.
+
−
 
+
−
=== Semantic ===
+
−
 
+
−
<tt>'''CHISQDIST(x; k; FALSE())'''</tt> returns the probability density function for the &chi;<sup>2</sup>-distribution:
+
−
 
+
−
:<math> 0 \quad \textrm{for}\; x < 0 </math>
+
−
and
+
−
:<math>  \frac {x^{\frac k 2 -1}\,\mathrm e^{- \frac x 2}} {2^{\frac k 2}\,\Gamma(\frac k 2) } \quad \textrm{for}\; x \ge 0 </math>
+
−
 
+
−
<tt>'''CHISQDIST(x; k; TRUE())'''</tt> returns the left tail probability for the &chi;<sup>2</sup>-distribution:
+
−
:<math>0\quad \textrm{for}\; x<0</math>
+
−
and
+
−
:<math> \int_0^x \frac {t^{\frac k 2 -1}\,\mathrm e^{- \frac t 2}} {2^{\frac k 2}\,\Gamma(\frac k 2) }\,\mathrm d t \quad \textrm{for}\; x \ge 0</math>
+
−
 
+
−
=== Semantic with forced pictures ===
+
−
 
+
−
<tt>'''CHISQDIST(x; k; FALSE())'''</tt> returns the probability density function for the &chi;<sup>2</sup>-distribution:
+
−
 
+
−
:<math> 0 \quad \textrm{for}\; x < 0 \,\!</math>
+
−
and
+
−
:<math>  \frac {x^{\frac k 2 -1}\,\mathrm e^{- \frac x 2}} {2^{\frac k 2}\,\Gamma(\frac k 2) } \quad \textrm{for}\; x \ge 0 \,\!</math>
+
−
 
+
−
<tt>'''CHISQDIST(x; k; TRUE())'''</tt> returns the left tail probability for the &chi;<sup>2</sup>-distribution:
+
−
:<math>0\quad \textrm{for}\; x<0 \,\!</math>
+
−
and
+
−
:<math> \int_0^x \frac {t^{\frac k 2 -1}\,\mathrm e^{- \frac t 2}} {2^{\frac k 2}\,\Gamma(\frac k 2) }\,\mathrm d t \quad \textrm{for}\; x \ge 0 \,\!</math>
+
−
 
+
−
=== Example ===
+
−
<tt>'''CHSQDIST(2.7;3;FALSE())'''</tt>
+
−
: returns approximately 0.1699395239
+
−
 
+
−
<tt>'''CHSQDIST(2.7;3;TRUE())'''</tt>
+
−
: returns approximately 0.5597727056
+
−
 
+
−
.
+
−
 
+
−
=== See also: ===
+
−
[[Documentation/How_Tos/Calc: CHISQINV function|'''CHISQINV''']],
+
−
[[Documentation/How_Tos/Calc: CHIDIST function|'''LEGACY.CHIDIST''']],
+
−
[[Documentation/How_Tos/Calc: CHIINV function|'''LEGACY.CHIINV''']],
+
−
[[Documentation/How_Tos/Calc: CHITEST function|'''CHITEST''']]
+
−
 
+
 
[[Documentation/How_Tos/Calc: Statistical functions|'''Statistical functions''']]
 
[[Documentation/How_Tos/Calc: Statistical functions|'''Statistical functions''']]
  
Line 69: Line 14:
 
[[Documentation/How_Tos/Calc: Functions listed by category|'''Functions listed by category''']]
 
[[Documentation/How_Tos/Calc: Functions listed by category|'''Functions listed by category''']]
  
−
=== Issues: ===
+
[[Calc/ODFF_Implementation/Examine_functions|ODFF and accuracy problems in statitistic functions]]
−
This function is expected for OOo3.1
+
  
−
__NOTOC__
+
[[Calc/Drafts/Treatment_of_new_Excel_2010_functions|Treatment of new Excel 2010 functions]]
  
−
== CHISQINV ==
+
=== Planning Wiki-Pages ===
−
Calculates the inverse of the CHISQDIST function.
+
[[/MyDrafts]] new document on ''Precision and Accuracy''
  
−
=== Syntax ===
+
[[/MYDrafts2]] new specification for print ranges
−
<tt>'''CHISQINV(p; k)'''</tt>
+
−
: <tt>'''k'''</tt> is the degrees of freedom for the &chi;<sup>2</sup>-distribution.
+
  
−
Constraint: k must be a positive integer
+
[[/MYDrafts3]] TTEST
  
−
: <tt>'''p'''</tt> is the given probability
+
[[/MYDrafts4]] Angle problems in ODF 1.2
  
−
Constraint: 0 &le; p < 1
+
[[/ComparisonWriterDrawPicture]] Comparison between Writer- and Draw-picture
  
−
=== Semantic ===
+
[[/MYDrafts5]] Custom Shapes
  
−
: <tt>'''CHISQINV(p; k)'''</tt> returns the value <tt>'''x'''</tt>, such that <tt>'''CHISQDIST(x; k;TRUE())''' = '''p'''</tt>.
+
=== Development ===
 +
Currently: Adding more font colors to Math [[/MYDrafts6]] Colors in Math
  
−
=== Example ===
+
== Sandbox ==
−
<tt>'''CHISQINV(0.5724; 3)'''</tt>
+
=== math tests ===
−
: returns approximately 2.
+
  
−
=== See also: ===
+
[[http://meta.wikimedia.org/wiki/Help:Formula]]
−
[[Documentation/How_Tos/Calc: CHISQDIST function|'''CHISQDIST''']]
+
−
[[Documentation/How_Tos/Calc: CHIDIST function|'''CHIDIST''']]
+
−
[[Documentation/How_Tos/Calc: CHIINV function|'''CHIINV''']]
+
  
−
[[Documentation/How_Tos/Calc: Statistical functions|'''Statistical functions''']]
+
Test Wiki-markup here
  
−
[[Documentation/How_Tos/Calc: Functions listed alphabetically|'''Functions listed alphabetically''']],
+
<math>\sum_{k=1}^N k \pm i</math>
−
[[Documentation/How_Tos/Calc: Functions listed by category|'''Functions listed by category''']]
+
  
−
=== Issues: ===
+
<math>a - b </math>
−
* This function is expected for OOo3.1
+
  
 +
<math>a + b</math>
  
−
== GAMMA ==
+
<math>{a \pm b}</math>
−
Returns the values of the Gamma function.
+
  
−
=== Syntax ===
+
<nowiki><math>\sum_{k=1}^N k^2</math></nowiki>
−
<tt>'''GAMMA(x)'''</tt>
+
<math>\sum_{k=1}^N k^2</math>
  
−
:<tt>'''x'''</tt> is a number.
+
<math>\scriptstyle \sqrt {n-1}</math> <nowiki> <math>\scriptstyle \sqrt {n-1}</math> </nowiki>
  
−
Constraint: If x is an integer, then x must be positive.
+
<math>\sqrt {n-1}</math> <nowiki><math>\sqrt {n-1}</math> </nowiki>
  
−
=== Semantic ===
+
<math> s_{X_1 - X_2}</math> <nowiki><math> s_{X_1 - X_2}</math> </nowiki>
−
<tt>'''GAMMA(x)'''</tt> calculates
+
−
: <math>\Gamma(x) = \int_0^\infty t^{x-1} \mathrm e^{- t} \mathrm d t \,\!</math>.
+
  
−
For x &lt; 0.5 Eulers reflection formula is use.
+
<math>1-P( -|z| \le Z \le |z|)</math> <nowiki> <math>1-P( -|z| \le Z \le |z|)</math> </nowiki>
  
−
The Gamma function has poles for negative integers and for zero. Near to poles the values might be less accurate.
+
<math>\textstyle \sum_{k=1}^N k^2</math> <nowiki> <math>\textstyle \sum_{k=1}^N k^2</math> </nowiki>
  
−
If x is a positive integer, then
+
<math>\sum_{k=1}^N k^2</math> <nowiki> <math>\sum_{k=1}^N k^2</math> </nowiki>
−
: <math>\displaystyle \Gamma(x)=(x-1)\mathrm ! </math>
+
−
But be aware, that OpenOffice.org has only a precision of 15 digits, therefore the results for x &gt; 21 are rounded.
+
  
−
=== Example ===
+
<math>\int_{1}^{3}\frac{e^3/x}{x^2}\, dx</math> <nowiki> <math>\int_{1}^{3}\frac{e^3/x}{x^2}\, dx</math> </nowiki>
−
: <tt>'''GAMMA(4) = 6.0'''</tt> exact
+
−
: <tt>'''GAMMA(34.56)''' &asymp; 6.2336323276E+037</tt>
+
−
: <tt>'''GAMMA(&minus;4)'''</tt> not defined
+
  
 +
<nowiki><math>\sum_{k=1}^N k^2</math></nowiki>
 +
<math>\sum_{k=1}^N k^2</math>
  
−
=== See also: ===
+
<math>\frac{1}{N} \sum_{k=2}^N k^2</math>
−
[[Documentation/How_Tos/Calc: GAMMADIST function|'''GAMMALN''']],
+
<nowiki><math>\frac{1}{N} \sum_{k=2}^N k^2</math></nowiki>
−
[[Documentation/How_Tos/Calc: GAMMAINV function|'''GAMMADIST''']],
+
−
[[Documentation/How_Tos/Calc: GAMMAINV function|'''GAMMAINV''']],
+
−
[[Documentation/How_Tos/Calc: GAMMAINV function|'''FACT''']]
+
  
−
[[Documentation/How_Tos/Calc: Mathematical functions|'''Mathematical functions''']]
+
<math>\frac{1} {n} \sum_{i} {(x_i - \bar x)(y_i - \bar y)}</math>
−
 
+
<nowiki>\frac{1} {n} \sum_{i} {(x_i - \bar x)(y_i - \bar y)}</math></nowiki>
−
[[Documentation/How_Tos/Calc: Statistical functions|'''Statistical functions''']]
+
−
 
+
−
[[Documentation/How_Tos/Calc: Functions listed alphabetically|'''Functions listed alphabetically''']],
+
−
[[Documentation/How_Tos/Calc: Functions listed by category|'''Functions listed by category''']]
+
  
−
=== Issues: ===
+
=== dashboard ===
−
This function is expected for OOo3.1.
+

Latest revision as of 11:38, 23 October 2014

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 Angle problems in ODF 1.2

/ComparisonWriterDrawPicture Comparison between Writer- and Draw-picture

/MYDrafts5 Custom Shapes

Development

Currently: Adding more font colors to Math /MYDrafts6 Colors in Math

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

Retrieved from "https://wiki.openoffice.org/w/index.php?title=User:Regina&oldid=235707"
Personal tools