Difference between revisions of "Template:Calc functions"
From Apache OpenOffice Wiki
m |
(Added list of Stats functions) |
||
| Line 50: | Line 50: | ||
'''[[Documentation/How_Tos/Calc: Statistical functions|Statistical functions]]''' | '''[[Documentation/How_Tos/Calc: Statistical functions|Statistical functions]]''' | ||
| − | :The Statistical functions | + | :The Statistical functions provide statistical and probability calculations. |
| + | :[[Documentation/How_Tos/Calc: AVEDEV function|AVEDEV]] [[Documentation/How_Tos/Calc: AVERAGE function|AVERAGE]] [[Documentation/How_Tos/Calc: AVERAGEA function|AVERAGEA]] [[Documentation/How_Tos/Calc: B function|B]] [[Documentation/How_Tos/Calc: BETADIST function|BETADIST]] [[Documentation/How_Tos/Calc: BETAINV function|BETAINV]] [[Documentation/How_Tos/Calc: BINOMDIST function|BINOMDIST]] [[Documentation/How_Tos/Calc: COUNT function|COUNT]] [[Documentation/How_Tos/Calc: COUNTA function|COUNTA]] [[Documentation/How_Tos/Calc: CHIINV function|CHIINV]] [[Documentation/How_Tos/Calc: CHITEST function|CHITEST]] [[Documentation/How_Tos/Calc: CHIDIST function|CHIDIST]] [[Documentation/How_Tos/Calc: CONFIDENCE function|CONFIDENCE]] [[Documentation/How_Tos/Calc: CORREL function|CORREL]] [[Documentation/How_Tos/Calc: COVAR function|COVAR]] [[Documentation/How_Tos/Calc: CRITBINOM function|CRITBINOM]] [[Documentation/How_Tos/Calc: DEVSQ function|DEVSQ]] [[Documentation/How_Tos/Calc: EXPONDIST function|EXPONDIST]] [[Documentation/How_Tos/Calc: FINV function|FINV]] [[Documentation/How_Tos/Calc: FISHER function|FISHER]] [[Documentation/How_Tos/Calc: FISHERINV function|FISHERINV]] [[Documentation/How_Tos/Calc: FDIST function|FDIST]] [[Documentation/How_Tos/Calc: FORECAST function|FORECAST]] [[Documentation/How_Tos/Calc: FTEST function|FTEST]] [[Documentation/How_Tos/Calc: GAMMAINV function|GAMMAINV]] [[Documentation/How_Tos/Calc: GAMMALN function|GAMMALN]] [[Documentation/How_Tos/Calc: GAMMADIST function|GAMMADIST]] [[Documentation/How_Tos/Calc: GAUSS function|GAUSS]] [[Documentation/How_Tos/Calc: GEOMEAN function|GEOMEAN]] [[Documentation/How_Tos/Calc: HARMEAN function|HARMEAN]] [[Documentation/How_Tos/Calc: HYPGEOMDIST function|HYPGEOMDIST]] [[Documentation/How_Tos/Calc: INTERCEPT function|INTERCEPT]] [[Documentation/How_Tos/Calc: KURT function|KURT]] [[Documentation/How_Tos/Calc: LARGE function|LARGE]] [[Documentation/How_Tos/Calc: LOGINV function|LOGINV]] [[Documentation/How_Tos/Calc: LOGNORMDIST function|LOGNORMDIST]] [[Documentation/How_Tos/Calc: MAX function|MAX]] [[Documentation/How_Tos/Calc: MAXA function|MAXA]] [[Documentation/How_Tos/Calc: MEDIAN function|MEDIAN]] [[Documentation/How_Tos/Calc: MIN function|MIN]] [[Documentation/How_Tos/Calc: MINA function|MINA]] [[Documentation/How_Tos/Calc: MODE function|MODE]] [[Documentation/How_Tos/Calc: NEGBINOMDIST function|NEGBINOMDIST]] [[Documentation/How_Tos/Calc: NORMINV function|NORMINV]] [[Documentation/How_Tos/Calc: NORMDIST function|NORMDIST]] [[Documentation/How_Tos/Calc: NORMSINV function|NORMSINV]] [[Documentation/How_Tos/Calc: NORMSDIST function|NORMSDIST]] [[Documentation/How_Tos/Calc: PEARSON function|PEARSON]] [[Documentation/How_Tos/Calc: PERCENTILE function|PERCENTILE]] [[Documentation/How_Tos/Calc: PERCENTRANK function|PERCENTRANK]] [[Documentation/How_Tos/Calc: PERMUT function|PERMUT]] [[Documentation/How_Tos/Calc: PERMUTATIONA function|PERMUTATIONA]] [[Documentation/How_Tos/Calc: PHI function|PHI]] [[Documentation/How_Tos/Calc: POISSON function|POISSON]] [[Documentation/How_Tos/Calc: PROB function|PROB]] [[Documentation/How_Tos/Calc: QUARTILE function|QUARTILE]] [[Documentation/How_Tos/Calc: RANK function|RANK]] [[Documentation/How_Tos/Calc: RSQ function|RSQ]] [[Documentation/How_Tos/Calc: SKEW function|SKEW]] [[Documentation/How_Tos/Calc: SLOPE function|SLOPE]] [[Documentation/How_Tos/Calc: SMALL function|SMALL]] [[Documentation/How_Tos/Calc: STANDARDIZE function|STANDARDIZE]] [[Documentation/How_Tos/Calc: STDEV function|STDEV]] [[Documentation/How_Tos/Calc: STDEVA function|STDEVA]] [[Documentation/How_Tos/Calc: STDEVP function|STDEVP]] [[Documentation/How_Tos/Calc: STDEVPA function|STDEVPA]] [[Documentation/How_Tos/Calc: STEYX function|STEYX]] [[Documentation/How_Tos/Calc: TDIST function|TDIST]] [[Documentation/How_Tos/Calc: TINV function|TINV]] [[Documentation/How_Tos/Calc: TRIMMEAN function|TRIMMEAN]] [[Documentation/How_Tos/Calc: TTEST function|TTEST]] [[Documentation/How_Tos/Calc: VAR function|VAR]] [[Documentation/How_Tos/Calc: VARA function|VARA]] [[Documentation/How_Tos/Calc: VARP function|VARP]] [[Documentation/How_Tos/Calc: VARPA function|VARPA]] [[Documentation/How_Tos/Calc: WEIBULL function|WEIBULL]] [[Documentation/How_Tos/Calc: ZTEST function|ZTEST]] | ||
'''[[Documentation/How_Tos/Calc: Spreadsheet functions|Spreadsheet functions]]''' | '''[[Documentation/How_Tos/Calc: Spreadsheet functions|Spreadsheet functions]]''' | ||
Revision as of 07:29, 3 April 2008
Calc functions listed by category
These pages are a complete rewrite of the Function Help for Calc. Not all functions are included yet. The aim is for descriptions to be more precise, complete and consistent than before.
You may
- navigate directly to the functions from this page, or
- select a function category, to find a one line description of each function and some explanatory notes on the category.
- The Complex Number functions operate on (mathematical) complex numbers such as 2 + 3i.
- COMPLEX, IMABS, IMAGINARY, IMPOWER, IMARGUMENT, IMCOS, IMDIV, IMEXP, IMCONJUGATE, IMLN, IMLOG10, IMLOG2, IMPRODUCT, IMREAL, IMSIN, IMSUB, IMSUM, IMSQRT
- The Database functions are used to extract information from Calc data tables, where data is organised in rows.
- DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DAVERAGE, DPRODUCT, DSTDEV, DSTDEVP, DSUM, DVAR, DVARP
- The Date & Time functions are used to manipulate dates and times.
- TODAY, NOW, YEAR, MONTH, DAY, WEEKDAY, HOUR, MINUTE, SECOND, DATE, DATEVALUE, TIME, TIMEVALUE, EOMONTH, EDATE, WORKDAY, NETWORKDAYS, DAYS, DAYS360, DAYSINMONTH, DAYSINYEAR, WEEKS, WEEKSINYEAR, WEEKNUM, WEEKNUM_ADD, MONTHS, YEARS, ISLEAPYEAR, EASTERSUNDAY, YEARFRAC
- The Financial functions provide common business calculations.
- The Information functions return information about cells, such as whether they contain text or a formula, etc.
- CELL, CURRENT, FORMULA, ISBLANK, ISERR, ISERROR, ISEVEN, ISEVEN_ADD, ISFORMULA, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISODD, ISODD_ADD, ISREF, ISTEXT, N, NA, TYPE
- The Logical functions include boolean logic AND, OR, NOT functions, and functions such as IF which test a logical result.
- AND, FALSE, IF, NOT, OR, TRUE
- The Mathematical functions include trigonometric, hyperbolic, logarithmic and summation functions.
- COS, SIN, TAN, COT, ACOS, ACOT, ASIN, ATAN, ATAN2, DEGREES, RADIANS, PI
- COSH, SINH, TANH, COTH, ACOSH, ACOTH, ASINH, ATANH
- TRUNC, ROUND, ROUNDDOWN, ROUNDUP, CEILING, FLOOR, EVEN, ODD, MROUND, INT, QUOTIENT, MOD
- EXP, POWER, LOG, LN, LOG10
- ABS, COMBIN, COMBINA, CONVERT, CONVERT_ADD, COUNTBLANK, COUNTIF, DELTA, ERF, ERFC, FACT, FACTDOUBLE, GCD, GCD_ADD, GESTEP, ISEVEN, ISODD, LCM, LCM_ADD, MULTINOMIAL, PRODUCT, RAND, RANDBETWEEN, SERIESSUM, SIGN, SQRT, SQRTPI, SUBTOTAL, SUM, SUMIF, SUMSQ
- BESSELI, BESSELJ, BESSELK, BESSELY
- The Number Conversion functions convert numbers between forms.
- BIN2DEC, BIN2HEX, BIN2OCT, DEC2BIN, DEC2HEX, DEC2OCT, HEX2BIN, HEX2DEC, HEX2OCT, OCT2BIN, OCT2DEC, OCT2HEX
- ARABIC, BAHTTEXT, DECIMAL, ROMAN
- The Array functions operate on and return entire tables of data.
- FREQUENCY, GROWTH, LINEST, LOGEST, MDETERM, MINVERSE, MMULT, MUNIT, SUMPRODUCT, SUMX2MY2, SUMX2PY2, SUMXMY2, TRANSPOSE, TREND
- The Statistical functions provide statistical and probability calculations.
- AVEDEV AVERAGE AVERAGEA B BETADIST BETAINV BINOMDIST COUNT COUNTA CHIINV CHITEST CHIDIST CONFIDENCE CORREL COVAR CRITBINOM DEVSQ EXPONDIST FINV FISHER FISHERINV FDIST FORECAST FTEST GAMMAINV GAMMALN GAMMADIST GAUSS GEOMEAN HARMEAN HYPGEOMDIST INTERCEPT KURT LARGE LOGINV LOGNORMDIST MAX MAXA MEDIAN MIN MINA MODE NEGBINOMDIST NORMINV NORMDIST NORMSINV NORMSDIST PEARSON PERCENTILE PERCENTRANK PERMUT PERMUTATIONA PHI POISSON PROB QUARTILE RANK RSQ SKEW SLOPE SMALL STANDARDIZE STDEV STDEVA STDEVP STDEVPA STEYX TDIST TINV TRIMMEAN TTEST VAR VARA VARP VARPA WEIBULL ZTEST
