Difference between revisions of "Manuals/calci/ALL"
Jump to navigation
Jump to search
| (11 intermediate revisions by 2 users not shown) | |||
| Line 4: | Line 4: | ||
*[[Manuals/calci/AVERAGE | AVERAGE ]] | *[[Manuals/calci/AVERAGE | AVERAGE ]] | ||
*[[Manuals/calci/AVERAGEA | AVERAGEA ]] | *[[Manuals/calci/AVERAGEA | AVERAGEA ]] | ||
| + | *[[Manuals/calci/Bartlett%27sTest | Bartlett's Test ]] | ||
*[[Manuals/calci/BERNOULLI | BERNOULLI ]] | *[[Manuals/calci/BERNOULLI | BERNOULLI ]] | ||
*[[Manuals/calci/BETADIST | BETADIST ]] | *[[Manuals/calci/BETADIST | BETADIST ]] | ||
| Line 107: | Line 108: | ||
*[[Manuals/calci/KRUSKALWALLISTEST | KRUSKALWALLISTEST ]] | *[[Manuals/calci/KRUSKALWALLISTEST | KRUSKALWALLISTEST ]] | ||
*[[Manuals/calci/SIGNTEST | SIGNTEST ]] | *[[Manuals/calci/SIGNTEST | SIGNTEST ]] | ||
| − | *[[Manuals/calci/ | + | *[[Manuals/calci/STATS | STATS ]] |
| + | *[[Manuals/calci/BINOMIALPROBABILITY | BINOMIALPROBABILITY ]] | ||
*[[Manuals/calci/FRIEDMANTEST | FRIEDMANTEST ]] | *[[Manuals/calci/FRIEDMANTEST | FRIEDMANTEST ]] | ||
*[[Manuals/calci/MOODSMEDIANTEST | MOODSMEDIANTEST ]] | *[[Manuals/calci/MOODSMEDIANTEST | MOODSMEDIANTEST ]] | ||
| Line 130: | Line 132: | ||
===Date and Time=== | ===Date and Time=== | ||
*[[Manuals/calci/DATE | DATE ]] | *[[Manuals/calci/DATE | DATE ]] | ||
| − | *[[Manuals/calci/ | + | *[[Manuals/calci/DATEVALUE | DATEVALUE ]] |
*[[Manuals/calci/DAY | DAY ]] | *[[Manuals/calci/DAY | DAY ]] | ||
*[[Manuals/calci/DAYS360 | DAYS360 ]] | *[[Manuals/calci/DAYS360 | DAYS360 ]] | ||
| Line 191: | Line 193: | ||
===Financial=== | ===Financial=== | ||
| − | *[[Manuals/calci/ACCRINT | ACCRINT ]] | + | *[[Manuals/calci/ACCRINT | ACCRINT ]] |
| − | *[[Manuals/calci/AMORDEGRC | AMORDEGRC ]] | + | *[[Manuals/calci/accrintm | accrintm ]] |
| − | *[[Manuals/calci/AMORLINC | AMORLINC ]] | + | *[[Manuals/calci/AMORDEGRC | AMORDEGRC ]] |
| − | *[[Manuals/calci/COUPDAYBS | COUPDAYBS ]] | + | *[[Manuals/calci/AMORLINC | AMORLINC ]] |
| − | *[[Manuals/calci/COUPDAYS | COUPDAYS | + | *[[Manuals/calci/COUPDAYBS | COUPDAYBS ]] |
| − | *[[Manuals/calci/COUPDAYSNC | COUPDAYSNC ]] | + | *[[Manuals/calci/COUPDAYS | COUPDAYS ]] |
| − | *[[Manuals/calci/COUPNUM | COUPNUM ]] | + | *[[Manuals/calci/COUPDAYSNC | COUPDAYSNC ]] |
| − | *[[Manuals/calci/DDB | DDB ]] | + | *[[Manuals/calci/coupncd |coupncd ]] |
| − | *[[Manuals/calci/DISC | DISC ]] | + | *[[Manuals/calci/COUPNUM | COUPNUM ]] |
| − | *[[Manuals/calci/DOLLARDE | DOLLARDE ]] | + | *[[Manuals/calci/couppcd | couppcd ]] |
| − | *[[Manuals/calci/DOLLARFR | DOLLARFR ]] | + | *[[Manuals/calci/cumipmt| cumipmt]] |
| − | *[[Manuals/calci/EFFECT | EFFECT ]] | + | *[[Manuals/calci/cumprinc | cumprinc ]] |
| − | *[[Manuals/calci/INTRATE | INTRATE ]] | + | *[[Manuals/calci/db | db ]] |
| − | *[[Manuals/calci/IPMT | IPMT ]] | + | *[[Manuals/calci/DDB | DDB ]] |
| − | *[[Manuals/calci/ISPMT | ISPMT | + | *[[Manuals/calci/DISC | DISC ]] |
| − | *[[Manuals/calci/LOGEST | LOGEST | + | *[[Manuals/calci/DOLLAR | DOLLAR ]] |
| − | *[[Manuals/calci/MDURATION | MDURATION ]] | + | *[[Manuals/calci/DOLLARDE | DOLLARDE ]] |
| − | *[[Manuals/calci/ | + | *[[Manuals/calci/DOLLARFR | DOLLARFR ]] |
| − | *[[Manuals/calci/ | + | *[[Manuals/calci/DURATION |DURATION ]] |
| − | *[[Manuals/calci/ | + | *[[Manuals/calci/EFFECT | EFFECT ]] |
| − | *[[Manuals/calci/ | + | *[[Manuals/calci/FV | FV ]] |
| − | *[[Manuals/calci/ | + | *[[Manuals/calci/FVSCHEDULE | FVSCHEDULE]] |
| − | *[[Manuals/calci/ODDLPRICE | ODDLPRICE ]] | + | *[[Manuals/calci/INTRATE | INTRATE ]] |
| + | *[[Manuals/calci/IPMT | IPMT ]] | ||
| + | *[[Manuals/calci/IRR | IRR ]] | ||
| + | *[[Manuals/calci/ISPMT |ISPMT]] | ||
| + | *[[Manuals/calci/LOGEST | LOGEST ]] | ||
| + | *[[Manuals/calci/MDURATION | MDURATION ]] | ||
| + | *[[Manuals/calci/MIRR | MIRR ]] | ||
| + | *[[Manuals/calci/NOMINAL |NOMINAL ]] | ||
| + | *[[Manuals/calci/NPER | NPER ]] | ||
| + | *[[Manuals/calci/NPV | NPV ]] | ||
| + | *[[Manuals/calci/ODDFPRICE | ODDFPRICE ]] | ||
| + | *[[Manuals/calci/ODDFYIELD | ODDFYIELD ]] | ||
| + | *[[Manuals/calci/ODDLPRICE | ODDLPRICE ]] | ||
| + | *[[Manuals/calci/ODDLYIELD | ODDLYIELD]] | ||
| + | *[[Manuals/calci/PMT | PMT ]] | ||
| + | *[[Manuals/calci/PPMT |PPMT ]] | ||
| + | *[[Manuals/calci/PRICE | PRICE ]] | ||
| + | *[[Manuals/calci/PRICEDISC | PRICEDISC ]] | ||
| + | *[[Manuals/calci/PRICEMAT | PRICEMAT ]] | ||
*[[Manuals/calci/PV | PV ]] | *[[Manuals/calci/PV | PV ]] | ||
| − | *[[Manuals/calci/ | + | *[[Manuals/calci/RATE | RATE ]] |
| − | *[[Manuals/calci/ | + | *[[Manuals/calci/RECEIVED | RECEIVED ]] |
| − | *[[Manuals/calci/ | + | *[[Manuals/calci/SLN | SLN ]] |
| − | *[[Manuals/calci/ | + | *[[Manuals/calci/SYD | SYD ]] |
| − | *[[Manuals/calci/ | + | *[[Manuals/calci/TBILLEQ | TBILLEQ ]] |
| − | *[[Manuals/calci/ | + | *[[Manuals/calci/TBILLPRICE | TBILLPRICE ]] |
| − | *[[Manuals/calci/ | + | *[[Manuals/calci/TBILLYIELD | TBILLYIELD ]] |
| − | *[[Manuals/calci/ | + | *[[Manuals/calci/VDB | VDB ]] |
| − | *[[Manuals/calci/ | + | *[[Manuals/calci/XIRR | XIRR ]] |
| − | *[[Manuals/calci/ | + | *[[Manuals/calci/XNPV | XNPV ]] |
| − | *[[Manuals/calci/ | + | *[[Manuals/calci/YIELD | YIELD ]] |
| + | *[[Manuals/calci/YIELDDISC | YIELDDISC ]] | ||
| + | *[[Manuals/calci/YIELDMAT | YIELDMAT ]] | ||
===Geometry=== | ===Geometry=== | ||
| Line 289: | Line 311: | ||
*[[Manuals/calci/COTAN | COTAN ]] | *[[Manuals/calci/COTAN | COTAN ]] | ||
*[[Manuals/calci/COTH | COTH ]] | *[[Manuals/calci/COTH | COTH ]] | ||
| + | *[[Manuals/calci/CSCH | CSCH ]] | ||
*[[Manuals/calci/DEGREES | DEGREES ]] | *[[Manuals/calci/DEGREES | DEGREES ]] | ||
*[[Manuals/calci/EVEN | EVEN ]] | *[[Manuals/calci/EVEN | EVEN ]] | ||
| Line 324: | Line 347: | ||
*[[Manuals/calci/ROUNDDOWN | ROUNDDOWN ]] | *[[Manuals/calci/ROUNDDOWN | ROUNDDOWN ]] | ||
*[[Manuals/calci/ROUNDUP | ROUNDUP ]] | *[[Manuals/calci/ROUNDUP | ROUNDUP ]] | ||
| + | *[[Manuals/calci/SEC | SEC ]] | ||
| + | *[[Manuals/calci/SECH | SECH ]] | ||
*[[Manuals/calci/SERIESSUM | SERIESSUM ]] | *[[Manuals/calci/SERIESSUM | SERIESSUM ]] | ||
*[[Manuals/calci/SIGN | SIGN ]] | *[[Manuals/calci/SIGN | SIGN ]] | ||
| + | *[[Manuals/calci/SIN | SIN ]] | ||
| + | *[[Manuals/calci/SINH | SINH ]] | ||
*[[Manuals/calci/SQRT | SQRT ]] | *[[Manuals/calci/SQRT | SQRT ]] | ||
*[[Manuals/calci/SQRTPI | SQRTPI ]] | *[[Manuals/calci/SQRTPI | SQRTPI ]] | ||
| Line 336: | Line 363: | ||
*[[Manuals/calci/SUMX2PY2 | SUMX2PY2 ]] | *[[Manuals/calci/SUMX2PY2 | SUMX2PY2 ]] | ||
*[[Manuals/calci/SUMXMY2 | SUMXMY2 ]] | *[[Manuals/calci/SUMXMY2 | SUMXMY2 ]] | ||
| + | *[[Manuals/calci/TAN| TAN ]] | ||
| + | *[[Manuals/calci/TANH | TANH ]] | ||
*[[Manuals/calci/TRUNC | TRUNC ]] | *[[Manuals/calci/TRUNC | TRUNC ]] | ||
*[[Manuals/calci/VECTOR | VECTOR ]] | *[[Manuals/calci/VECTOR | VECTOR ]] | ||
| Line 347: | Line 376: | ||
*[[Manuals/calci/EXACT | EXACT ]] | *[[Manuals/calci/EXACT | EXACT ]] | ||
*[[Manuals/calci/FIND | FIND ]] | *[[Manuals/calci/FIND | FIND ]] | ||
| + | *[[Manuals/calci/FINDB | FINDB ]] | ||
*[[Manuals/calci/FIXED | FIXED ]] | *[[Manuals/calci/FIXED | FIXED ]] | ||
*[[Manuals/calci/LEFT | LEFT ]] | *[[Manuals/calci/LEFT | LEFT ]] | ||
| Line 368: | Line 398: | ||
*[[Manuals/calci/UPPER | UPPER ]] | *[[Manuals/calci/UPPER | UPPER ]] | ||
*[[Manuals/calci/VALUE | VALUE ]] | *[[Manuals/calci/VALUE | VALUE ]] | ||
| + | |||
| + | ===Matrix Functions=== | ||
| + | *[[Manuals/calci/ANTIDIAGONAL | ANTIDIAGONAL ]] | ||
| + | *[[Manuals/calci/ANTISYMMETRIC | ANTISYMMETRIC ]] | ||
| + | *[[Manuals/calci/ARROWHEAD | ARROWHEAD ]] | ||
| + | *[[Manuals/calci/BIDIAGONAL | BIDIAGONAL ]] | ||
| + | *[[Manuals/calci/BLOCKDIAGONAL | BLOCKDIAGONAL ]] | ||
| + | *[[Manuals/calci/CENTROSYMMETRIC | CENTROSYMMETRIC ]] | ||
| + | *[[Manuals/calci/CHOLESKY | CHOLESKY ]] | ||
| + | *[[Manuals/calci/CIRCULANT | CIRCULANT ]] | ||
| + | *[[Manuals/calci/CONFERENCE | CONFERENCE ]] | ||
| + | *[[Manuals/calci/EXCHANGE | EXCHANGE ]] | ||
| + | *[[Manuals/calci/FROBENIUS | FROBENIUS ]] | ||
| + | *[[Manuals/calci/HADAMARD | HADAMARD ]] | ||
| + | *[[Manuals/calci/HANKEL | HANKEL ]] | ||
| + | *[[Manuals/calci/HERMITIAN | HERMITIAN ]] | ||
| + | *[[Manuals/calci/HESSENBERG | HESSENBERG ]] | ||
| + | *[[Manuals/calci/HILBERT | HILBERT ]] | ||
| + | *[[Manuals/calci/HOLLOW | HOLLOW ]] | ||
| + | *[[Manuals/calci/IDEMPOTENT | IDEMPOTENT ]] | ||
| + | *[[Manuals/calci/IDENTITY | IDENTITY ]] | ||
| + | *[[Manuals/calci/INTEGER | INTEGER ]] | ||
| + | *[[Manuals/calci/LEHMER | LEHMER ]] | ||
| + | *[[Manuals/calci/MATRIXOPERATORS | MATRIXOPERATORS ]] | ||
| + | *[[Manuals/calci/METZLER | METZLER ]] | ||
| + | *[[Manuals/calci/MONOMIAL | MONOMIAL ]] | ||
| + | *[[Manuals/calci/MOORE | MOORE ]] | ||
| + | *[[Manuals/calci/NEGZEROPOS | NEGZEROPOS ]] | ||
| + | *[[Manuals/calci/PASCAL | PASCAL ]] | ||
| + | *[[Manuals/calci/PENTADIAGONAL | PENTADIAGONAL ]] | ||
| + | *[[Manuals/calci/PERMUTATION | PERMUTATION ]] | ||
| + | *[[Manuals/calci/PERSYMMETRIC | PERSYMMETRIC ]] | ||
| + | *[[Manuals/calci/REDHEFFER | REDHEFFER ]] | ||
| + | *[[Manuals/calci/SHIFT | SHIFT ]] | ||
| + | *[[Manuals/calci/SIGNATURE | SIGNATURE ]] | ||
| + | *[[Manuals/calci/SYMMETRIC | SYMMETRIC ]] | ||
| + | *[[Manuals/calci/TOEPLITZ | TOEPLITZ ]] | ||
| + | *[[Manuals/calci/TRIANGULAR | TRIANGULAR ]] | ||
| + | *[[Manuals/calci/TRIDIAGONAL | TRIDIAGONAL ]] | ||
| + | *[[Manuals/calci/VANDERMONDE | VANDERMONDE ]] | ||
===Other Functions=== | ===Other Functions=== | ||
Latest revision as of 00:21, 10 May 2017
LIST OF ALL FUNCTIONS
Statistical Functions
- AVEDEV
- AVERAGE
- AVERAGEA
- Bartlett's Test
- BERNOULLI
- BETADIST
- BETAINV
- BINOMDIST
- BINOMIAL
- CHIDIST
- CHIINV
- CHITEST
- CONFIDENCE
- CORREL
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- COVAR
- COVARIANCE
- CRITBINOM
- DESCRIPTIVESTATISTICS
- DEVSQ
- DISCRETE
- EXPONDIST
- EXPONENTIALSMOOTHING
- FDIST
- FINV
- FISHER
- FISHERINV
- FORECAST
- FREQUENCY
- FTEST
- FTESTANALYSIS
- GAMMADIST
- GAMMAINV
- GAMMALN
- GEOMEAN
- GROWTH
- HARMEAN
- HISTOGRAM
- HYPGEOMDIST
- INTERCEPT
- KURT
- LARGE
- LINEST
- LOGINV
- LOGNORMDIST
- MAX
- MAXA
- MEDIAN
- MIN
- MINA
- MODE
- MOVINGAVERAGE
- NEGBINOMDIST
- NORMDIST
- NORMINV
- NORMSDIST
- NORMSINV
- PASCALTRIANGLE
- PATTERNED
- PEARSON
- PERCENTILE
- PERCENTRANK
- PERMUT
- poisson
- POISSONDISTRIBUTION
- PROB
- QUARTILE
- RANK
- RANKANDPERCENTILE
- REGRESSION
- RSQ
- SAMPLING
- SKEW
- SLOPE
- SMALL
- STANDARDIZE
- STDEV
- STDEVA
- STDEVP
- STDEVPA
- STEYX
- TDIST
- TINV
- TREND
- TRIMMEAN
- TTEST
- TTESTEQUALVARIANCES
- TTESTPAIRED
- TTESTUNEQUALVARIANCES
- UNIFORM
- VAR
- VARA
- VARP
- VARPA
- WEIBULL
- ZTEST
- ZTESTEQUALMEANS
- NORMAL
- LEVENESTEST
- MULTIPLEREGRESSIONANALYSIS
- WILCOXONSIGNEDRANKTEST
- MANNWHITNEYUTEST
- KRUSKALWALLISTEST
- SIGNTEST
- STATS
- BINOMIALPROBABILITY
- FRIEDMANTEST
- MOODSMEDIANTEST
- KSTESTNORMAL
- RIEMANNZETA
Database and List Management
Date and Time
- DATE
- DATEVALUE
- DAY
- DAYS360
- DAYSBETWEEN
- EDATE
- EOMONTH
- HOUR
- MINUTE
- MONTH
- NETWORKDAYS
- SECOND
- TIME
- TIMEVALUE
- WEEKDAY
- WEEKNUM
- WORKDAY
- YEAR
- YEARFRAC
Engineering
- BESSELI
- BESSELJ
- BESSELK
- BESSELY
- BIN2DEC
- BIN2HEX
- BIN2OCT
- COMPLEX
- CONVERT
- DEC2BIN
- DEC2HEX
- DEC2OCT
- DELTA
- ERF
- ERFC
- GESTEP
- HEX2BIN
- HEX2DEC
- HEX2OCT
- IMABS
- IMAGINARY
- IMARGUMENT
- IMCONJUGATE
- IMCOS
- IMDIV
- IMEXP
- IMLN
- IMLOG10
- IMLOG2
- IMPOWER
- IMPRODUCT
- IMREAL
- IMSIN
- IMSQRT
- IMSUB
- IMSUM
- OCT2BIN
- OCT2DEC
- OCT2HEX
Financial
- ACCRINT
- accrintm
- AMORDEGRC
- AMORLINC
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- coupncd
- COUPNUM
- couppcd
- cumipmt
- cumprinc
- db
- DDB
- DISC
- DOLLAR
- DOLLARDE
- DOLLARFR
- DURATION
- EFFECT
- FV
- FVSCHEDULE
- INTRATE
- IPMT
- IRR
- ISPMT
- LOGEST
- MDURATION
- MIRR
- NOMINAL
- NPER
- NPV
- ODDFPRICE
- ODDFYIELD
- ODDLPRICE
- ODDLYIELD
- PMT
- PPMT
- PRICE
- PRICEDISC
- PRICEMAT
- PV
- RATE
- RECEIVED
- SLN
- SYD
- TBILLEQ
- TBILLPRICE
- TBILLYIELD
- VDB
- XIRR
- XNPV
- YIELD
- YIELDDISC
- YIELDMAT
Geometry
Information
- CELL
- EUROCONVERT
- GOLDENANGLE
- GOLDENRATIO
- help
- IS FUNCTIONS
- ISBLANK
- ISEVEN
- ISLEAPYEAR
- ISLOGICAL
- ISNUMBER
- ISODD
- ISPRIME
- ISTEXT
- N
Logical
Lookup and Reference
- ADDRESS
- AREAS
- CHOOSE
- COLUMN
- COLUMNS
- HLOOKUP
- HYPERLINK
- INDEX
- INDIRECT
- LOOKUP
- MATCH
- NOT
- OFFSET
- ROW
- ROWS
- TRANSPOSE
- VLOOKUP
Math
- ABS
- calci_sum
- CEILING
- COMBIN
- COS
- COSEC
- COSH
- COTAN
- COTH
- CSCH
- DEGREES
- EVEN
- EXP
- FACT
- FACTDOUBLE
- FIBONNACI
- FLOOR
- FOURIERANALYSIS
- GCD
- INT
- ITHPRIME
- LCM
- LISTPRIMES
- LN
- LOG
- LOG10
- LUCAS
- MDETERM
- MINVERSE
- MMULT
- MOD
- MROUND
- MULTINOMIAL
- ODD
- PI
- POWER
- PRODUCT
- QUOTIENT
- RADIANS
- RAND
- RANDBETWEEN
- ROMAN
- ROUND
- ROUNDDOWN
- ROUNDUP
- SEC
- SECH
- SERIESSUM
- SIGN
- SIN
- SINH
- SQRT
- SQRTPI
- SUBTOTAL
- SUM
- SUMIF
- SUMPRODUCT
- SUMSQ
- SUMX2MY2
- SUMX2PY2
- SUMXMY2
- TAN
- TANH
- TRUNC
- VECTOR
Text and Data
- CHAR
- CLEAN
- CODE
- CONCATENATE
- DOLLAR
- EXACT
- FIND
- FINDB
- FIXED
- LEFT
- LEFTB
- LEN
- LENB
- LOWER
- MID
- MIDB
- PROPER
- REPLACE
- REPLACEB
- REPT
- RIGHT
- RIGHTB
- SEARCH
- SEARCHB
- SUBSTITUTE
- T
- TRIM
- UPPER
- VALUE
Matrix Functions
- ANTIDIAGONAL
- ANTISYMMETRIC
- ARROWHEAD
- BIDIAGONAL
- BLOCKDIAGONAL
- CENTROSYMMETRIC
- CHOLESKY
- CIRCULANT
- CONFERENCE
- EXCHANGE
- FROBENIUS
- HADAMARD
- HANKEL
- HERMITIAN
- HESSENBERG
- HILBERT
- HOLLOW
- IDEMPOTENT
- IDENTITY
- INTEGER
- LEHMER
- MATRIXOPERATORS
- METZLER
- MONOMIAL
- MOORE
- NEGZEROPOS
- PASCAL
- PENTADIAGONAL
- PERMUTATION
- PERSYMMETRIC
- REDHEFFER
- SHIFT
- SIGNATURE
- SYMMETRIC
- TOEPLITZ
- TRIANGULAR
- TRIDIAGONAL
- VANDERMONDE