geckon01/PhpSpreadsheet
1
0
Fork 0
mirror of https://github.com/PHPOffice/PhpSpreadsheet.git synced 2026-08-20 21:21:02 +00:00
Code Issues Packages Projects Releases Wiki Activity
Files
Experiment-Maintaining-Excel-Function-List-as-an-ArrayObject-2
PhpSpreadsheet/tests/data/Calculation/Statistical
T
History
Mark Baker d5dc58d20e Extract information functions (#2605) 
* Split Information functions into a dedicated class and namespace and categorise as Value or Error
* Refactor all error functions into the new ExcelError class
2022-02-19 13:53:17 +01:00
..
AVEDEV.php
Difference in variance calculations between Excel/Gnumeric and Open/LibreOffice (#1959)
2021-03-27 18:31:24 +01:00
AVERAGE.php
Difference in variance calculations between Excel/Gnumeric and Open/LibreOffice (#1959)
2021-03-27 18:31:24 +01:00
AVERAGEA.php
Difference in variance calculations between Excel/Gnumeric and Open/LibreOffice (#1959)
2021-03-27 18:31:24 +01:00
AVERAGEIF.php
Initial experiments using the new Database query logic with Conditional Statistical Functions (#1880)
2021-02-27 18:26:12 +01:00
AVERAGEIFS.php
Additional conditionals from math trig (#1885)
2021-02-28 10:24:33 +01:00
BasicCOUNT.php
Update PHP-CS-Fixer rules
2020-05-18 13:49:57 +09:00
BETADIST.php
Use validation classes rather than traits for Statistical functions, … (#1999)
2021-04-13 16:56:21 +02:00
BETAINV.php
Use validation classes rather than traits for Statistical functions, … (#1999)
2021-04-13 16:56:21 +02:00
BINOMDIST.php
Extract Binomial Distribution functions from Statistical (#1974)
2021-03-30 22:49:10 +02:00
BINOMDISTRANGE.php
Use validation classes rather than traits for Statistical functions, … (#1999)
2021-04-13 16:56:21 +02:00
BINOMINV.php
Extract Binomial Distribution functions from Statistical (#1974)
2021-03-30 22:49:10 +02:00
CHIDISTLeftTail.php
Implemented the CHISQ.DIST() Statistical function. (#1961)
2021-03-28 16:13:00 +02:00
CHIDISTRightTail.php
Implemented the CHISQ.DIST() Statistical function. (#1961)
2021-03-28 16:13:00 +02:00
CHIINVLeftTail.php
Chi squared inverse left tailed (#1964)
2021-03-28 19:12:45 +02:00
CHIINVRightTail.php
Implemented the CHISQ.DIST() Statistical function. (#1961)
2021-03-28 16:13:00 +02:00
CHITEST.php
Implementation of the CHITEST() statistical function (#1960)
2021-03-27 22:04:05 +01:00
CONFIDENCE.php
Additional statistical unit tests for non-happy path (#1594)
2020-07-25 21:58:08 +02:00
CORREL.php
Additional statistical unit tests for non-happy path (#1594)
2020-07-25 21:58:08 +02:00
COUNTA.php
Update PHP-CS-Fixer rules
2020-05-18 13:49:57 +09:00
COUNTBLANK.php
Statistical issues (#1098)
2019-07-20 18:40:05 +02:00
COUNTIF.php
Initial experiments using the new Database query logic with Conditional Statistical Functions (#1880)
2021-02-27 18:26:12 +01:00
COUNTIFS.php
Additional conditionals from math trig (#1885)
2021-02-28 10:24:33 +01:00
COVAR.php
Statistics more unit tests (#1889)
2021-03-02 18:01:39 +01:00
DEVSQ.php
Start work on refactoring the last of the Excel Statistical functions (#2033)
2021-04-29 14:34:50 +02:00
ExcelCOUNT.php
Statistical issues (#1098)
2019-07-20 18:40:05 +02:00
EXPONDIST.php
Extract a few more Distribution functions from Statistical (#1975)
2021-03-31 21:45:06 +02:00
FDIST.php
Extract a few more Distribution functions from Statistical (#1975)
2021-03-31 21:45:06 +02:00
FISHER.php
First steps toward refactoring Excel's Statistical Distributions (#1949)
2021-03-25 20:54:55 +01:00
FISHERINV.php
First steps toward refactoring Excel's Statistical Distributions (#1949)
2021-03-25 20:54:55 +01:00
FORECAST.php
Statistics more unit tests (#1889)
2021-03-02 18:01:39 +01:00
GAMMA.php
First steps toward refactoring Excel's Statistical Distributions (#1949)
2021-03-25 20:54:55 +01:00
GAMMADIST.php
First steps toward refactoring Excel's Statistical Distributions (#1949)
2021-03-25 20:54:55 +01:00
GAMMAINV.php
First steps toward refactoring Excel's Statistical Distributions (#1949)
2021-03-25 20:54:55 +01:00
GAMMALN.php
First steps toward refactoring Excel's Statistical Distributions (#1949)
2021-03-25 20:54:55 +01:00
GAUSS.php
Implementation of MS Excel's LOGNORM.DIST(), NORM.S.DIST(), F.DIST(), GAUSS() and GAMMA() functions (#1588)
2020-07-25 12:44:51 +02:00
GEOMEAN.php
Identify HYPGEOM.DIST() as a separate Excel function, and additional unit tests (including unhappy path) (#1595)
2020-07-26 22:10:53 +02:00
GnumericCOUNT.php
Statistical issues (#1098)
2019-07-20 18:40:05 +02:00
GROWTH.php
Statistical trends additional functions and unit tests (#1896)
2021-03-03 23:18:56 +01:00
HARMEAN.php
Start work on refactoring the last of the Excel Statistical functions (#2033)
2021-04-29 14:34:50 +02:00
HYPGEOMDIST.php
Extract a few more Distribution functions from Statistical (#1975)
2021-03-31 21:45:06 +02:00
INTERCEPT.php
Statistics more unit tests (#1889)
2021-03-02 18:01:39 +01:00
KURT.php
Start work on refactoring the last of the Excel Statistical functions (#2033)
2021-04-29 14:34:50 +02:00
LARGE.php
More unit tests for statistical functions, including a bugfix to LARGE() (#1601)
2020-07-29 23:56:37 +02:00
LINEST.php
Extract information functions (#2605)
2022-02-19 13:53:17 +01:00
LOGEST.php
Trend unit tests (#1899)
2021-03-06 22:50:19 +01:00
LOGINV.php
Extract Normal and Standard Normal Distributions from the Statistical Class (#1981)
2021-04-02 20:17:03 +02:00
LOGNORMDIST2.php
Extract Normal and Standard Normal Distributions from the Statistical Class (#1981)
2021-04-02 20:17:03 +02:00
LOGNORMDIST.php
Extract Normal and Standard Normal Distributions from the Statistical Class (#1981)
2021-04-02 20:17:03 +02:00
MAX.php
More unit tests for statistical functions, including a bugfix to LARGE() (#1601)
2020-07-29 23:56:37 +02:00
MAXA.php
A couple of extra unit tests
2021-05-14 14:35:23 +02:00
MAXIFS.php
Additional conditionals from math trig (#1885)
2021-02-28 10:24:33 +01:00
MEDIAN.php
Improved tests (#1110)
2019-07-26 22:21:17 +02:00
MIN.php
More unit tests for statistical functions, including a bugfix to LARGE() (#1601)
2020-07-29 23:56:37 +02:00
MINA.php
A couple of extra unit tests
2021-05-14 14:35:23 +02:00
MINIFS.php
Additional conditionals from math trig (#1885)
2021-02-28 10:24:33 +01:00
MODE.php
Save Excel 2010+ Functions Properly
2020-05-18 12:37:35 +09:00
NEGBINOMDIST.php
Extract Binomial Distribution functions from Statistical (#1974)
2021-03-30 22:49:10 +02:00
NORMDIST.php
Extract Normal and Standard Normal Distributions from the Statistical Class (#1981)
2021-04-02 20:17:03 +02:00
NORMINV.php
Extract Normal and Standard Normal Distributions from the Statistical Class (#1981)
2021-04-02 20:17:03 +02:00
NORMSDIST2.php
Extract Normal and Standard Normal Distributions from the Statistical Class (#1981)
2021-04-02 20:17:03 +02:00
NORMSDIST.php
Extract Normal and Standard Normal Distributions from the Statistical Class (#1981)
2021-04-02 20:17:03 +02:00
NORMSINV.php
Extract Normal and Standard Normal Distributions from the Statistical Class (#1981)
2021-04-02 20:17:03 +02:00
OpenOfficeCOUNT.php
Statistical issues (#1098)
2019-07-20 18:40:05 +02:00
PERCENTILE.php
Extract Percentile-type functions from Statistics (#1966)
2021-03-29 12:59:46 +02:00
PERCENTRANK.php
Extract Percentile-type functions from Statistics (#1966)
2021-03-29 12:59:46 +02:00
PERMUT.php
Extract Permutation functions from the Statistical class into a dedicated Permutations class (#1851)
2021-02-13 15:35:07 +01:00
PERMUTATIONA.php
Extract Percentile-type functions from Statistics (#1966)
2021-03-29 12:59:46 +02:00
POISSON.php
Extract Poisson distribution into its own class (#1953)
2021-03-26 09:08:23 +01:00
QUARTILE.php
Extract Percentile-type functions from Statistics (#1966)
2021-03-29 12:59:46 +02:00
RANK.php
Extract Percentile-type functions from Statistics (#1966)
2021-03-29 12:59:46 +02:00
RSQ.php
Statistics more unit tests (#1889)
2021-03-02 18:01:39 +01:00
SKEW.php
Start work on refactoring the last of the Excel Statistical functions (#2033)
2021-04-29 14:34:50 +02:00
SLOPE.php
Statistics more unit tests (#1889)
2021-03-02 18:01:39 +01:00
SMALL.php
More unit tests for statistical functions, including a bugfix to LARGE() (#1601)
2020-07-29 23:56:37 +02:00
STANDARDIZE.php
Start work on refactoring the last of the Excel Statistical functions (#2033)
2021-04-29 14:34:50 +02:00
STDEV_ODS.php
Difference in variance calculations between Excel/Gnumeric and Open/LibreOffice (#1959)
2021-03-27 18:31:24 +01:00
STDEV.php
Difference in variance calculations between Excel/Gnumeric and Open/LibreOffice (#1959)
2021-03-27 18:31:24 +01:00
STDEVA_ODS.php
Difference in variance calculations between Excel/Gnumeric and Open/LibreOffice (#1959)
2021-03-27 18:31:24 +01:00
STDEVA.php
Difference in variance calculations between Excel/Gnumeric and Open/LibreOffice (#1959)
2021-03-27 18:31:24 +01:00
STDEVP_ODS.php
Difference in variance calculations between Excel/Gnumeric and Open/LibreOffice (#1959)
2021-03-27 18:31:24 +01:00
STDEVP.php
Difference in variance calculations between Excel/Gnumeric and Open/LibreOffice (#1959)
2021-03-27 18:31:24 +01:00
STDEVPA_ODS.php
Difference in variance calculations between Excel/Gnumeric and Open/LibreOffice (#1959)
2021-03-27 18:31:24 +01:00
STDEVPA.php
Difference in variance calculations between Excel/Gnumeric and Open/LibreOffice (#1959)
2021-03-27 18:31:24 +01:00
STEYX.php
Additional statistical unit tests for non-happy path (#1594)
2020-07-25 21:58:08 +02:00
TDIST.php
Start implementing Newton-Raphson for the inverse of Statistical Distributions (#1958)
2021-03-27 13:29:58 +01:00
TINV.php
Start implementing Newton-Raphson for the inverse of Statistical Distributions (#1958)
2021-03-27 13:29:58 +01:00
TREND.php
Statistical refactoring - Confidence() and Trend() (#1898)
2021-03-04 21:45:56 +01:00
TRIMMEAN.php
Statistics more unit tests (#1889)
2021-03-02 18:01:39 +01:00
VAR_ODS.php
Difference in variance calculations between Excel/Gnumeric and Open/LibreOffice (#1959)
2021-03-27 18:31:24 +01:00
VAR.php
Difference in variance calculations between Excel/Gnumeric and Open/LibreOffice (#1959)
2021-03-27 18:31:24 +01:00
VARA_ODS.php
Difference in variance calculations between Excel/Gnumeric and Open/LibreOffice (#1959)
2021-03-27 18:31:24 +01:00
VARA.php
Difference in variance calculations between Excel/Gnumeric and Open/LibreOffice (#1959)
2021-03-27 18:31:24 +01:00
VARP_ODS.php
Difference in variance calculations between Excel/Gnumeric and Open/LibreOffice (#1959)
2021-03-27 18:31:24 +01:00
VARP.php
Difference in variance calculations between Excel/Gnumeric and Open/LibreOffice (#1959)
2021-03-27 18:31:24 +01:00
VARPA_ODS.php
Difference in variance calculations between Excel/Gnumeric and Open/LibreOffice (#1959)
2021-03-27 18:31:24 +01:00
VARPA.php
Difference in variance calculations between Excel/Gnumeric and Open/LibreOffice (#1959)
2021-03-27 18:31:24 +01:00
WEIBULL.php
Start implementing Newton-Raphson for the inverse of Statistical Distributions (#1958)
2021-03-27 13:29:58 +01:00
ZTEST.php
Use validation classes rather than traits for Statistical functions, … (#1999)
2021-04-13 16:56:21 +02:00