Difference between revisions of "Calc/Drafts/Treatment of new Excel 2010 functions"
m (corrected links) |
(→CHISQ.INV) |
||
Line 44: | Line 44: | ||
== CHISQ.INV == | == CHISQ.INV == | ||
− | new | + | new |
+ | ;Excel: CHISQ.INV(probability,deg_freedom), both arguments required | ||
+ | :0<=probability<1, | ||
+ | :1<=deg_freedom<=10^10, deg_freedom is truncated to integer | ||
+ | ;ODF1.2: CHISQINV( Number p ; Number DegreesOfFreedom ) | ||
+ | :0<=p<1 | ||
+ | :DegreesOfFreedom is a positive integer | ||
+ | ;OOo3.2: is already implemented as CHISQINV as ODF1.2 defines | ||
+ | :0<=p<1 | ||
+ | :DegreesOfFreedom is truncated as in Excel, DegreesOfFreedom > 0, no fixed upper bound for DegreesOfFreedom, but calculation might not converge | ||
+ | |||
+ | === Comment === | ||
+ | Directly mapping is possible in import. | ||
== CHISQ.INV.RT == | == CHISQ.INV.RT == |
Revision as of 16:25, 7 April 2010
This article is a workspace for discussing the treatment of new functions of Excel 2010 in OpenOffice.org code. For using functions in spreadsheets look at Documentation/How_Tos/Calc:_Functions_listed_alphabetically
Please do not chance the layout to a table. Such table makes it hard to edit a single section.
You want to help collecting the information? Try to add: Which parameters has the function? Does a corresponding OOo function exists already? Does a corresponding function exists in ODF 1.2? How difficult is it to implement a new function if necessary? Do you see any problems or obstacles?
Contents
- 1 Reference Documents
- 2 AGGREGATE
- 3 BETA.DIST
- 4 BETA.INV
- 5 BINOM.DIST
- 6 BINOM.INV
- 7 CHISQ.DIST
- 8 CHISQ.DIST.RT
- 9 CHISQ.INV
- 10 CHISQ.INV.RT
- 11 CHISQ.TEST
- 12 CONFIDENCE.NORM
- 13 CONFIDENCE.T
- 14 COVARIANCE.P
- 15 COVARIANCE.S
- 16 EXPON.DIST
- 17 F.DIST
- 18 F.DIST.RT
- 19 F.INV
- 20 F.INV.RT
- 21 F.TEST
- 22 GAMMA.DIST
- 23 GAMMA.INV
- 24 HYPGEOM.DIST
- 25 ISO.CEILING
- 26 LOGNORM.DIST
- 27 LOGNORM.INV
- 28 MODE.MULT
- 29 MODE.SNGL
- 30 NEGBINOM.DIST
- 31 NETWORKDAYS.INTL
- 32 NORM.DIST
- 33 NORM.INV
- 34 NORM.S.DIST
- 35 NORM.S.INV
- 36 PERCENTILE.EXC
- 37 PERCENTILE.INC
- 38 PERCENTRANK.EXC
- 39 PERCENTRANK.INC
- 40 POISSON.DIST
- 41 QUARTILE.EXC
- 42 QUARTILE.INC
- 43 RANK.AVG
- 44 RANK.EQ
- 45 STDEV.P
- 46 STDEV.S
- 47 T.DIST
- 48 T.DIST.2T
- 49 T.DIST.RT
- 50 T.INV
- 51 T.INV.2T
- 52 T.TEST
- 53 VAR.P
- 54 VAR.S
- 55 WEIBULL.DIST
- 56 WORKDAY.INTL
- 57 Z.TEST
Reference Documents
The discussion uses the description of the new functions in Function Improvements in Microsoft Office Excel 2010 and in What's New: Changes made to Excel functions and the connected descriptions of the functions.
For ODF 1.2 the actual document from OpenDocument - Formula SC Public Documents is used.
AGGREGATE
new
BETA.DIST
renamed BETADIST
BETA.INV
renamed BETAINV
BINOM.DIST
renamed BINOMDIST
BINOM.INV
renamed CRITBINOM
CHISQ.DIST
new
- Excel
- CHISQ.DIST(x,deg_freedom,cumulative), all parameters required
- x >= 0
- deg_freedom is truncated to integer, 0<deg_freedom<=10^10
- cumulative is logical, but numbers are accepted too
- ODF1.2
- CHISQDIST( Number x ; Number DegreesOfFreedom [ ; Logical Cumulative = TRUE() ] )
- OOo3.2
- is already implemented as ODF1.2 definies
- no constraints for x
- DegreesOfFreedom are truncated as in Excel, DegreesOfFreedom > 0, no fixed upper bound for DegreesOfFreedom
Comment
Directly mapping is possible in import.
CHISQ.DIST.RT
renamed CHIDIST
CHISQ.INV
new
- Excel
- CHISQ.INV(probability,deg_freedom), both arguments required
- 0<=probability<1,
- 1<=deg_freedom<=10^10, deg_freedom is truncated to integer
- ODF1.2
- CHISQINV( Number p ; Number DegreesOfFreedom )
- 0<=p<1
- DegreesOfFreedom is a positive integer
- OOo3.2
- is already implemented as CHISQINV as ODF1.2 defines
- 0<=p<1
- DegreesOfFreedom is truncated as in Excel, DegreesOfFreedom > 0, no fixed upper bound for DegreesOfFreedom, but calculation might not converge
Comment
Directly mapping is possible in import.
CHISQ.INV.RT
renamed CHIINV
CHISQ.TEST
renamed CHITEST
CONFIDENCE.NORM
renamed CONFIDENCE
CONFIDENCE.T
new
COVARIANCE.P
renamed COVAR
COVARIANCE.S
new
EXPON.DIST
renamed EXPONDIST
F.DIST
new
F.DIST.RT
renamed FDIST
F.INV
new
F.INV.RT
renamed FINV
F.TEST
renamed FTEST
GAMMA.DIST
renamed GAMMADIST
GAMMA.INV
renamed GAMMAINV
HYPGEOM.DIST
renamed HYPGEOMDIST
ISO.CEILING
new
LOGNORM.DIST
renamed LOGNORMDIST
LOGNORM.INV
renamed LOGINV
MODE.MULT
new
MODE.SNGL
renamed MODE
NEGBINOM.DIST
renamed NEGBINOMDIST
NETWORKDAYS.INTL
new
NORM.DIST
renamed NORMDIST
NORM.INV
renamed NORMINV
NORM.S.DIST
renamed NORMSDIST
NORM.S.INV
renamed NORMSINV
PERCENTILE.EXC
new
PERCENTILE.INC
renamed PERCENTILE
PERCENTRANK.EXC
new
PERCENTRANK.INC
renamed PERCENTRANK
POISSON.DIST
renamed POISSON
QUARTILE.EXC
new
QUARTILE.INC
renamed QUARTILE
RANK.AVG
new
RANK.EQ
renamed RANK
STDEV.P
renamed STDEVP
STDEV.S
renamed STDEV
T.DIST
new
T.DIST.2T
renamed TDIST
T.DIST.RT
renamed TDIST
T.INV
new
T.INV.2T
renamed TINV
T.TEST
renamed TTEST
VAR.P
renamed VARP
VAR.S
renamed VAR
WEIBULL.DIST
renamed WEIBULL
WORKDAY.INTL
new
Z.TEST
renamed ZTEST